Skip to Content
0

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

Aug 04, 2017 at 10:19 AM

235

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 03 at 02:49 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Aug 04, 2017 at 10:04 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded