Symptom
To be applicable, all of the following symptoms must be observed:
- ERROR #1028 DSI EXEC(121(1) RDS.RDB) - neric/dsi/dsiqmint.c(5172) Message from server: Message: 102, State 181, Severity 15 -- 'Incorrect syntax near 'â'. '.
- batch may include transactions containing large varbinary/image data in the middle
- resume connection to RDS.RDB, gives "incorrect syntax" error with different garbage characters in the "near" string.
- ERROR #1028 DSI EXEC(121(1) RDS.RDB) - neric/dsi/dsiqmint.c(5172) Message from server: Message: 102, State 181, Severity 15 -- 'Incorrect syntax near 'Qç1'.
- Running sysadmin log_first_tran, RDS, RDB shows, no syntax error. Verified to be a good transaction in the stable queue
- DSI tracing (trace 'on', dsi, dsi_buf_dump) shows a single corrupt SQL statement causing the problem, but that SQL statement is seen clean in the stable queue (according to log_first_tran)
Read more...
Environment
SAP Replication Server (SRS)
Product
SAP Replication Server 16.0
Keywords
KBA , misleading , truncated sql , function string , dsi_cmd_batch_size , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
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