Cannot check in a file getting ORA-00054 error

Document ID : KB000121308
Last Modified Date : 16/11/2018
Show Technical Document Details
Issue:
The user had tried a check in process and had gotten the message that the package was locked. 

We used the hpkgunlk command to unlock the package and that completed successfully. 

The user tried the check in again, and got an Oracle error message: 

E03020003: Database error [CAI/PT][ODBC Oracle Dynamic driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 
SQLSTATE=s1000. 
Environment:
CA Harvest SCM all versions and platforms
Oracle database
Cause:
The error message indicates that there is a table in the Oracle database that is locked, waiting for a transaction to finish.  

We use the "hdbgctrl" command to increase the HServer logging level to 5 and then reproduced the problem.  The HServer logs indicated it was the HARVERSIONS table that was locked
Resolution:
Contacted the Oracle DBA and relayed the error message and log file.  The DBA was able to unlock the table.  The problem is resolved.