IT27968: 'BACKUPCOMPLETE FAILED' ON SQL BACKUP JOB COMPLETION ALTHOUGH ALL DATABASE FILES ARE TRANSFERRED SUCCESSFULLY

APAR status

• Closed as program error.

Error description

• Although all SQL database files are transferred successfully,
  SQL backup may set the completed databases as failed due to the
  exception caused by inter-threads message communication. The
  partial failure case and error handling are not implemented
  properly. Job log shows:
  
  INFO,<JobID>,<timestamp>,2,[sqlserver.domain] Data transfer from
  [\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy100\MSSQL11.MSSQL
  SERVER\MSSQL\DATA\SQLDB_data.mdf] to
  [c:\ProgramData\SPP\mnt\SPPB_spp_1000_2000_1600ABC3300\sql00_sql
  db_1540900448560\SQLDB_data.mdf] is done  max parallel streams
  [5]  the total data transferred: [700.06]GB estimated total
  size: [700.06]GB  transfer time: [15h:32m:20s]
  throughput[15.29]MB/s
  INFO,<JobID>,<timestamp>,2,[sqlserver.domain] Total data
  transferred is [7.20]TB total time [60h:50m:05s]  throughput
  [40.72]MB/s
  INFO,<JobID>,<timestamp>,2,[sqlserver.domain] Backup application
  files end
  INFO,<JobID>,<timestamp>,2,[sqlserver.domain] Deleting snapshot
  INFO,<JobID>,<timestamp>,2,[sqlserver.domain] VSS backup
  complete
  ERROR,<JobID>,<timestamp>,2,[sqlserver.domain] BackupComplete
  failed to complete
  ERROR,<JobID>,<timestamp>,2,Backup of all databases failed
  :BackupComplete failed to complete
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Level 10.1.2 and 10.1.3                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in  10.1.2.350, 10.1.3 patch 1 and     *
  * 10.1.4. Note that this is subject to change at the           *
  * discretion of IBM                                            *
  ****************************************************************
  

Problem conclusion

• Fixed an issue with the logic of finding protected databases
  when some of the files fails during a data transfer.
  

Temporary fix

• Run the job again to backup all the databases.
  

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

• cbt
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels