My Oracle Support Banner

Change Assistant Runs Data Conversion AE - DCAW26326249 For a Very Long Time - Process Appears Stuck (Doc ID 2479470.1)

Last updated on MARCH 02, 2020

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.