Job aborted with oracle stage.......
Posted: Thu Feb 17, 2011 9:38 am
I get the below warnings and my job is aborted. Help needed to get rid of them.Source and target is oracle EE stage between them is a transformer where i am handling stringtotimestamp, decimaltodecimal and null string fields to null timestamp conversion and some more.My source has 710867 records. Log shows 710868. Options in Oracle EE target stage as write mode: truncate and write method: load. Am i doing something wrong? Really appreciate any help.
Copy_of_Transformer_1,0: Conversion error calling conversion
routine decimal_from_string data may have been lost
Copy_of_Transformer_1,0: Conversion error calling conversion
routine timestamp_from_string data may have been lost
Copy_of_Transformer_1,0: No more conversion warnings will be issued
Copy_of_Oracle_Enterprise_0,0: Export complete; 710868 records
exported successfully, 0 rejected.
Copy_of_Oracle_Enterprise_0,0: Load completed - logical record
count 710868.
Copy_of_Oracle_Enterprise_0,0: Rows not loaded due to data errors:
37
Copy_of_Oracle_Enterprise_0,0: The call to sqlldr failed; the
return code = 2;
please see the loader logfile:
/opt/IBM/InformationServer/Server/Scratch/ora.19206.704488.0.log
for details.
Copy_of_Oracle_Enterprise_0,0: The runLocally() of the operator
failed.
Copy_of_Oracle_Enterprise_0,0: Input 0 consumed 1 records.
Copy_of_Oracle_Enterprise_0,0: Operator terminated abnormally:
runLocally() did not return APT_StatusOk
main_program: Step execution finished with status = FAILED.
Copy_of_Transformer_1,0: Conversion error calling conversion
routine decimal_from_string data may have been lost
Copy_of_Transformer_1,0: Conversion error calling conversion
routine timestamp_from_string data may have been lost
Copy_of_Transformer_1,0: No more conversion warnings will be issued
Copy_of_Oracle_Enterprise_0,0: Export complete; 710868 records
exported successfully, 0 rejected.
Copy_of_Oracle_Enterprise_0,0: Load completed - logical record
count 710868.
Copy_of_Oracle_Enterprise_0,0: Rows not loaded due to data errors:
37
Copy_of_Oracle_Enterprise_0,0: The call to sqlldr failed; the
return code = 2;
please see the loader logfile:
/opt/IBM/InformationServer/Server/Scratch/ora.19206.704488.0.log
for details.
Copy_of_Oracle_Enterprise_0,0: The runLocally() of the operator
failed.
Copy_of_Oracle_Enterprise_0,0: Input 0 consumed 1 records.
Copy_of_Oracle_Enterprise_0,0: Operator terminated abnormally:
runLocally() did not return APT_StatusOk
main_program: Step execution finished with status = FAILED.