My Oracle Support Banner

E-AD: Cannot Migrate SQL To Database After Running Compare Report (Doc ID 2408254.1)

Last updated on JULY 13, 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

The issue was reported on PT8.56.06

When attempting to migrate SQL objects in Application Designer from one database to another with PT client 8.56.06, after running a Compare Report, the following error occurs.


The issue can be reproduced at will with the following steps:
1. In Application Designer PT8.56.06, create a new Project. Insert any SQL Definition.
2. Modify the SQL Text, for example, add a comment.
3. Run a Compare Report from database A to database B.
4. Then do a Copy To Database.
5. Error is displayed:

Error: Illegal uncommited SQL cursor detected. Close down all windows and reboot. (22,3)

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.