DSXchange

Hi Sainath,
Yes. That is what I'm surprised. 1403 should be from select, but we are getting it in the Oracle stage that only has insert/update.
We are capturing SQLERROR in the reject file and strangely it throws 1403 which should never come for either insert or update.

Hi, thanks for all your suggestions. There are no triggers on this table. Also, there is index, but since we use insert/update logic, how could there be a constraint violation which would result in ORA-1403 (no data found)? At least the error should have been "primary key violation" or &qu...

Hi, thanks for all your suggestions. There are no triggers on this table. Also, there is index, but since we use insert/update logic, how could there be a constraint violation which would result in ORA-1403 (no data found)? At least the error should have been "primary key violation" or &qu...

Hi, We are trying to pull data from DB2 and writing to Oracle table. This uses Oracle stage with "insert/update" processing. We've partitioned the stage using hash with a key that exactly matches our database table. However, during load process, it rejected a few rows (out of many) with er...