E-NV: nVision Reports Run In Windows 3 Tier Mode Error: "Illegal Uncommitted SQL Cursor Detected"
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms