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