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.
SAP Replication Server 15.7.1 SP121 and later
ASSERTION, CR767806, 767806 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.