SAP Knowledge Base Article - Preview

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

Symptom

  • 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.


Read more...

Environment

SAP Replication Server 15.7.1 SP121  and later

Product

SAP Replication Server 15.7

Keywords

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.