TrexUpdate failed on table '_SYS_REPO:ACTIVE_OBJECTCROSSREF' with error: unique constraint violation

[rahulkumarsap]

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

[Former Member]

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

[Former Member]

I have exactly same issue with you. Could you let me know if you find a solution? Thanks!