IT42416: "UNRECOGNIZED TOKEN" ERROR ON MICROSOFT SQL DATABASE BACKUPS

APAR status

• Closed as program error.

Error description

• An IBM Spectrum Protect Plus Microsoft SQL database backup can
  stop with the following messages seen in the job log :
  
  CTGGE0084,[<SQLServerAddress>] SQL backup failed  reason
            [SQLite INSERT/UPDATE statement failed  error
            [unrecognized token: "\"]  return code [1]].
  CTGGA2073,[<SQLServerAddress>] Failed to perform backup of db
            instance <InstanceName> on application server
            <SQLServerAddress> : Unable to retrieve file
            vssbackupdocs.zip from <SQLServerAddress>.
            e=java.lang.Exception: Error= File not Found
  
  This happens when a single <?> is used in a database of log
  filename.
  
  In the application command log found in the job log bundle, the
  detail of the affected SQLite INSERT/UPDATE statement is seen :
  
  DEBUG sqlvdiwrapper - INSERT/UPDATE table statement
       [INSERT INTO FILE_APPFile
          (FileID,
          ...
        VALUES (...
         'filename.ldf'',
         '\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopyxx\DATA01\
          Microsoft SQL Server\MSSQL15.MSSQLSERVER\DATA\
          filename.ldf'',
         'c:\programdata\spp\mnt\sppb_spp_1005_2126_1841463f080\
          <InstanceName>\<DBName>\henry_test2_log_ldf'_<timestamp>
          \filename.ldf'',
         '\\?\globalroot\device\harddiskvolumeshadowcopyxx\',
         'c:\programdata\spp\mnt\sppb_spp_1005_2126_1841463f080\',
         'K:\Microsoft SQL Server\MSSQL15.MSSQLSERVER\DATA',
         'c:\programdata\spp\mnt\sppb_spp_1005_2126_1841463f080\
          <InstanceName>\<DBName>\filename.ldf'_<timestamp>',
         ...
        ON CONFLICT (FileID)
        DO UPDATE SET FileName = excluded.FileName,
        ...
  ERROR sqlvdiwrapper - SQLite INSERT/UPDATE statement failed,
        error [unrecognized token: "\"], return code [1]
  
  In the above case, the filename causing the problem is
  filename.ldf'
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  
  Additional Keywords: SPP, SPPLUS, TS011044355
  

Local fix

• Update the filename to remove the special character using
  Microsoft SQL Management Studio.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus 10.1.9, 10.1.10, 10.1.11, 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 a SQL database file
  path contains single quote, the backup can be completed
  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

• SQL
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels