SAP Knowledge Base Article - Preview

2053389 - General error '287 cannot insert NULL or update to NULL' from HANA - SAP RS

Symptom

  • RS stops with the following error. No changes were made to either the source db, target db or replication definitions.
  • From RS errorlog :

T. . (204): 'insert into CII_MEDRIO_REPLICATION.SubjectVisitCollection_tbl (SubjectVisitCollection_ID, Subject_ID, MeasurementPoint_ID, IsLocked, Study_ID, RepeatLabel, MeasurementPointRepeatSetting_ID) values (? , ? , ? , ? , ? , ? , ? ) '
T. . (204): 'exec I_1_SubjectVisitCollection_tbl SubjectVisitCollection_ID = 63719, Subject_ID = 132157, MeasurementPoint_ID = 9609, IsLocked = 0, Study_ID = 1856, RepeatLabel = , MeasurementPointRepeatSetting_ID = NULL '
I. . 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'.
H.. THREAD FATAL ERROR #5049 DSI EXEC(134(1) HANA_TST_MEDRIO.RDB) - dsiqmint.c(4732) The DSI thread for database 'HANA_TST_MEDRIO.RDB' is being shutdown. DSI received data server error #-1 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #0 mapped from input command #0 of the failed transaction.
I.. The DSI thread for database 'HANA_TST_MEDRIO.RDB' is shutdown.


Read more...

Environment

  • SAP Replication Server Version 15.7.1 SP1xx

Product

SAP Replication Server 15.7

Keywords

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

Search for additional results

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