Symptom
- How to replicate tables containing column names that are reseved words or contain space?
- A column name with reseved word "insert" raised the following error.
Last command to 'dsname.testdb':
Output command: insert into t1 (col1, col2, key) values (1, 'string1', 'string2')
ERROR #1028 DSI EXEC(109(1) dsname.testdb) - dsiqmint.c(4445)
Message from server: Message: 156, State 2, Severity 15 -- 'Incorrect syntax near the keyword 'key'.
THREAD FATAL ERROR #5049 DSI EXEC(109(1) dsname.testdb) - dsiqmint.c(4458)
- A column name with space. For example: "TAX RATE", raised the following error.
ERROR #1028 DSI EXEC(104(1) dsname.testdb) - neric/dsi/dsiqmint.c(5095)
Message from server: Message: 102, State 181, Severity 15 -- 'Incorrect syntax near 'RATE'.'.
THREAD FATAL ERROR #5049 DSI EXEC(104(1) dsname.testdb) - neric/dsi/dsiqmint.c(5108)
The DSI thread for database 'dsname.testdb' 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 #1 mapped from input command #2 of the failed transaction.
Read more...
Environment
SAP Replication Server (SRS)
Product
SAP Replication Server 15.7
Keywords
repserver, sybase, dsi_quoted_identifier, repdef, "replication definition", quoted, identifiers , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To
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