E-AD: Cannot Migrate SQL To Database After Running Compare Report
(Doc ID 2408254.1)
Last updated on JANUARY 03, 2023
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.56 and laterInformation 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)
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |