Article ID: 53945
Article Type: Troubleshooting
Last Modified:
Attempt to deconfigure a tape library (old library) fails due to associated media.
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"
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.
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:
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: