SAP Knowledge Base Article - Preview

2863613 - How to replicate from primary to target with added columns and a different name and text or image columns - SRS

Symptom

Different tries gave different errors including:

  • When the function string included the text column:

    ERROR #29029 USER(myuser) - eneric/dsi/fstrobj.c(3212)
    Syntax error in the output template. The variable 'mytextcol' is not a legal one for the modifier 'new' for the function 'rs_insert' and object 'mytable'.
     
  • When the table names are different and the replication definition does not specify this information:

    ERROR #1028 DSI EXEC(109(1) target.pubs2) - neric/dsi/dsiqmint.c(5172)
    Message from server: Message: 4701, State 1, Severity 11 -- 'Cannot truncate table 'mytable', because this table does not exist in database 'pubs2'.

    THREAD FATAL ERROR #5049 DSI EXEC(109(1) da_target.pubs2) - neric/dsi/dsiqmint.c(5185)
    The DSI thread for database 'target.pubs2' is being shutdown. DSI received data server error #4701 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.

    THREAD FATAL ERROR #5273 DSI EXEC(109(1) target.pubs2) - neric/dsi/dsiqmint.c(5213)
    To write the failed transaction into log, please execute 'sysadmin log_first_tran, da_target, pubs2'. Please analyze the transaction and provide an appropriate fix based on your analysis, then resume the connection.

    OR

    'begin transaction '
    Command(s) to 'da_target.pubs2':
    'INSERT into mytable  ([....

    Command(s) to 'target.pubs2':
    'select mytext from mytable where id=1 '
    ERROR #5149 DSI EXEC(107(1) target.pubs2) - eneric/dsi/dsiexec.c(8352)
    Function 'rs_get_textptr' for 'mytable' returned no rows.
    The DSI thread for database 'target.pubs2' is shutdown.

What is the process to replicate data data with a text column to a replicate with a different name and different structure?


Read more...

Environment

SAP Replication Server (all versions)

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

function string class primary source target replicate repserver replication server alter connection resume suspend subscription replication definition repdef sub , 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.