IBM Support

IT41875: SQL SERVER DATABASE BACKUP GETS STUCK AT "WAITING FOR REMOTE CREATION TO COMPLETE ON SERVER xxx" AND CANNOT BE CANCELLED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL Server windows server is restarted in the middle of SQL
    server database backup. Then the backup job gets stuck at
    "Waiting for remote operation to complete on server <sql-server
    host> and cannot be cancelled. IBM Spectrum Protect Plus does
    not detect sppagent service stop, and keeps tracking the process
    with old process ID.
    
    Versions affected: IBM Spectrum Protect Plus 10.1.*
    

Local fix

  • Restart virgo service
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus 10.1.10, 10.1.11 and 10.1.12       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in IBM Spectrum Protect Plus  10.1.13. *
    ****************************************************************
    

Problem conclusion

  • This problem has been fixed so that after SQL backup job is
    cancelled, the job can cancelled properly, within 30 minutes.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT41875

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-08-26

  • Closed date

    2022-10-24

  • Last modified date

    2022-10-24

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

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

Modules/Macros

  • 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":"A10","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
01 February 2024