DSXchange

Dear Ray/Chullet,

Datastage job is running successfully and showing number of rows over the link in oracle db but its not inserting records in the oracle table.

source is Dataset
Intermediate stage is Transformer
Target is Oracle Table

Can you please guide me here to sort out the problem

No one know about this issue?

Hi All,

I am getting the below while loading data from data set to oracle table

Invalid field type in call to getInputFieldAsString() for field '2' in input dataset '0'.


Can any one please tell me what will be possible cause for this error.

below are the log information for rejected records: orc_TB_REJECT_ins,1: Records inserted: 0 Records used for update: 0 Records rejected: 1 Total records: 1. orc_TB_REJECT_ins,2: Records inserted: 0 Records used for update: 0 Records rejected: 0 Total records: 0. orc_TB_REJECT_ins,3: Records inserte...

the only the update sql query is using along with other two properties for write method and upsert mode

Update SQL Query: INSERT INTO TB_REJECT (FILE_NAME, TABLE_NAME, SOURCE, ROW_NUM, RECORD, ERROR_DESC, DATA_DATETIME, CREATED_DATETIME, MODIFIED_DATETIME, CREATED_BY, MODIFIED_BY) VALUES (ORCHESTRATE.FILE_NAME, ORCHESTRATE.TABLE_NAME, ORCHESTRATE.SOURCE, ORCHESTRATE.ROW_NUM, ORCHESTRATE.RECORD, ORCHES...

Looking farward for help!

there are no warnings or errors in the log.

But reject link is showing the records and not inserting the records.

Reeject table properties:

upsert mode : user defined update only

write method: upsert

any one to help please

Dear Experts,

rejected Records are dropping while loading into reject table. but same datastage job is able to load in dev /test environment with same structure of Rejecetd table.

Please help me in resolving this.

I have set all properties in the reject table and no warnings also

Hi Folks, In one of the datastage job ,i am unable to insert the records into the rejected table. The datastage job is showing as the records are passing through reject link and showing number of records passing through the link to target ORACLE EE Stage. But while checking into oracle DB reject tab...

Hi ray,

The Operating systems,Database configurations,authentications everything is same.

Moreoover the same is running fine more than 1 year in production

Hi Ray, I have data for a particular column CategoryID getting from source dataset and while loading into target table it is giving error ora-01400:cannot insert NULL. Same job is working fine with same value for methodid column in dev and prod environments. What needs to be done with this to resolv...

Hi All,

Please suggest me any thing here to resolve this strange issue where the same one executing fine in dev and test environments.

Only production giving this strange error.