Known issue: I get an "Error creating table: <tablename> (-5002 - Table cannot be created; user table <tablename> already exists in the database)

During the installation of B1UP, there can be an error stating that a User Defined Table cannot be created. The table name can vary, but the underlying issue is the same:

Error creating table: BOY_SBO_LICASSN (-5002 - Table cannot be created; user table BOY_SBO_LICASSN already exists in the database)

This error indicates that the database is corrupted or there's something else wrong with it. It could be caused by multiple things, but the troubleshooting must be started by checking this SAP note: https://launchpad.support.sap.com/#/notes/1076082

If the queries in the note bring back any results, please contact SAP support so they can help you to fix the database. Do not try to fix the problem by yourself, as the database could be damaged beyond repair.

That being said, this issue can also be reproduced without B1UP. You can try to create the UDT mentioned in the error manually in the SAP Client without B1UP running and get an error.

For example, if the table in the error is “BOY_SBO_LICASSN”, you can try to create the UDT manually in the SAP client:

This verifies that the problem is indeed within the database, and you can send this error to SAP support when you create the support ticket.

The same kind of issue can also state that it has issues creating a specific UDF or UDO. In such a case the procedure is the same: check the SAP note and if you get results back from the queries, contact SAP support.