Search found 42 matches
- Fri Jul 29, 2016 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector failure - invalid LOB locator specififed
- Replies: 4
- Views: 5213
In order to use OCI LOB locators for all LongVarchar, LongNVarchar, and LongVarBinary columns, set the CC_ORA_LOB_LOCATOR_COLUMNS environment variable to (all) More information on https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.conn.envvar.ref.doc/topics/r_envvarora_cc_o...
- Fri Jul 29, 2016 10:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-22275: - invalid LOB locator specififed
- Replies: 4
- Views: 3930
Finally we were able to resolve the same. In order to use OCI LOB locators for all LongVarchar, LongNVarchar, and LongVarBinary columns, set the CC_ORA_LOB_LOCATOR_COLUMNS environment variable to (all) More information on https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.c...
- Tue Apr 12, 2016 11:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-22275: - invalid LOB locator specififed
- Replies: 4
- Views: 3930
- Mon Apr 11, 2016 6:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-22275: - invalid LOB locator specififed
- Replies: 4
- Views: 3930
ORA-22275: - invalid LOB locator specififed
Hi all, Please note, this is a similar issue to the below mentioned post. http://www.dsxchange.com/viewtopic.php?t=155789 Am trying to read and load 2 CLOB fields, I am using LongVarchar (4000) to read and load the data, Array size is set to 1 and the columns are at the end or the Oracle connector (...
- Thu Jan 21, 2016 9:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Orchestrate Schema Definition import error
- Replies: 0
- Views: 1739
Orchestrate Schema Definition import error
Hi all, Am trying to import a Sybase IQ table definition using the 'Orchestrate Schema Definition', The import wizard populates incorrect length for CHAR fields. Irrespective of the column length in the table - the import wizard populates CHAR (20) for all CHAR columns, When i try the Plug-in method...
- Tue Dec 08, 2015 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implicit conversion from source type-Sybase Enterprise Stage
- Replies: 3
- Views: 3519
- Tue Nov 17, 2015 10:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Tringger n instances of a job parallely
- Replies: 6
- Views: 3946
- Mon Nov 16, 2015 9:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implicit conversion from source type-Sybase Enterprise Stage
- Replies: 3
- Views: 3519
Implicit conversion from source type-Sybase Enterprise Stage
Hi all, We have a column defined as a CHAR (2) in Sybase, but when I read the column as a CHAR(2) in Datastage, I get the below mentioned warning . Implicit conversion from source type "string[4]" to result type "string[2]" I know that Sybase uses 2 bytes for a single CHAR value ...
- Mon Oct 05, 2015 10:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data copy error- Exponential Value - Oracle 10G to 12C Exada
- Replies: 4
- Views: 3065
- Sun Oct 04, 2015 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data copy error- Exponential Value - Oracle 10G to 12C Exada
- Replies: 4
- Views: 3065
- Sun Oct 04, 2015 2:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data copy error- Exponential Value - Oracle 10G to 12C Exada
- Replies: 4
- Views: 3065
- Sun Oct 04, 2015 2:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data copy error- Exponential Value - Oracle 10G to 12C Exada
- Replies: 4
- Views: 3065
Data copy error- Exponential Value - Oracle 10G to 12C Exada
Hi All, We are using Datastage 8.7 to copy tables over from Oracle 10G to Oracle 12c Exadata platform. Looks like Datastage is rounding off a large number. The number is defined as NUMERIC in both source and target. Am using a generic job having RCP enabled and a parameter that passes the table name...
- Wed Sep 16, 2015 11:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to bulk load to Oracle 12c Exadata platform
- Replies: 3
- Views: 4284
Thanks ArndW , I tried to extract only one column that's a key column at the Source and the target and applied Null handling as well, But I got the same error using bulk load, I have requested the admins to raise the request with the official support provider. I will keep the forum updated once I ge...
- Tue Sep 15, 2015 12:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to bulk load to Oracle 12c Exadata platform
- Replies: 3
- Views: 4284
Unable to bulk load to Oracle 12c Exadata platform
Please note we are unable to use Bulk load on Oracle 12C Exadata server - The jobs are aborting with the below mentioned error FAC_CMC_SBSB_SUBSC,0: The OCI function OCIDirPathPrepare returned status -1. Error code: 604, Error message: ORA-00604: error occurred at recursive SQL level 1 ORA-01405: fe...
- Tue May 26, 2015 5:12 pm
- Forum: General
- Topic: Sequencer was entered, but never exited
- Replies: 4
- Views: 3766