TrexUpdate failed on table '_SYS_REPO:ACTIVE_OBJECTCROSSREF' with error: unique constraint violation
I imported contents from one HANA system(SPS12) to another (HANA 2.0SP1 ) and now I am trying to activate the attribute view.
By any means I am not able to activate and get following error
TrexUpdate failed on table '_SYS_REPO:ACTIVE_OBJECTCROSSREF' with error: unique constraint violation on pos=0 for table SP2::_SYS_REPO:ACTIVE_OBJECTCROSSREFen, key: $trexexternalkey$=10,bics.basic;14,BICS_CUSTOMER1;13,attributeview;0,;4,BICS;17,FOODMART_CUSTOMER;20,__RT_CATALOG_TABLE__;0,;0,;0 already exists as udiv=2423, rc=55
2 Answers
-
Former MemberJan 03, 2018 at 02:49 AMI also ran into the exact same issue today and have resolved it using the below steps.
Let's read the error message very carefully. The error message says the HANA internally tried to update a table and it failed to do so as it errors out. The error says unique constraint violation. Next we identify the table which HANA internally tried to insert to: "_SYS_REPO"."ACTIVE_OBJECTCROSSREF". I could access this table using the SYSTEM user.
Next let us try to map the fields of the table to this error message:
FROM_PACKAGE_ID : bics.basic
FROM_OBJECT_NAME : BICS_CUSTOMER1
FROM_OBJECT_SUFFIX : attributeview
TO_TENANT_ID : <blank>
TO_PACKAGE_ID : BICS
TO_OBJECT_NAME : FOODMART_CUSTOMER
TO_OBJECT_SUFFIX : __RT_CATALOG_TABLE__
SRC_PATH : <blank>
DST_PATH : <blank>
REF_TYPE : <blank>
Now try to select the table with the above filter conditions:
The query will be similar to:
select * from "_SYS_REPO"."ACTIVE_OBJECTCROSSREF"where from_object_name = 'BICS_CUSTOMER1' and from_package_id = 'bics.basic'
Next delete the entries using a command similar to:
delete from "_SYS_REPO"."ACTIVE_OBJECTCROSSREF"<br>where from_object_name = 'BICS_CUSTOMER1' <br>and from_package_id = 'bics.basic'
Please note I used SYSTEM user to follow the above steps.
Add comment
Add comment