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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.