Symptom
You're running SAP Replication Server with an heterogeneous replication set up from MS SQL Server to MS SQL Server and DSI connection goes down with the following error:
I. A grouped transaction of 20 individual transactions has failed in database '<data_server.database>'. Each transaction in the group will be executed individually.
E. ERROR #1028 DSI EXEC(114(1) (<data_server.database>) - neric/dsi/dsiqmint.c(5052)
Message from server: Message: 8116, State 0, Severity 16 -- '[[Message Iteration=1|Data Source Name=<data_server>| SQLState=42000 | Native Error=8116 | Message=[Microsoft][ODBC SQL Server Driver][SQL Server] Argument data type varchar(max) is invalid for argument 1 of textptr .
H. THREAD FATAL ERROR #5049 DSI EXEC(114(1) (<data_server.database>) - neric/dsi/dsiqmint.c(5065)
The DSI thread for database '<data_server.database>' is being shutdown. DSI received data server error #8116 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #1 mapped from input command #3 of the failed transaction.
H. THREAD FATAL ERROR #5273 DSI EXEC(114(1) (<data_server.database>) - neric/dsi/dsiqmint.c(5093)
To write the failed transaction into log, please execute 'sysadmin log_first_tran, <data_server.database>'. Please analyze the transaction and provide an appropriate fix based on your analysis, then resume the connection.
I. The DSI thread for database '<data_server.database>' is shutdown.
Read more...
Environment
- SAP Replication Server Reterogeneous Edition (RSHE)
Product
Keywords
Message 8116, STOP_REPLICATION, #8116, Native Error=8116, varchar(max), textptr , KBA , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP , Sybase Replication Server (standalone) , Product Enhancement
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.