accidently deleted tables

[Former Member]

Hi all,

Let me explain my problem.....

I created 2 data table by using Add on in .NET 2005....

After this some how i deleted these 2 tables manually from SQL Server....

and then I cleared their entry from OUTB table

Now in any add on while trying to connect comapny database by

ocompany.connect()

i am getting following error...

"Attempted to read or write protected memory. This is often an indication that other memory is corrupt."

How could i overcome this problem???

Help me......

Thank you...

Rajesh

[Former Member · Accepted solution]

Hi Rajesh,

You didnt mention deleting the User fields related to those tables. Their entries are in the CUFD Table. Try removing them as well and then restart the lisence server and SAP.

Hope it Helps

Regards

Rizwan Hafeez

Team Lead

SAP Addon Development Section

Abacus Consulting - Pakistan

[Former Member · Accepted solution]

Thanks Rizwan Hafeez

It perfectly worked for me....

Thanks a lot

[Gianluigi]

You shouldn't have deleted these table with SQL Server. You must use DI API

metadata objects UserTablesMD. If you did that you wouldn't have corrupted

your database.

This is one of the many reasons why direct access to SQL server is forbidden and

why solution certification guidelines expressly check against this.

[Former Member]

Thanks Gianluigi

Infact i am new to SAP B1 so i did that.

Now i will make sure that will not happen in future.