SAP Knowledge Base Article - Preview

1853857 - How to replicate tables containing column names that are also sql keywords - SRS

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.