Page 1 of 1
Job failure issue
Posted: Fri Nov 04, 2011 1:15 am
by chandra.shekhar@tcs.com
Hi,
One of my jobs aborted giving the following error:-
Code: Select all
"An insert, update, or delete statement failed to run. (CC_DB2DBStatement::processRowStatusArray, file CC_DB2DBStatement.cpp, line 2,367)".
I dont know what this is? I reset my job and restarted it and surprisingly it ran suucessfully!!
Can some body explain what happened during the first run??
Posted: Fri Nov 04, 2011 1:28 am
by ray.wurlod
Maybe the database wasn't ready, or another process had a lock, or some other condition that had been cleared by the time you re-ran the job. There's probably some diagnostic information in the database's logs.
Posted: Fri Nov 04, 2011 1:41 am
by chandra.shekhar@tcs.com
Thanx Ray,
I guessed that more than 1 records were trying to insert at the same time, so thats why the insert statement failed to execute.
Can this also might be one of the reason??
Posted: Fri Nov 04, 2011 3:13 pm
by ray.wurlod
Probably not. The error is "statement failed to run". Something in the database server actually prevented execution of the statement.
Posted: Mon Nov 07, 2011 11:51 pm
by chandra.shekhar@tcs.com
Ok,
But we are still trying to find the root cause.
No success yet
