Hi,
We have Load Ready Dataset that is output of SCD type2 stage and we are laoding that setset into Databse table in another job using Oracle enterprise stage in upsert mode. Sometime data is loaded sucessfully and sometime loading gets failed by giving error "Unable to insert record into the table" and when we try again it is loaded sucessfully. It gives the random behaviour. Sometime failed and sometime successfull.
Please help..
Getting Error when loading data in Oracle Database in Upsert
Moderators: chulett, rschirm, roy
Re: Getting Error when loading data in Oracle Database in Up
Hi,
Please give more details.
Can you try using a reject link to the Oracle stage to obtain the sqlerror. This will provide exact reason why the record is not interted.
also mention the exact warning message that you are seeing in the log.
Please give more details.
Can you try using a reject link to the Oracle stage to obtain the sqlerror. This will provide exact reason why the record is not interted.
also mention the exact warning message that you are seeing in the log.
Re: Getting Error when loading data in Oracle Database in Up
I am using Reject Link to capture any reject data that could not be laoded into the database.
I am getting the error message "Oracle_Enterprse : Unable to insert a record into the table." "Orcle_Enterprise : The runLocally() of the operator Failed."
We are running this job at 2 node and row commit frequency is 5000.
I am getting the error message "Oracle_Enterprse : Unable to insert a record into the table." "Orcle_Enterprise : The runLocally() of the operator Failed."
We are running this job at 2 node and row commit frequency is 5000.
Nirdesh Kumar