Hi All ,
I am getting the below error when trying to run the DS job which has oracle bulk load option enabled
The connector was configured to write data in bulk load mode and the reject condition for checking constraints was selected for the reject link. For this operation to work it is necessary to also provide the exceptions table name. (CC_OraConnection::checkEnvironment, file CC_OraConnection.cpp, line 4,921)The connector was configured to write data in bulk load mode and the reject condition for checking constraints was selected for the reject link. For this operation to work it is necessary to also provide the exceptions table name. (CC_OraConnection::checkEnvironment, file CC_OraConnection.cpp, line 4,921)
After giving the reject link also the same error is coming up. Please help
Your issue and solution are detailed in the message you posted. "Bulk load" in Oracle means sqlldr and that utility has the option to capture rejects to an exceptions table rather than failing. In order for it to do that you must tell it the name of the exceptions table to write to. I don't have access right now but I would imagine that this would not be handled by a reject link but rather by a property you set within the stage.
For (perhaps more than you'd ever want) detail on the subject, Tom Kyte has a couple of blog posts on the subject:
Note that I honestly don't know the answer here, just trying to get past the obvious issues and hoping that someone who's actually done this shows up and lends a hand.
-craig
"You can never have too many knives" -- Logan Nine Fingers
This problem arises because you previously used a Oracle stage with different constraints. Try to put again a Oracle target stage and review what are the constraints selected then cleared all the selected constraints ..save and compile the Job again. This worked for me.
