E-PC: Application Designer Crash With Error "Illegal uncommitted SQL cursor detected" When Partitioning Records In PT 8.56

(Doc ID 2406802.1)

Last updated on JUNE 02, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

On : 8.56 version, Application Designer

PeopleSoft App Designer crashed when select 'Tools > Data Administration > Partitioning' in PT 8.56

ERROR
-----------------------
Illegal uncommitted SQL cursor detected. Close down all windows and reboot. (22,3)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Navigate to PeopleTools > Utilities > Partitioning Utilities
2) Select the Record GP_PYE_STAT_WRK
3) Enter the Table Partitioning Attributes, click <Generate Partitioning DDL> button and <Save DDL> button
4) Login to App Designer, open record GP_PYE_STAT_WRK
5) Select Tools > Data Administration > Partitioning. Error message appear.
6) Click <OK> on the error message, The Maintain Partitioning DDL windows is launched
7) Select the [Apply Partitioning] checkbox
8) Click <Save> button or Click <OK> button, the App Designer will be crashed /closed suddenly


Changes

 

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