CommServe Disaster Recovery Error: [Msg 701]

Article ID: CS0001 Solution for Error: [Msg 701] "There is insufficient system memory to run this query."

Symptom

The following errors might be generated during a CommServe disaster recovery backup:

  • For ROMS users:

    Opened by NOC Engineer: [ ] 
    NOC Engineer's comments: [ ] 
    Alert Category: Job Management - Disaster Recovery Backup 
    Detected Criteria: Job Failed 
    Agent: CommServe Management 
    Pending/Failure: CommServeDR: Error: [Msg 701]. 
    Error Code: [34:65] 
    Client: [ ]
  • From the commserveDR.log file:

    CommservDR::doBackupRestore() - Copying the dump file from staging area to the ER directory
    CommservDR::dumpLog() - Log>> DBCC execution completed. If DBCC printed error messages, contact your system administrator.
    CommservDR::dumpLog() - Log>> There is insufficient system memory to run this query.
    CommservDR::dumpLog() - Log>> Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
    CommservDR::backupCmd() - CommServeDR: Problems encountered backing up SQL metadata.
    CommservDR::backupCmd() - CommServeDR: Full backup failed.
  • From the JobManager.log file:

    ODBCApi\DBcursors.cpp ,line 465, Problem Declaring/Preparing/Opening cursor for Table APP_SubClientProp (Batch 1) 
    
    [DBErr] SqlState: 42000 NativeError: 701 Line/Row: 1/1 [DBErr] Message: [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system memory to run this query. 
    
    SCInterfaceDB::getProperties() - Open Cursor on [APP_SubClientProp] Table failed. Error [ [DBErr] SqlState: 42000 NativeError: 701 Line/Row: 1/1 [DBErr] Message: [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system memory to run this query.] 
    
    Scheduler Set pending cause [CommServeDR: Error: [Msg 701].]::Client [ ] Application [commserveDR] Message Id [570425409] RCID [0] ReservationId [0]. Level [0] flags [0] id [0] overwrite [0] append [0] CustId[0]. Scheduler Ignored pending cause [CommServeDR: Error: [Msg 8921].]::Client [ ] Application [commserveDR] Message Id [570425409] RCID [0] Reservation Id [0]. Level [0] flags [0] id [0] overwrite [0] append [0] CustId[0]. Scheduler Phase [Failed] message received from [ ] Module [commserveDR] Token [] restartPhase [0] 
    JobSvr Obj Phase [1-Backup To Disk] for job Failed and will be restarted.
    

Resolution

This error indicates that the CommServe is running low on memory and is unable to backup the SQL database. This can occur if the computer has been up for an extended period of time or under heavy load. If the computer is under heavy load, it is due to SQL temp files which can grow large if it is not set back to the default size regularly. One of these temp files is theTemplog.ldf log file, which can continue to grow each time SQL is used.

To resolve this issue, stop the Commvault services, cycle the SQL services, and then restart the services. For step-by-step instructions on controlling services, see Controlling Services on Windows.

If this workaround fails to resolve the issue, then reboot the CommServe computer. This returns the temp file to the default size and allow the disaster recovery backup to run.

We recommend to use the DBMaintenance utility to maintain the CommServe database and prevent the issues explained above from happening. For more information on this tool, see DBMaintenance Utility.