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
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-RSO , Rep Server Options (RSO) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview