How to clean the add-on registration info on server side completely ?

[former_member244307]

Hi,

I have an issue right now, though i remove all my add-on via SAP B1 Administration add-on menu, i double check no company contains my add-on but still when i use same add-on name with same ver #, then i was told that there was already add-on in the system. My question is how i can remove my previous add-on completely, i am very sure that there is no entry through system add-on manager menu. In my situation, i have several company in one server. I guess when i deploy the add-on into different company with same add-on name and same version #, it caused some conflict and confused the system. So I want to know if there is a way to do complete cleanning.

Thanks!

Lan

[Former Member]

You may back up SBO-Common first. Then delete just the record for your specific add-on in the table. Do more testing to ensure none of the other databases got affected. Then you can reinstall your add-on.

If you read the support scope carefully, all UDTs or user add-ons are not covered by support anyway.

[former_member244307]

Hi Gordon,

Yes, i know. Any changes made to SAP DB directly are not supported by SAP.

Thanks!

Lan

[Former Member]

Hi Lan,

Did you clear the xml files of your sboclient?

These files can be found at: .../program files/sap/sap business one/

The files: AddOnsInstall.sbo" and "AddOnsLocalRegistration.sbo" open these files with an text- or xmleditor and delete the entries of your addon and restart your client.

HTH Regards Teun Aben

[Former Member]

Hi Lan,

Since the add-on info is stored in SBO-Common database, it is going to be a tough job to clean it up completely. Have you gone through all databases from client to ensure no companies' databases have the add-on selected?

Thanks,

Gordon

[former_member244307]

Hi Gordon,

Yes, I am pretty sure there is no add-on installed on any of these company. I checked them again. So is there any tool or steps to clean them?

Thanks!

Lan

[Former Member]

If you just need to update your add-on, reinstall the new version should be able to override the old one.

[former_member244307]

Hi Gordon,

In fact, i tried it before but it keeps give me error when i launch the add-on with same name and same ver # after i installed it and it caused me some weird error like rigistration is passed but it always be in connecting status in add-on manager window. But finally i found it could be version conflict because when i tried different add-on name and ver # then it works. Though i can use different ver # or different name but still it makes me feeling not good. Any suggestion?

Thanks!

Lan

[Former Member]

In your case, you may recreate a clean SBO-Common database by back it up first. Or you may clean up the add-on recorded in the table if there is no other part affect your B1 database.

[former_member244307]

Hi Gordon,

You mean use DELETE SQL to delete the possible add-on, can i do it ? Of couse i will backup the DB first.

Lan