Symptom
An update statement in a table causes DSI goes down due error 102 ('Incorrect syntax near 'FAILED') when enabling dynamic_sql in database connection. The trace will show:
T... (195): 'update tb30 set ASSERTION FAILED where ID=1 '
E... ERROR #1028 DSI EXEC(123(1) server02.dbmsa15) - dsiqmint.c(4719) Message from server: Message: 102, State 181, Severity 15 -- 'Incorrect syntax near 'FAILED'.'.
H... THREAD FATAL ERROR #5049 DSI EXEC(123(1) server02.dbmsa15) - dsiqmint.c(4732) The DSI thread for database 'server02.dbmsa15' 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.dbmsa15' is shutdown.
Read more...
Environment
SAP Replication Server 15.7.1 SP121 and later
Product
Keywords
ASSERTION, CR767806, 767806 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed
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.