View previous topic :: View next topic
|
Author |
Message |
rakesh17684
New User
Joined: 08 Oct 2006 Posts: 61 Location: San Diego
|
|
|
|
Hi ,
We encountered sqlcode = "-919" during the execution of the MQ listener execution . This listener calls an Stored procedure.
We resolved it by restarting the listener again.
We are still not able to figure what is causing the -919,
which states:
-919 A ROLLBACK OPERATION IS REQUIRED
Explanation: The unit of work was placed in a state where a rollback
operation is required.
below is the information from the log
Code: |
" 2010-12-15::23:05:37 >> Thread:413421568 Function : DBProcedure::executeCall
DSNQ075I MQListener encountered a DB2 database error while running the stored procedure "XYZ00". "SPMQ0123" in subsystem "DC1P" during operation "EXECUTE".The resulting sqlstate was "56045" ( sqlcode = "-919" ). |
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I suspect there is other diagnostic information available somewhere that must be found and researched. |
|
Back to top |
|
|
|