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.
Error while loading using an oracle connector stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Re: Error while loading using an oracle connector stage
What is the data type and value of row 3, column 10?kollurianu wrote:... [IIS-CONN-ORA-003005] A data conversion error was encountered in bulk load mode for row 3, column 10...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Thanks Arnd for your response.
I turned off the data conversion check box in the reject link still didn't load the file.
The value in column 10 and row 3 is 0001-01-01 and there are such date values in other date fields too for sure it is an invalid date and this was successfully loaded to OCI enterprise stage.
Just now I changed the option from Truncate load to Truncate Insert in the connector and could load the same data file successfully with no warnings and rejects.
Oracle connector is working crazily.
Thank you all.
I turned off the data conversion check box in the reject link still didn't load the file.
The value in column 10 and row 3 is 0001-01-01 and there are such date values in other date fields too for sure it is an invalid date and this was successfully loaded to OCI enterprise stage.
Just now I changed the option from Truncate load to Truncate Insert in the connector and could load the same data file successfully with no warnings and rejects.
Oracle connector is working crazily.
Thank you all.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm