cancel
Showing results for 
Search instead for 
Did you mean: 

How to locate to SAP Business One Upgrade Log File

Former Member
0 Kudos

Hi there,

I encountered the error below while running the upgrade check on SAP 8.81 PL09.

"Duplicate records found for unique indexes in user-defined table".

The related SAP Note:1343077 says I need to go to the log file to identify the UDT.

Can you kindly advise where I can locate to the above mentioned log file?

Thank you.

Regards,

Yadana

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Yadana,

How many UDT do you have, if not too many, you may just run simple query to find them out.

SELECT U_UDF, COUNT(U_UDF) FROM [dbo\].[@UDT\]

GROUP BY U_UDF

HAVING COUNT(U_UDF) > 1

Thanks,

Gordon

former_member541807
Active Contributor
0 Kudos

hi,

check this SAP Note [ 1059761 - Create unique index terminated because a duplicate key - UDT|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3030303130353937363126]

regards,

Fidel