IT37408: SQL BACKUP DATABASE CAN FAIL WITH THE ERROR: "BACKUP FAILED .... THE SYSTEM CANNOT FIND THE PATH SPECIFIED"

APAR status

• Closed as program error.

Error description

• The Microsoft SQL feature enables to store large
  unstructured objects.
  The IBM Spectrum Protect Plus SQL backup of a database can fail
  with the error:
  
  "Backup failed for database Multimedia:Group SQL_INSTANCE...
  copy failed message [Failed to copy file
  from
  \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy5\XISData\SQLFiles
  treamData\$FSLOG\ffffffdd-fffffa3e-fff5.
  00000022-000005c1-0002.20dec72e-7b4e-4e7e-86f1-fe2d2c2d1d43~ec09
  0c6f-f565-46c8-99b8-74935bea88d2~00000022-
  000005c1-0002.57e-0.1000011to
  c:\programdata\spp\mnt\sppb_spp_1011_2118_17595ba586a\<DBName>\m
  ultimedia\
  filegroup_20210524013601\SQLFilestreamData\$FSLOG\ffffffdd-fffff
  a3e-fff5.00000022-
  000005c1-0002.20dec72e-7b4e-4e7e-86f1-fe2d2c2d1d43~ec090c6f-f565
  -46c8-99b8-74935bea88d2~
  00000022-000005c1-0002.57e-0.1000011 ; error: The system cannot
  find the path specified]"
  
  
  This happens when a source file is empty and the file name is
  long, which lead
  to destination file path of more than 256 characters.
  
  
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.4 and higher
  
  
  
  Additional Keywords: SPP, SPPlus, TS005724149, SQL. multimedia,
  BLOB, unstructured
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.*                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in 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

• Fixed an issue with copying files with zero size. After applying
  the fix backup of databases with zero file size will complete
  successfully.
  

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