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.
SAP Knowledge Base Article - Preview