IBM Support

IT39967: SQL BACKUP FAILS WITH:"CTGGA2653 UNABLE TO RETRIEVE FILE VSSBACKUPDOCS.ZIP ON MICROSOFT SQL BACKUP"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The IBM Spectrum Protect Plus Microsoft SQL backup can fail with
    the error as seen in the job log:
    
    CTGGA2653,<hostname> ==> ReportServerTempDB([Unable to retrieve
    file vssbackupdocs.zip from <hostname>. e=java.lang.Exception:
    Error= File not Found])
    ERROR winosutil - Failed to open cluster, error (1753, There are
    no more endpoints available from the endpoint mapper.)
    ERROR winosutil - Failed to open cluster, error (1060, The
    specified service does not exist as an installed service.)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    *  IBM Spectrum Protect Plus level 10.1.9                      *
    ****************************************************************
    * 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.9 *
    * iFix 3 and 10.1.10. Note that this is subject to change at   *
    * the discretion of IBM.                                       *
    ****************************************************************
    

Problem conclusion

  • Fixed an issue with a query to find the the incremental backup
    metadata for files with large file identifier. After applying
    the fix SQL incremental backups will complete successfully
    without the error message to retrieve VSS backup docs.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT39967

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A18

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-02-15

  • Closed date

    2022-02-23

  • Last modified date

    2022-03-23

  • 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

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

Document Information

Modified date:
01 February 2024