JR64490: IDR FASTLOAD REFRESH MAY FAIL WITH "INCORRECT SYNTAX" ERROR WHEN DATABASE NAME CONTAINS SPECIAL CHARACTERS

APAR status

• Closed as program error.

Error description

• IDR Fastload refresh fails with the  error like Fast Bulk Copy
  failed to load into target table dbo.TABLE_NAME.
  Errors occurred in BCP during loading of C:\Program Files\IBM\
  Test\INSTANCE_NAME\datadboTABLE_NAME16418443523051.bcp.
  A SQL exception has occurred. The SQL error code is '102'. The
  SQL state is: HY000. The error message is:
  [CDC][SQLServer JDBC Driver][SQLServer]Incorrect syntax near
  '-'.
  com.datamirror.ts.target.apply.mssql.fastload.MssqlFastLoadNode
  execute()       Errors occurred in BCP during loading of
  C:\\Program
  Files\\IBM\\Test\\INSTANCE_NAME\\datadboTABLE_NAME16418443523051
  .bcp.|A SQL exception has occurred. The SQL error code is
  '102'. The SQL state is: HY000. The error message is:
  |[CDC][SQLServer JDBC Driver][SQLServer]Incorrect syntax near
  '-'
  

Local fix

• 1) If possible, remove special characters from database name.
  2) Use JDBC Apply
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you use  IDR 11.4.0.4-5618 or *
  * older for Microsoft SqlServer, and the name of a database    *
  * being replicated contains special characters such as         *
  * hyphens.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Refreshing a subscription with Fastload configured can fail. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5622 or newer for Microsoft SQL      *
  * Server                                                       *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5622 or newer for Microsoft SQL Server
  resolves the issue.
  

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

  IS CDC SQL

• Fixed component ID

  5725E30SQ

Applicable component levels