SAP Knowledge Base Article - Preview

2163384 - MSSQL Error: 102 "Incorrect syntax near '/' " replicating UDB to MSSQL - SRS

Symptom

  • Replicating from UDB (ie, not mainframe DB2) to Microsoft SQLServer (MSSQL).
  • Getting error in SAP Replicaiton Server (SRS):

ERROR #1028 DSI EXEC(nnn(1) MSSQL_ECDA.DBNAME)
Message from server: Message: 102, State 0, Severity 15 --
'[[Message Iteration=1|Data Source Name=SQL_SAP_REP|SQLState=42000|Native Error=102|Message=[Microsoft][ODBC SQL Server Driver][SQLServer]Incorrect syntax near '/'.]'.

THREAD FATAL ERROR #5049 DSI EXEC(105(1) MSSQL_ECDA.DBNAME)
The DSI thread for database 'MSSQL_ECDA.DBNAME' is being
shutdown. DSI received data server error #102 which is mapped to
STOP_REPLICATION. See logged data server errors for more information.

The data server error was caused by output command #0 mapped from input
command #0 of the failed transaction.

  • Repserver log shows lots of question marks ( "?" ) in the generated SQL statments.

Read more...

Environment

  • SAP Replication Server (SRS)
  • SAP Replication Server (SRS) Real Time Loading (RTL)
  • SAP Replication Server (SRS) Heterogeneous Edition
  • SAP Replication Server Option (RSO) for IBM DB2
  • SAP Replication Server Option (RSO) for Oracle
  • SAP Replication Server Option (RSO) for Microsoft SQL Server

Product

SAP Replication Server all versions ; SAP Replication Server, heterogeneous edition all versions ; SAP Replication Server, option for IBM DB2 all versions ; SAP Replication Server, option for Microsoft SQL Server all versions ; SAP Replication Server, option for Oracle all versions ; SAP Replication Server, real-time loading edition all versions

Keywords

dynamic, sql, 783413, CR783413 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , BC-SYB-REP-RSO , Rep Server Options (RSO) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.