E-AD: Cannot Migrate SQL To Database After Running Compare Report
Last updated on JUNE 06, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.
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)
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