Update and insert sequence failed due to conflicting unique indexes on table /IWFND/I_MED_SRH (please read OSS note 626915 for details)

[former_member147856]

Hi  Friends,

we are facing an issue in TABIM Execution phase during an SP upgrade with SUM.

Update and insert sequence failed due to conflicting unique indexes on table /IWFND/I_MED_SRH (please read OSS note 626915 for details)

While trying to delete it from SE14 its getting dumped. due to syntax error.

please help use , already tried changing kernel version from 741 to 742.

OS HP-UX 11.31

DB Sybase ASE 15.7 sp 122

Attaching logs .

Thanks,

logs.txt.zip

TABIM.txt.zip

[Reagan]

Have you tried to drop the index from the DB level ?

Connect to the shadow system and call Tx SE16 - TATAF and enter /IWFND/I_MED_SRH in the TABNAME field and provide the output.

Regards

Reagan

[former_member147856]

After dropping the index from the DB level its still giving same error.

And SE16 is giving dump as SAP_BASIS patch upgrade is not yet complete.

Thanks,

[Reagan]

If you are unable to use Tx SE16 then could you query the table from the DB level ?

Reagan