DS Bulk load
Moderators: chulett, rschirm, roy
DS Bulk load
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
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:
http://tkyte.blogspot.com/2005/07/how-cool-is-this.html
http://tkyte.blogspot.com/2005/07/how-c ... rt-ii.html
For (perhaps more than you'd ever want) detail on the subject, Tom Kyte has a couple of blog posts on the subject:
http://tkyte.blogspot.com/2005/07/how-cool-is-this.html
http://tkyte.blogspot.com/2005/07/how-c ... rt-ii.html
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers