Tech Tip : ORA-04021: timeout occurred while waiting to lock object ORA-06512: a).

Document created by A.Poissonnier Employee on Nov 19, 2015Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

During an upgrade to CA-ehealth 6.3.2 10, the action can be stopped and with the below error in install log file

...

     Error: Database error: updateQueues (ORA-04021: timeout occurred while waiting to lock object ORA-06512: a).

     Error: The program updateQueues failed.

          - updating live ex tables ...

          - updating cndc tables ...

     Command /opt/CA/ehealth/bin/sys/nhiDbTasks -doConvert -userLog /opt/CA/ehealth/log/conversion.<...>log failed..

     Error : Off line convert failed in convertStandalone.

...

 

Suggestion:

- Reboot server  (or  stop/start of the Oracle server) 

- execute the command "nhConvertDb -undoconvert"

 

That allows to retry the upgrade with success

Attachments

    Outcomes