Job error: ds_ipcgetnext waiting for mutex
Posted: Mon Mar 02, 2009 10:03 pm
I'm getting the following error when running a job (STP stage) that is calling a procedure. The procedure has several selects that inputs into variables and a final select that inserts into a table.
It fails after 2 minutes in the job. Usually after 2 minutes, the final select (insert) has started.
Database is DB2
Calling the procedure from WinSQL gives no errors. And no other related jobs was running at the same time. The job just basically calls the procedure and write the return code to a file.
The job has no hash files & no IPC stages and 'Enable Row Buffer' is unchecked.
Any ideas?
It fails after 2 minutes in the job. Usually after 2 minutes, the final select (insert) has started.
Code: Select all
Abnormal termination of stage LOD_INCOME_EXPENSE_INTER_FEE_L..DTM_CUPP_PRC_ICEX_INTER_FEE detected
LOD_INCOME_EXPENSE_INTER_FEE_L..DTM_CUPP_PRC_ICEX_INTER_FEE.out: ds_ipcgetnext - timeout waiting for mutex
Attempting to Cleanup after ABORT raised in stage LOD_INCOME_EXPENSE_INTER_FEE_L..TransCalling the procedure from WinSQL gives no errors. And no other related jobs was running at the same time. The job just basically calls the procedure and write the return code to a file.
The job has no hash files & no IPC stages and 'Enable Row Buffer' is unchecked.
Any ideas?