Change Assistant Runs Data Conversion AE - DCAW26326249 For a Very Long Time - Process Appears Stuck
(Doc ID 2479470.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
Customers report the process running for very long periods, more than 8 hours and even longer which delays the overall upgrade timing.
It is executing the following update SQL for more than 5 hours.
SQL -
UPDATE PS_EP_APPR_XREF SET EOAWDTTM_MODIFIED = (SELECT MAX(U.EOAWDTTM_MODIFIED) FROM PS_EOAW_USERINST U WHERE U.EOAWSTEP_INSTANCE IN (SELECT S.EOAWSTEP_INSTANCE FROM PS_EOAW_STEPINST S WHERE S.EOAWTHREAD_ID = PS_EP_APPR_XREF.EOAWTHREAD_ID AND S.EOAWPRCS_ID = :1)) WHERE EOAWPRCS_ID=:2 AND EOAWDTTM_MODIFIED IS NULL
The issue may be replicated at will with the following steps:
1. Apply HCM 9.2. any PUM Image x
2. Run Data Conversion AE - DCAW26326249
3. Process gets stuck at the above sql
4. Tested in 2 different databases and issue remains the same
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 |