SAP Knowledge Base Article - Preview

2074267 - Update fails with error 102 when there is not a replication definition for table - SAP RS


  • In MSA or Warm-Standby environment a text column update fails with 'Incorrect syntax near 'FAILED' when there is not repdef for table, when executing the following statement:

update tb01 set text_value = 'update this text91' where ID = 1

  • DSI goes down due error 102, in the log:

T... (82): 'update dbo.tb0' set ASSERTION FAILED  where ID=1 '
E... ERROR #1028 DSI EXEC(106(1) server02.dbstb) - dsiqmint.c(4719) Message from server: Message: 102, State 181, Severity 15 -- 'Incorrect syntax near 'FAILED'.'.
H... THREAD FATAL ERROR #5049 DSI EXEC(106(1) server02.dbstb) - dsiqmint.c(4732) The DSI thread for database 'server02.dbstb' 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.
I... The DSI thread for database 'server02.dbstb' is shutdown.



SAP Replication Server 15.7.1 SP121  and later


SAP Replication Server 15.7


ASSERTION, FAILED, CR765114, 765114 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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.