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
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.