Error while loading using an oracle connector stage
Posted: Thu Mar 18, 2010 12:53 pm
Hi All ,
Data was successfully loaded into oracle table , using an OCI Enterprise stage
But now when I am using oracle connector stage , I am getting fatal errors , regarding date field with the same load data file to the same table.
Tble_Acct_Master_Full,0: [IIS-CONN-ORA-003005] A data conversion error was encountered in bulk load mode for row 3, column 10. (CC_OraLoad::loadData, file CC_OraLoad.cpp, line 1237)
[IIS-CONN-ORA-001003] The OCI function OCIDirPathFinish returned status -1. Error code: 39767, Error message: ORA-39767: finish is not allowed when unloaded stream data exists. (CC_OraLoad::finishLoad, file CC_OraLoad.cpp, line 1745)
Both the stages OCI Ent/Oracle connector are using truncate and load option (Bulk load).
Any inputs greatly appreciated.
Thank you all.
Data was successfully loaded into oracle table , using an OCI Enterprise stage
But now when I am using oracle connector stage , I am getting fatal errors , regarding date field with the same load data file to the same table.
Tble_Acct_Master_Full,0: [IIS-CONN-ORA-003005] A data conversion error was encountered in bulk load mode for row 3, column 10. (CC_OraLoad::loadData, file CC_OraLoad.cpp, line 1237)
[IIS-CONN-ORA-001003] The OCI function OCIDirPathFinish returned status -1. Error code: 39767, Error message: ORA-39767: finish is not allowed when unloaded stream data exists. (CC_OraLoad::finishLoad, file CC_OraLoad.cpp, line 1745)
Both the stages OCI Ent/Oracle connector are using truncate and load option (Bulk load).
Any inputs greatly appreciated.
Thank you all.