Error Code 62:90: Failure during delete operation on CommServe Database

Article ID: MM0037 Attempt to deconfigure a tape library (old library) fails due to associated media.

Symptom

When attempting to deconfigure a tape library (old library) you may receive the following error in library and drive configuration:

Error Code 62:90: Failure during delete operation on CommServe Database . Please contact your vendor's support hotline

From the "MediaManger.log" file on the CommServe the following logging will show error 287:

--- SERVICE [ ] HOST [3], [...] SOFTSTATE NOT SET ENABLED AS RESYNC FAILED
--- SERVICE [ ] RESYNC CVMA: HOST [mbu197363-ma1]
### ODBCApi\DBcursors.cpp ,line 1432, DBtable::execStmt: Problem executing "DELETE FROM MMSpareGroup WHERE SpareGroupId = 1"

[DBErr] SqlState: 23000 NativeError: 547 Line/Row: 1/1
[DBErr] Message: [Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "MMMedia_SpareGroupId_FK". The conflict occurred in database "CommServ", table "dbo.MMMedia", column 'SpareGroupId'.
[DBErr] SqlState: 01000 NativeError: 3621 Line/Row: 1/1
[DBErr] Message: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

### MLMMediaAgentInfo::uninstallLibrary() - :MLMMediaAgentInfo.cpp:1350: Error in Uninstalling Library Library1<...>, failed to remove library due to error 287, string : Failure during delete operation on CommServe Database., RID : 2
### MLMMediaAgentInfo::uninstallLibrary() - :MLMMediaAgentInfo.cpp:1408: Request not in queue, 2
### ODBCApi\DBcursors.cpp ,line 1432, DBtable::execStmt: Problem executing "DELETE FROM MMSpareGroup WHERE SpareGroupId = 1"

Cause

This error results because media was not exported or re-associated to the new library and there are CommServe Database references of this media still associated with the old library.
 

Resolution

Contact the Contracted Support Center to have the CommServe Database tested in a staged environment prior to apply the solution on the production CommServe DB.

Please gather the following information as part of the escalation:

  • Name of the Tape Library being Deconfigured. (Media Export)
  • Name of the Tape Library to re-associate the Media. (Media Import).

Use the CommCell Console's Send Logs feature to send the CommServe Log Files to support. Do not collect logs by Time Range or JOB ID options as this will not provide the information required to troubleshoot and confirm the issues correct resolution.

 

Customer Engineer will take the following action:

  1. Confirm that the error 287 is the only error preventing the deconfiguration of the old Tape library.
  2. Stage the Provided CommServe DB and then use an internal utility to test the fix.
  3. Once the Fix is confirmed on the staged Database the Customer Engineer will use the same utility to first confirm all the tape media is associated with the old library and then use the same utility to associate the media to the new library.
  4. Confirm the library can be deconfigured.