IT40817: MICROSOFT SQL SERVER CAN BE SKIPPED DURING BACKUP, BUT THE JOB IS MARKED AS COMPLETED. CTGGA1980 INDICATED IN LOGS

APAR status

• Closed as program error.

Error description

• For Microsoft SQL Server protected with IBM Spectrum Protect
  Plus, if the backup is unable to collect database information,
  then the SQL databases are skipped during backup and SLA
  association is removed. The backup status is marked 'Completed'.
  It is not obvious for the operator that the SQL databases
  association with the SLA is removed.
  
  The following job log entries are symptomatic of this problem:
  
  SUMMARY,<timestamp>,CTGGA2398,Starting job for policy <SLAName>
  (ID:1091). id -> <JobId>. IBM Spectrum Protect Plus version
  10.1.9-2549.
  
  ...
  WARN,<timestamp>,CTGGA1980,SLA policy association will be
  removed for instance - <instancename>
  
  ...
  ERROR,1646978879162,<timestamp>,[instancename]
  GatherWriterMetadata was cancelled due to timeout
  ...
  ERROR,1646978879164,<timestamp>,CTGGE0068,[instancename] The SQL
  discovery failed: error [Failed to request VSS discovery
  error[GatherWriterMetadata was cancelled due to timeout]]
  
  ...
  DETAIL,1646981565751,<timestamp>,CTGGA0804,Protection task 2
  completed in x hr(s) y min(s) z sec(s) and ended with status
  COMPLETED.
  
  |MDVREGR  10.1.9.1  5737SPLUS|
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.9.2 and later
  
  Additional Keywords: SPP, SPPLUS, SQL, Backup, TS008697697,
  Association, Remove
  

Local fix

• Ensure to :
  1. Register the removed SQL instance to the SLA Policy that was
  registered to and run ad hoc backup for the removed SQL instance
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *  IBM Spectrum Protect Plus level 10.1.9 and 10.1.10          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed IBM Spectrum Protect Plus level        *
  * 10.1.10.2 and 10.1.11. Note that this is subject to change   *
  * at the discretion of IBM.                                    *
  ****************************************************************
  

Problem conclusion

• Fixed an issue with return code with inventory of SQL databases
  that was causing SLA associations to be removed. After applying
  the fix the SLA associations will not be removed if the
  inventory cannot find any databases on the SQL server.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• Apps     SQL
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels