E-SQR: A Transaction That Was Started In A MARS Batch Is Still Active At The End Of The Batch (Doc ID 2038572.1)

Last updated on SEPTEMBER 09, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Symptoms

On : 8.54.10 version, SQR

When attempting to run SQR with Commit-Transaction code the following error occurs:

ERROR
-----------------------
(SQR 5528) ODBC SQL dbexec: SQLExecute error 3997 in cursor 3:
  [Microsoft][SQL Server Native Client 11.0][SQL Server]A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Submit SQR that uses the Commit-Transaction in a Begin-SQL command

 

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