3256667 - Unique constraint violation on table "ACTIVE_OBJECTCROSSREF" while upgrading S/4 HANA during phase MAIN_NEWBAS/XPRAS_AIMMRG

While performing  S/4 HANA upgrade to higher version, you are facing this issue during phase MAIN_NEWBAS/XPRAS_AIMMRG :

1) You can see the following error message in the upgrade log file
(/migration/logs/<SID>/SUM/abap/log/SAPR###XPRA########.<SID>):

=====================================================================================

A4 ERSOS_SEARCH 210 (Re-)deploying views of type "METADATA""20.220.824.044.544"
A4 ERSOS_SEARCH 295 "METADATA" Deployment started for TLOGO "PLSE" Association "998" at "20.220.824.044.544"
A4 ERSOS_SEARCH 296 "METADATA" Deployment finished for TLOGO "PLSE" at "20.220.824.044.544"
A4 ERSOS_SEARCH 295 "METADATA" Deployment started for TLOGO "PLSE" Association "999" at "20.220.824.044.544"
A4 ERSOS_SEARCH 296 "METADATA" Deployment finished for TLOGO "PLSE" at "20.220.824.044.545"
A2EERSOS_SEARCH 097 Unable to deploy view (TLOGO: "PLSE", view name: "PRIMARY")

A4 ERS2HANA_VIEW 004 Return code/argument: "40137". Message: "Activation is performed with activation mode ignor" "ant." " "
A2EERS2HANA_VIEW 004 Return code/argument: "301". Message: "Table(ACTIVE_OBJECTCROSSREF) with error: unique co" "nstraint violation on pos=# for table S4H::_SYS_RE"
A2EERS2HANA_VIEW 004 Return code/argument: "301". Message: "=48,system-local.bw.bwsearch.SAPHANADB.PLSE.METADA" "TA;7,PRIMARY;13,attributeview;0,;9,SAPHANADB;5,TAD"
A2EERS2HANA_VIEW 004 Return code/argument: "301". Message: "as udiv=4119
2EETP000 Table(ACTIVE_OBJECTCROSSREF) with error: unique constraint violation on pos=# for table"
A2EERS2HANA_VIEW 004 Return code/argument: "301". Message: "xexternalkey$=48,system-local.bw.bwsearch.SAPHANAD" "B.PLSE.METADATA;7,PRIMARY;13,attributeview;0,;9,SA"
A2EERS2HANA_VIEW 004 Return code/argument: "301". Message: "ready exists as udiv=4119" " " " "

=====================================================================================

2) Execute the SQL below on HANA DB, you can get non-zero value in the result column "COUNT" :

select count(*) from _SYS_REPO.ACTIVE_OBJECTCROSSREF ac
where REF_TYPE = 0 and (ac.from_package_id, ac.from_object_name, ac.from_object_suffix) not in
(select package_id, object_name, object_suffix from _SYS_REPO.ACTIVE_OBJECT) ;

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP S/4HANA 
• SAP HANA, platform edition 2.0

ACTIVE_OBJECTCROSREF, ACTIVE_OBJECT, MAIN_NEWBAS/XPRAS_AIMMRG, HANA_VIEW, Activation, Deployment, unique constraint violation, Activation is performed with activation mode , KBA , HAN-DB , SAP HANA Database , Problem