Reject records=No Warning, so how to detect rejected

pnpmarques · Post by **pnpmarques** » Thu Oct 22, 2009 8:49 am

Hello,
I have a job that loads data with Oracle Enterprise Stage, Upsert mode.
For some reason, like Foreign Key constraints or inserting Null into a Not Null column, I get rejected records, but it generates no warnings.
It just shows a Info message:
"ORA_TABLE,0: Records inserted: 0
Records used for update: 0
Records rejected: 1
Total records: 1."

I guess this is a normal behaviour for DS but I would like to be warned when this happens!
I whish it would be as simple as setting a variable (like APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS for string truncation) where we could say "DS, please warn me when there are rejected rows".
From your experience what solutions can I try?

Thanks in advance!

chulett · Post by **chulett** » Thu Oct 22, 2009 8:52 am

Honestly, the best defense is a good offense. Make sure you don't generate those errors. Failing that, check the log 'after job' for messages like that and alert there.

cppwiz · Post by **cppwiz** » Thu Oct 22, 2009 2:58 pm

1. Send the upsert rejects to a file
2. Run a shell script to count the lines in the file
3. Send an email if the count > 0

pnpmarques · Post by **pnpmarques** » Tue Oct 25, 2011 10:11 am

Solution: no more oracle enterprise stage, from now on I'll just use Oracle Connector stage.