IT27767: SQL BACKUP FAILURE: COPY FILE FAILED ERR[(38 REACHED THE END OF THE FILE.)

APAR status

• Closed as program error.

Error description

• During an IBM Spectrum Protect Plus SQL Application
  Backup the following error can be seen in the joblog:
  
    Job Log:
      Backup failed for database Hostname:\\?\GLOBALROOT\Device\
      HarddiskVolumeShadowCopy99\MSSQL13.DBNAME\MSSQL\
      DATA\FileName.mdf ==>[c:\ProgramData\SPP\
      mnt\SPPB_spp_166151D5188\dbname\dbname_
      FileName_1537952821574\FileName.mdf] copy file failed
      err[(38 Reached the end of the file.)]
    This is due to the reported file to be backed up exceeds
    the filesize boundary. Using the file above (FileName.mdf),
    has a file size of 63 GB, but it has a backup size of 134
    GB. This discrepancy is the cause for the error 38.
  
  Spectrum Protect Plus Versions Affected:
    IBM Spectrum Protect Plus versions 10.1.1 and 10.1.2
  Customer/L2 Diagnostics (If Applicable)
    N/A
  
  Initial Impact:
    Low
  Additional Keywords:
    TS001782027 SPP ISPP SQL BACKUP
  

Local fix

•   N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus levels 10.1.2, 10.1.1              *
  ****************************************************************
  * 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.2.247 and 10.1.3. Note that this is subject to change   *
  * at the discretion of IBM                                     *
  ****************************************************************
  

Problem conclusion

• The issue was fixed by forcing a base backup when file shrink
  condition is detected.
  

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

• guestapp
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels