E-NV: nVision Reports Run In Windows 3 Tier Mode Error: "Illegal Uncommitted SQL Cursor Detected" (Doc ID 642447.1)

Last updated on JUNE 10, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 to 8.47 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.51 to 8.51 [Release 8.4]
Information in this document applies to any platform.
SPECIFIC TO: Enterprise, PeopleTools 8.45 and above, nVision
This document has been merged with Document ID 650217.1.
Checked for relevance on 06-MAY-2013


Symptoms

When running an nVision report using Dynamic selector options, the report runs to completion but the PSSAMSRV server becomes busy with a SQLAccess service request. Quickly all PSSAMSRV servers are tied up and no reports can be run.

Here is how to replicate the issue...

1). nVision users run reports in Windows 3 tier mode.
2). Two connection to the appserver are made via Jolt.
3). The report runs fine and results are returned to the user.
4). The PSSAMSRV stays in the SQLAccess status and one Jolt connection indicates BUSY.
5). If the users submit another request from the same nVision session, an error pop-up with illegal uncommitted SQL cursor detected. The PSSAMSRV will return to an IDLE status and Jolt connection is no longer busy.

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