Cannot check in a file getting ORA-00054 error
Article ID: 121308
Updated On:
Products
Issue/Introduction
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.
Additional Information
To find the Harvest log files see: Location of the Harvest log files
Error code E03020003 is very generic and relays that some problem happened with the database. You must read the entire message to learn what the problem is. For other examples of E03020003 errors see:
Error when trying to delete a package Invalid object name 'HARUSDDEPLOYINFO'
Error during Check In: E03020003: Database error [Oracle][ODBC]Numeric value out of range.
CheckIn Error on large files > 1GB
ORA-06502: PL/SQL: numeric or value error: raw variable length too long in Harvest 14.5
Hdbsetup error ORA-00959: tablespace 'HARVESTINDEX' does not exist
Unable to promote package/SQL error
No temp tablespace after recovery
ORA-00911 when approving a package for Peer Review after upgrade to 14.5
Feedback
