Symptom
You connected SuccessFactor into SAP Data Warehouse Cloud, via connection type Generic OData.
When replicating data in Remote Table Monitor, it fails with error:
Error: {"timestamp":20XX-XX-XX 00:00:00.0000000,"origin":"_sys_task","message":"cannot insert NULL or update to NULL: TrexColumnUpdate failed on table '<SPACE_TECH_NAME>:<REMOTE_TABLE_TECH_NAME>$CT' with error: constraint NOT NULL violation;checkNotNullColumn(): found NULL on pos 0,column 'overallScaleName'; $table$=<SPACE_TECH_NAME>:<REMOTE_TABLE_TECH_NAME>$CT
constraint NOT NULL violation;checkNotNullColumn(): found NULL on pos 0,column '<column_name>' rc=56 at SQLUpdate/Storage/Impl/ColumnStorageChange.cc:107, Statement: ,INSERT INTO "<SPACE_TECH_NAME> "."<REMOTE_TABLE_TECH_NAME>$CT"...
Read more...
Environment
SAP Data Warehouse Cloud
Product
Keywords
persisting, persist, loading, load, snapshot , KBA , DS-DI-RT , Remote Tables , Problem
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.