My Oracle Support Banner

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

Last updated on APRIL 13, 2021

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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