SAP Knowledge Base Article - Preview

2420351 - SAP SRS Error 8116 Argument data type varchar(max) is invalid for argument 1 of textptr

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

SAP Replication Server 15.7 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server ; Sybase Replication Server 15.7, heterogeneous edition

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.