IT37781: SQL AND EXCHANGE BACKUPS HANG WHILE WAITING FOR REMOTE OPERATION TO COMPLETE ON SERVER.

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus backups of Microsoft SQL Server
  databases and Microsoft Exchange databases can take a long time,
  or appear to hang, while the agent is waiting for a reply from
  Microsoft VDS (Virtual Disk Service)
  
  CTGGA2398,Starting job for policy <SLAName> (ID:<SLAId>). id ->
  <JobId>. IBM Spectrum Protect Plus version 10.1.7-3102.
  ...
  CTGGA3149,[<DBServerHost>] [15/06/2021 22:30:27PM GMT-0700]
  Starting mount command.
  CTGGA3144,[<DBServerHost>] vSnap iscsi target IP address
  [#.#.#.#] is used for iscsi connection.
  CTGGA2325,[<DBServerHost>] Waiting for remote operation to
  complete on server <DBServerHost>
  CTGGA2325,Waiting for remote operation to complete on server
  <DBServerHost>
  ...
  DETAIL,<timestamp>,Wed 23 Jun 2021 09:36:58
  PDT,2,CTGGA2325,Waiting for remote operation to complete on
  server <DBServerHost>
  CTGGA1709,Failed to run apps on <DBServerHost> stdout=Unable to
  determine application output
  ...
  ==> Job appearing to hang for 7 days  with finally completing
  with status partial.
  SUMMARY,<timestamp>,CTGGA2340,Job policy <SLAName> completed in
  <x> hr(s) <y> min(s) <z> sec(s) and ended with status PARTIAL.
  id <JobId>
  
  This will happen after the vsnap ISCSI lun is mounted to the SQL
  Server and there is an issue with Microsoft VDS replying back to
  the IBM Spectrum Protect Plus Agent.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus levelx 10.1.x                      *
  ****************************************************************
  * 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.8 *
  * iFix2 and 10.1.9. Note that this is subject to change at the *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• Added a 30 minute timeout to rescan APIs on the Windows agent
  side. This will prevent the job from hanging if the rescan
  command hangs.
  

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