Upgrade Execution Hang During enable_rowkey.SQL – Resolution [Apps10 to 24R2]
Hello everyone, I wanted to share an issue we encountered during an upgrade from IFS Apps10 to IFS Cloud 24R2SU3, which might help others facing a similar challenge. Issue Description: The upgrade process was hanging during the execution of enable_rowkey.SQL. Additionally, the _deploy.log file showed no updates beyond a certain point, and the process appeared stalled for about 1 day. Root Cause: We discovered that the Container Database (CDB) had the parameter job_queue_processes set to 0. This setting effectively disables all background job processing in the entire multitenant database, including all pluggable databases (PDBs), causing the upgrade jobs to stall indefinitely. Resolution Steps: Connect to the CDB as the SYS user. Set a non-zero value for job_queue_processes in the CDB. For example; ALTER SYSTEM SET job_queue_processes = 10 SCOPE=BOTH; 3.) Monitor the _enable_rowkey.log file - the process should start progressing gradually. 4.) The upgrade then completed successfully wit