Purchase Order Dispatch Fails From Add/Update PO Page With Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "00C9008E". SQLSTATE=57033 (Doc ID 2016748.1)

Last updated on JANUARY 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

With XMLP enabled, when dispatching a Purchase Order (PO) from the PO page using the Dispatch button, and chosing to wait for the process to complete, the PO will not be dispatched. When reviewing the process on the Process Monitor, it is found that it has goes to 'No Success'. 


STEPS
1. Open an approved PO with Dispatch Method = Print. The PO is create eProcurement
2. Press button from the PO Header
3. Press yes to message
4. Press yes to message
5. Open the Process Monitor and notice the Instance 18373 – PSJob – POXMLP was run with status.
6. In the process details, POXMLP is linked to the PO_DISPATCH and also ended with no success.

Error:

File: e:\pt85310c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "00C9008E". SQLSTATE=57033

 (SQLSTATE 57033) -913
Failed SQL stmt: SELECT CNTRL_PUR.OPRID , CNTRL_PUR.RUN_CNTL_ID , CNTRL_PUR.LANGUAGE_CD , CNTRL_PUR.RPT_DEST , CNTRL_PUR.BUSINESS_UNIT , CNTRL_PUR.GRP_PUR_ID , CNTRL_PUR.VENDOR_STATUS , CNTRL_PUR.VENDOR_SETID , CNTRL_PUR.VENDOR_ID , CNTRL_PUR.FROM_DATE , CNTRL_PUR.THRU_DATE , CNTRL_PUR.AS_OF_DATE , CNTRL_PUR.SORT_SEQUENCE , CNTRL_PUR.SETID , CNTRL_PUR.FILE_NAME , CNTRL_PUR.PO_ID , CNTRL_PUR.BUYER_ID , CNTRL_PUR.PRT_OPEN , CNTRL_PUR.PRT_DISPATCHED , CNTRL_PUR.PRT_APPR , CNTRL_PUR.PRT_COMPLETED , CNTRL_PUR.PRT_RECYCLE_CF , CNTRL_PUR.PRT_HELD , CNTRL_PUR.PRT_PENDING , CNTRL_PUR.PRT_CHNG_ORDERS , CNTRL_PUR.PRT_CHGS_ONLY , CNTRL_PUR.PRT_ONLY , CNTRL_PUR.PRT_DUP , CNTRL_PUR.PRT_POL_DESCR , CNTRL_PUR.PRT_CANCELLED , CNTRL_PUR.FAX_SERVER_DIR , CNTRL_PUR.REQ_ID , CNTRL_PUR.REQUESTOR_ID , CNTRL_PUR.TEST_IND , CNTRL_PUR.PRINT_IND , CNTRL_PUR.COVER_FILE_NAME , CNTRL_PUR.EDI_SERVER_DIR , CNTRL_PUR.FAX_SERVER_NAME , CNTRL_PUR.NUM_OF_COPIES , CNTRL_PUR.PRINT_SORTBY , CNTRL_PUR.CNTRCT_SETID , CNTRL_PUR.CNTRCT_ID , CNTRL_PUR.CNTRCT_ID_TO , CNTRL_PUR.VRBT_ID , CNTRL_PUR.VRBT_ID_TO , CNTRL_PUR.VENDOR_ID_TO , CNTRL_PUR.PRINT_TERMS , CNTRL_PUR.EDI_DISP , CNTRL_PUR.FAX_DISP , CNTRL_PUR.PHONE_DISP , CNTRL_PUR.PRINT_DISP , CNTRL_PUR.EMAIL_DISP , CNTRL_PUR.EMAIL_SERVER_DIR , CNTRL_PUR.RELEASE_NBR , CNTRL_PUR.MSTR_CNTRCT_ID , CNTRL_PUR.CATEGORY_CD , CNTRL_PUR.TO_BU , CNTRL_PUR.URL , CNTRL_PUR.TMPLDEFN_ID , CNTRL_PUR.CS_EXCL_DOCS FROM PS_RUN_CNTL_PUR CNTRL_PUR W
>>>



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms