IBM Support

IT30134: SQL BACKUP FAILING: OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An IBM Spectrum Protect Plus backup of a SQL database can fail
    with the following error message:
    
       CTGGA2081,Failed to enable log backup for database
        group/instance ANLSQL2016 due to the following error:
        ...
    
       Last transaction log backup occurred at <date time stamp> and
        failed. Reason: Object reference not set to an instance of
        an object.
    
    
      This appears to be an issue with the log backups that the
      "lsn.json" file was detected as present but was not
    de-serialized
      properly and causing the above error message to be reported.
    The
      "lsn.json" file is used by the IBM Spectrum Protect Plus
    appliance.
    
    IBM Spectrum Protect Plus Versions Affected:
      10.1.4
    Customer/L2 Diagnostics (If Applicable)
      N/A
    
    Initial Impact:
      Medium
    Additional Keywords:
      TS002542398 SQL FAILED CTGGA2081
    

Local fix

  •   NA
    

Problem summary

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

Problem conclusion

  • Fixed an issue with parsing information for checking break in
    log backup chain.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30134

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A14

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-08-29

  • Closed date

    2019-09-06

  • Last modified date

    2019-09-06

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

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

Fix information

  • Fixed component name

    SP PLUS

  • Fixed component ID

    5737SPLUS

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A14","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
30 January 2024