IT37811: "CTGGE1024 LOG BACKUP TASK ALREADY EXISTS FOR DATABASE" ON MICROSOFT SQL BACKUPS

APAR status

• Closed as program error.

Error description

• Using IBM Spectrum Protect Plus, when log backups are enabled
  in a SLA for Microsoft SQL databases, the first backup run will
  attempt to configure a local SQL Server host schedule to
  initiate log backups at defined times.
  That log schedule enabling can fail for databases that already
  were protected with log backups before with a different SLA.
  
  The job log will display the following messages :
  
  SUMMARY,<timestamp>,CTGGA2398,Starting job for policy <SLAName>
                                (ID:<SLAId>). id -> <JobId>. IBM
                                Spectrum Protect Plus version
                                10.1.8-4083.
  ...
   DETAIL,<timestamp>,CTGGA1952,Enabling log backup of databases
                                on instance <InstanceName>
     INFO,<timestamp>,CTGGA3149,[<DBServerHost>] [<timestamp>]
                                Starting enablelogbackup command.
  ...
   DETAIL,<timestamp>,CTGGE1000,[<DBServerHost>] Connecting to
                                [\\<vSnapHost>\vpool1_fs123] with
                                username <vSnapUser>. Attempt 1
                                of 3.
   DETAIL,<timestamp>,CTGGE1023,[<DBServerHost>] Scheduling log
                                backup task for database
                                [<DBName>].
     WARN,<timestamp>,CTGGE1024,[<DBServerHost>] Log backup task
                                already exists for database
                                [<DBName>] in SLA policy
                                [<SLAName>].
  ...
     INFO,<timestamp>,CTGGA3150,[<DBServerHost>] [<timestamp>]
                                Ending enablelogbackup command.
     WARN,<timestamp>,CTGGA1951,[<DBServerHost>] Enable log
                                backup status was reported as
                                partial: null
    ERROR,<timestamp>,CTGGA2296,Enable log backup failed for
                                database <DBName>:Log backup
                                exists for the database in SLA
                                policy [<SLAName>]
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  
  Additional Keywords: SPP, SPPLUS, TS005975615
  

Local fix

• Before protecting Microsoft SQL database with log backups with
  a new SLA, first perform a backup with the original SLA with
  log backup disabled.
  That will trigger a removal of the original log backup schedule
  and prevent a conflict with the new SLA log enabling activity.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.7 and 10.1.8            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.8 ifix2 and 10.1.9. Note that this is subject to change *
  * at the discretion of IBM                                     *
  ****************************************************************
  

Problem conclusion

• Provided a user option to configure SQL log backup with a new
  SLA, when the prior SLA is disabled.
  

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