Symptom
-
Replication is from Microsoft SQL Server (MSSQL) to SAP Adaptive Server Enterprise (ASE) using SAP Replication Server (SRS):
MSSQL -> RepAgent MSSQL (RAM) -> SRS -> SAP ASE - A LOB column is defined as nvarchar(max) in MSSQL and rs_msss_nvarchar_max in the SRS replication definition.
- Insert of large xml data (> 4096 bytes) causes the following DSI EXEC error:
Message: 156, State 2, Severity 15 -- 'Incorrect syntax near the keyword 'where'
Read more...
Environment
- SAP Replication Server Option (RSO) for Microsoft SQL Server 15.7.1
- SAP Replication Server Heterogeneous Edition (RSHE) 15.7.1 & 16.0
- SAP Replication Server (SRS) 15.7.1 & 16.0
- SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0
Product
SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Replication Server, heterogeneous edition 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server
Keywords
unitext, text, image, partial lob update , KBA , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , 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.