IT42307: SQL BACKUP FAILURE: 38, REACHED THE END OF THE FILE

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus backups of Microsoft SQL Server
  databases fail with the error message below.
  
  DETAIL,<timestamp> CDT,2,CTGGA3711,[<DBServerHost>] File
  [<Instance>\<DBName>.mdf] runs as incremental backup. Total data
  to be transferred [6.9 GB].
  DETAIL,<timestamp> CDT,2,CTGGA3107,[<DBServerHost>]
  [67%][5007753216] bytes was transferred for source file [\\?\GL
  OBALROOT\Device\HarddiskVolumeShadowCopy157\<Instance>\<DBName>
  .mdf].
  ERROR,<timestamp>,2,CTGGA3138,[<DBServerHost>] Failed to copy
  file from [\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy157\<I
  nstance>\<DBName>.mdf]to
  [c:\programdata\spp\mnt\sppb_spp_1027_2181_1835ea4f69b\<path>].
  Error: Copy file from [\\?\GLOBALROOT\Device\HarddiskVolumeShad
  owCopy157\TylerPulseMDF\Pulse.mdf]to
  [c:\programdata\spp\mnt\sppb_spp_1027_2181_1835ea4f69b\<path>]
  failed  [(38  Reached the end of the file..
  ERROR,<timestamp>,2,CTGGA2337,Backup failed for database
  <DBName>:Copy file from [\\?\GLOBALROOT\Device\HarddiskVolumeSh
  adowCopy157\<Instance>\<DBName>.mdf]to
  [c:\programdata\spp\mnt\sppb_spp_1027_2181_1835ea4f69b\<path>]
  failed  [(38  Reached the end of the file.
  ERROR,<timestamp>,2,CTGGA2653,<Instance> ==> <DBName>([Backup
  failed: Copy file from [\\?\GLOBALROOT\Device\HarddiskVolumeSha
  dowCopy157\<Instance>\<DBName>.mdf]to
  [c:\programdata\spp\mnt\sppb_spp_1027_2181_1835ea4f69b\<path>]
  failed  [(38  Reached the end of the file.
  
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  

Local fix

Problem summary

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

Problem conclusion

• This problem has been fixed so that when SQL incremental backup
  reaches the end of source database file of a size not multiple
  of 1MB, the incremental backup can be completed.
  

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

• SQL
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels