SAP Knowledge Base Article - Preview

2074341 - Error 102 - Incorrect syntax near 'FAILED' when enabling dynamic_sql - SAP RS


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


SAP Replication Server 15.7


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.