DSXchange

Change the array size to 1 to get correct error reporting.

Of course your Oracle DBA's may come out and lynch you if the table is really large...

I changed the array size as 1 and now it is throwing the below error

Target_Oracle_Entp,0: Open failed for insert:
insert is: <<insert SQL statement >>
sqlcode is: -2290
esql complaint: ORA-02290: check constraint (Target table constraint) violated

Thanks

So now you know what the actual error is. The INSERT statement may suggest which actual CHECK constraint was violated; or there may be more information in the job log or in the Oracle logs.

Does your reject link have sqlcode column? Does your reject link or your job have a limit on the number of rows/warnings handled?

Yes reject link is having sqlcode column, but no limitations for warnings/rows in job as well as reject links.

They're rejected for a reason and that reason is logged, regardless. A 'cheat' would be to demote what you don't want, better to fix the job and (gasp) not violate the constraint. Any reason you can't do that?

rangunathan13,

Let me be a bit more specific about what Craig advised.

The best way to resolve this is to determine what constraints are on the table at a database level and include tests in your job to check each record and route the rejects to a file before they are written to the table.

This would also allow you to set array size back to something more reasonable since you wouldn't need to trap the rejects coming back from the table.

Exactly - logical rather than physical rejects. No job should ever knowingly violate a constraint on a table and thus should not only be aware of them all but attempt to ensure compliance with them before sending the record to the database.