EGL 9.2: Journal Edit/Journal Import/Journal Copy on MS SQL DB Fail with [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command OR The transaction operation cannot be performed because there are pending requests work (Doc ID 2591590.1)

Last updated on MARCH 10, 2024

Applies to:

Symptoms

Several AE processes are failing on MS SQL database after upgrading from Tools 8.55.25 to 8.57.06 (also occur on 8.57.09) and enabling MARS (MultiActiveResultSets).

ERRORS

Journal edit (GL_JEDIT):

File: e:\pt857p06b_1903270501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8629 - [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (SQLSTATE HY000) 0 Failed SQL stmt: UPDATE PS_JRNL_CF_BAL_TBL SET PROCESS_INSTANCE=:1 WHERE BUSINESS_UNIT_BAL=:2 AND JOURNAL_ID=:3 AND JOURNAL_DATE=:4 AND UNPOST_SEQ=0

Process 8622 ABENDED at Step GL_JINIT.DA000.UpdCFBal (SQL) -- RC = 8629

OR

File: E:\PT857P09B_1908140501-retail\peopletools\src\psappeng\psaesql.cppSQL error. Stmt #: 3299  Error Position: 0  Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The transaction operation cannot be performed because there are pending requests working on this transaction. (SQLSTATE 42000) 3981
Failed SQL stmt: DELETE FROM PS_AETEMPTBLMGR WHERE PROCESS_INSTANCE = :1 AND RECNAME = :2

Process 12914308 ABENDED at Step GL_JSTART.MAIN.LOGMS (Log Message) -- RC = ? (108,524)

Flat File Journal Import (GL_JRNL_IMP):

File: E:\PT857P06B_1903270501-retail\peopletools\src\psmgr\mgrvers.cppSQL error. Stmt #: 914  Error Position: 0  Return: 8602 - [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (SQLSTATE HY000) 0

Failed SQL stmt: SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'

 ...(GL_JRNL_IMP.InsJrnl.JrnlLFed) (SQL)
PS_SAMDIFF_ERROR('INSERTSELECT: Cannot locate record definition') FROM
PS_JIMP_LN_WRK4 A WHERE A.PROCESS_INSTANCE = 1234 AND (A.PIID <> ' ' OR
A.PIID_PARENT <> ' ' OR A.URI <> ' ' OR A.FAIN <> ' ' OR A.EXCLUDE <> ' ')
/
Process 8520 ABENDED at Step GL_JRNL_IMP.InsJrnl.JrnlLFed (Action SQL) -- RC = ?

Journal Copy:

File: E:\PT857P09B_1908140501-retail\peopletools\src\psappeng\psaesql.cppSQL error. Stmt #: 3299  Error Position: 0  Return: 8601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The transaction operation cannot be performed because there are pending requests working on this transaction. (SQLSTATE 42000) 3981

Process 12914314 ABENDED at Step GL_JRNL_COPY.CH000.JRHDRTMP (SQL) -- RC = ? (108,524)

Tools VERSION AE program:

File: E:\PT857P06B_1903270501-retail\peopletools\src\pspcm\pcmosql.cppSQL error. Stmt #: 763  Error Position: 0  Return: 8601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The transaction operation cannot be performed because there are pending requests working on this transaction. (SQLSTATE 42000) 3981
Failed SQL stmt: UPDATE PSLOCK SET VERSION = 1 WHERE OBJECTTYPENAME = 'SYS'

Changes

 Tools upgrade to 8.57 and enable MARS

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.