How to deal with Duplicate Key error messages from B1UP Add-on

What is the symptom?
You are running SAP HANA and get this the following unexpected error from the B1 Usability Package with the message:

"Duplicate Key '<KEY>' found for object: <Boyum object> while reading data from the database. Please follow online article http://www.boyum-it.com/Link/DuplicateKey on how to remove the duplicates"

Example (Key and Object can be different for your scenario):

This issue can happen because SAP HANA is cases sensitive and our add-ons do not allow that (since it is not allowed on MSSQL). We try to block that you are ever able to get into this situation with various validations, but because we do not control the entire system end to end it can in rare cases still happen :-(

In most cases this error is preventing add-ons to run, so you need to fix it asap.

How to Fix it?
In order to fix you first need to find more specifically what is duplicated. You do this by going to HANA Studio and running the following SQL based on what object was reported to you:

SELECT * FROM "@BOY_41_FUNCTIONS" WHERE UPPER("Code") = 'UF-131'

(where UF-131 is the duplicate code you were given in the error message)
[If you can't see the error message and do not have a code you can check for it using this SQL Statement: SELECT UPPER("Code") FROM "@BOY_41_FUNCTIONS" GROUP BY UPPER("Code") HAVING COUNT(*)>1]

Here is an example of the SQL from my test-system

Now comes the hard part. To determine which of the records are the wrong one(s). If you are up for it, look at the columns to try and identify the data (If you are not able to do so contact support@boyum-it.com and we will help to identify it for you)

Once you know what record is the wrong one it is time to do a database backup (just to be sure) and delete the duplicate. In the B1UP download (http://www.boyum-it.com/sbo if you do not have it anymore) you have under tools the "UDO Entries Removal Tool.zip"

If you unzip and run this tool you can log into the troubled database

Locate the object with the duplicate

And delete the duplicate record

Once done you can restart SAP Business One and B1UP should be able to run again.