solman 7.1 sp12 -REFRESH_ADMIN_DATA_FROM_SUPPORT-ITAB_DUPLICATE_KEY

[Former Member]

Hi experts, i have a solman 7.1 sp12 system(VAR SCENARIO)  which has been running for about 4 months, when we first installed it, it refreshed our clients information(systems,users,etc) with job REFRESH_ADMIN_DATA_FROM_SUPPORT. However we tried to refresh the info for a new client today, and when wee see the logs(in sm37) it has an internal error since our first archived log(about a month ago). When we go to ST22 , the DUMP says this:

Does anybody has any suggestions?

Any help would be apreciated.

Thanks!

[Former Member · Accepted solution]

Hi, found another thing, when trying to see my ibase in IB53 i get the same error message and the same dump, so i googled it related to ibase and got the note 1689369 ,but it has no manual actions, so i  tried to implement it with snote, but i get "sap note does not contain valid correction instructions". Any suggestions?

[former_member182657 · Accepted solution]

Hi Luis,

Have a look with SAP KBA at   2129811 - Dump ITAB_DUPLICATE_KEY happens when opening Ibase  & follow the instructions to resolve.

Hope this will help you.

Good luck !!

[Former Member · Accepted solution]

Thank you so much , it worked for me!!

If anybody is facing the same issue, this SQL query helped me find what items had duplicate values:

SELECT IN_GUID,COUNT(VALTO) FROM IBINTX

WHERE VALTO  =99991231235959

GROUP BY IN_GUID

HAVING COUNT(VALTO)>1

Regards!