SAP Knowledge Base Article - Preview

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

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

SAP Replication Server 15.7

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.