upgrade_express_2101_2201 step 1004 stalls; "timeout occurred while waiting to lock object"

• Article Type: General
• Product: Aleph
• Product Version: 22

Problem Symptoms:
upgrade_express_2101_2201 step 1004 has been running for 2.5 hours. No errors are seen, but nothing has been written to the log for 2.5 hours. "ps -ef |grep z353" shows two processes still running: "oracle_table_alter usr z353" and "z353_alter_column.sql"


After killing the processes, both SQL "select count(*) from z353;" and util a/17/3 for z353_id get the following error:

"ORA-04021: timeout occurred while waiting to lock object"

Cause:
Uncertain. But, after restarting Oracle, the above error was no longer occurring, and util a/17/14 showed the z353_id and z353_id1 as present and valid, the record count (comparing to v20 was correct) and util f/4 in v22 for z353 showed them correctly (indicating that they had been correctly converted into the v22 format).

It *may* have had to do with the fact that the "3. Upgrade Express" step was started before the "6. Backup/Restore Oracle Tables to be Upgraded" step was complete -- which *did* happen. See Article 000024912 ("upgrade_kit_export.log" message when no export was submitted) in regard to this step 6.

Resolution:
1. Be sure to let upgrade_util step 6 finish before starting step 3 to (possibly) prevent the problem.
2. If the problem occurs, restart Oracle.