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 for Me (Login required).

Search for additional results

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