SAP Knowledge Base Article - Preview

2108359 - LOB datatypes are not replicated into HANA - SAP RS 15.7

Symptom

  • Microsoft SQL Server LOB datatypes are not replicated into SAP HANA database
  • Replication from SQL Server 2012 database into SAP Hana, both, Repserver and Agent are running on Windows 2008 R2.
  • See error below in the RS errorlog:

ERROR #1027 DSI EXEC(102(1) xxxxx.xxx) - eneric\dsi\dsiutil.c(431) Open Client Client-Library error: Error: 39, Severity 5 -- '[ExpressConnect for ODBC Data Source|statement] d:\views\rs1571sp203_buildwinx64_vu\calm\repl\svr\code\generic\econn\odbc\odbcneeddata.cpp:168 odbcStatement::ParamData mNeedParamData is false, RCIExecute did not encounter a da.

or

Message from server: Message: -1, State 0, Severity 5  '[ statement ][ HANA_TST_MEDRIO ] SQLPrepare [SAP AG] [LIBODBCHDB DLL][HDBODBC] General error;287 cannot insert NULL or update to NULL: PROPERTYNAME'.


Read more...

Environment

  • SAP Replication Server (RS) 15.7.1 SP203 
  • SAP Replication Agent for Unix & Windows 15.7.1 SP202
  • HANA: 1.00.83.00.395718

Product

SAP Replication Server 15.7

Keywords

varchar(max), nvarchar(max), varbinary(max), unitext, lr_partial_updates_allowed, CR739065 , 739065  , KBA , 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.