Parallel error while lookup
Posted: Fri May 26, 2006 9:14 am
I am getting these type of fatal errors while i ran the job
node_node1: Player 11 terminated unexpectedly.
main_program: Unexpected termination by Unix signal 9(SIGKILL)
main_program: Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
main_program: Step execution finished with status = FAILED.
when i rerun the job with no modification in job, job completes successfully with no warnings.
The job contains serveral lookups from one particular table and other lookups from other tables.
ora ----> Trans -----> lookupstage ------>
here i have 8 lookups from different tables and 7 lookups from same table with different queries.
Data from lookups tables also limited around 500 records
i am not getting frequently. 10 times out 1 time fatals
Thanks in advance
node_node1: Player 11 terminated unexpectedly.
main_program: Unexpected termination by Unix signal 9(SIGKILL)
main_program: Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
main_program: Step execution finished with status = FAILED.
when i rerun the job with no modification in job, job completes successfully with no warnings.
The job contains serveral lookups from one particular table and other lookups from other tables.
ora ----> Trans -----> lookupstage ------>
here i have 8 lookups from different tables and 7 lookups from same table with different queries.
Data from lookups tables also limited around 500 records
i am not getting frequently. 10 times out 1 time fatals
Thanks in advance