IT41243: MICROSOFT SQL DATABASE LEGACY OR VSS BACKUP IS FAILING WITH RC 402 AND RC=1914 WHEN THERE IS A QUOTE IN THE DATABASE NAME

APAR status

• Closed as program error.

Error description

• When attempting to perform a legacy or VSS backup of a SQL
  database using Data Protection for SQL, and if the database name
  contains a single quote, the backup may fail with the following
  the tdpsql error log (in this example, the SQL DB name is (DB01-
  name's):
  
  ANS1512E Scheduled event 'SCHED_NAME' failed.  Return code =
  402.
  ANS0344E Cannot Send data with a zero byte sizeEstimate.
  ACO3002 Data Protection for SQL: log backup of database DB01-
  name's from server SQLSERVER_NAME failed, rc = 1914.
  
  In the TDPSQL trace:
  [003356] [9900] : backupdb.cpp        (4001): Exit
  CBackupDb::run(), rc = 418, msg =
  
  [003356] [9900] : backupdb.cpp        (1817): backupDbList():
  backupDb.run() failed rc = 418 bAnyBackupFailed = True
  [003356] [9900] : backupdb.cpp        (2821): Enter
  CBackupDb::GetDbObjectName()
  [003356] [9900] : backupdb.cpp        (2849): DB Object Name:
  20220218104016\00000D1C
  [003356] [9900] : backupdb.cpp        (2852): Exit
  CBackupDb::GetDbObjectName()
  [003356] [9900] : clcstatu.cpp        ( 609): Enter
  CStatus::dbCommandStatus()
  
  When there is a single quote in the database name,  the single
  quote will be replaced with the two quotes to recognize as a
  single quote in the database name. But when trying to fetch the
  available database names, it is not detecting the
  
  database names with a single quote, hence the query is failing
  with syntax errors.
  
  
  IBM Spectrum Protect / Protect Plus Versions Affected:
  IBM Spectrum Protect Data Protection for Databases all versions
  up to 8.1.14
  

Local fix

• This problem could be bypassed by renaming the database to a
  name that doesn?t include a quote.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect for Databases: Data Protection for      *
  * Microsoft SQL Server versions 8.1.12 and above.              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is projected *
  * to be fixed in Data Protection for Microsoft SQL Server      *
  * versions 8.1.17.                                             *
  * Note that until the fix is actually available, this          *
  * information is subject to change at the discretion of IBM.   *
  ****************************************************************
  

Problem conclusion

• After applying the fix, backup operation for the databases
  containing single quote in the database name should succeed.
  

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:

Fix information

• Fixed component name

  TDP FOR SQL WIN

• Fixed component ID

  5698DPSAP

Applicable component levels