2596913 - ACT_UPG: indexes for table "J_1BNFE_ACTIVE" have identical fields

Symptom

During upgrade to EHP 7 for ERP 6.0, below errors happen in phase MAIN_SHDRUN/ACT_UPG for Table J_1BNFE_ACTIVE

EDT012XActivate table "J_1BNFE_ACTIVE"
1EEDT509 Indexes "009" and "H33" for table "J_1BNFE_ACTIVE" have identical fields
1EEAD010 "Is valid for following DB systems:" " " " " " "
1EEAD010 "HDB" "(" "SAP HANA Database" ")"
1EEDT509 Indexes "008" and "HBE" for table "J_1BNFE_ACTIVE" have identical fields
1EEAD010 "Is valid for following DB systems:" " " " " " "
1EEAD010 "HDB" "(" "SAP HANA Database" ")"
2WEDT135 Flag: 'Incorrect enhancement category' could not be updated
3 EDT013 Table "J_1BNFE_ACTIVE" was not activated
3 EDT014XActivate dependent table "J_1BNFE_ACTIVE"
3 EDT038 Activation of dependent table "J_1BNFE_ACTIVE" successful
1EEDO519X"Table" "J_1BNFE_ACTIVE" could not be activated

Environment

EHP7 for ERP 6.0

Cause
This is a bug that new version of index still exists despite the deletion request.

Resolution

Refer Note : 

2596913 - ACT_UPG: indexes for table "J_1BNFE_ACTIVE" have identical fields

https://launchpad.support.sap.com/#/notes/2596913

As introduced in below note, you need to manually delete below indexes by SE11 in the shadow instance. After this you can continue the upgrade by repeat the phase from where it stops.

Note 1737650 - EHP7 for SAP ERP 6.0 SP Stacks - Release & Information Note

---------------------------------------------------------------
The ABAP Dictionary activation might fail due to duplicate indexes on table "J_1BNFE_ACTIVE". In that case delete indexes 008 and 009 in ABAP Dictionary and repeat the phase.
---------------------------------------------------------------

Hope this helps!!!

Abraham