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.