Error : Off line convert failed in convertStandalone.
CA-ehealth 6.2.2 and above Windows / Linux / UNIX
The ORA-04021 Error Message means that the objects cannot be changed while they are in use, and therefore a lock must be taken out on an object in order to modify it.
To resolve the ORA 04021 Error, You may wait until the other process has finished using the object or perhaps you can kill the session or recycle the Oracle Server.
Reboot the machine
Do undo convert "nhConvertDb -undoconvert"
Before restarting the ehealth upgrade, execute the command "nhConvertDb -undoconvert"
Start upgrade again
We have also seen this issue on a functioning eHealth poller, with following error:
Pgm nhiPoller[Net]: Unable to add 'network element' data to the database, dropping this poll.
Pgm nhiPoller[Net]: Sql Error occurred during operation: 'ORA-04021: timeout occurred while waiting to lock object '; possible problem data is: element id: 1317549, sampleTime: 1461128399 for table nh_stats0_1461130199.
For this problem, same solution applies, except for upgrade step:
Reboot the system if possible or
Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements Component: