How to Recover Deleted values from a Table

[Former Member]

Hai!

I am using SAP B1 Patch38 and MS-SQL 2005

I unknowingly deleted the values from table RITM. Now, i am not able to open the PLD Template in SAP.

Is there , any way to recover the values?

Pl help me out..

Regards,

Thanga Raj.K

09710445987

[K_Pauquet · Accepted solution]

Hi Thanga,

you will need to go back to your most recent backup of the productive database before the deletion occurred. Using copy express & then copying the table over will corrupt the database & you will lose ALL support from SAP.

Recommendation:

1. Restore latest backup of intact database

2. Determine the master data, document & journal delta transactions

3. Use SELECT queries to extract this data in a from that will easily populate the DTW templates

4. Import this data into the restored backup using DTW

5. Ascertain completeness & accurracy of data

6. Backup database

7. Use this db for productive use.

All the best,

Kerstin

[Former Member · Accepted solution]

Dear Kerstin,

thank u for your solution regarding the issue.

Regards,

Thanga Raj.K

09710445987

[former_member187989]

hi thangaraj,

If your database is live production database then

contact SAP support.

During regular work in SAP Business One, you enter, process, and update data. In specific scenarios, this data can be corrupted or disrupted due to certain user actions or global malfunctions. *You can resolve some of these cases by using the restore functions.*  

Do not run any of the restore functions yourself. It might damage your database permanently. *Restore should be undertaken only with the explicit instruction and assistance of SAP Business One support consultant*.

If you are using test database then try to restore latest backup.

Hope it will solve your problem.

Jeyakanthan

[Former Member]

Dear Jeyakanthan,

Thank u for ur valuable reply.

I tried like,

1.Restored Latest backup as a different database (DB name :company_Restored).

2.Copied PLD from company_Restored to Existing DB (DB name:Company_Original).

Its working fine,but i have to do for 90 PLD's.

Also i tried like Insert values from company_Restored RITM table, to Company_Original RITM Table its also

working.

I tested all this in my test system.

Will SAP support for this issue??

Regards,

Thanga Raj.K

09710445987

[Former Member]

SAP will not support any database, which is inconsistent, due to SQL-Queries, which modify datasets or the datastructure of the SAP Business One Database. This includes any update-, delete- or drop-statements executed via SQL-Server Tools or via the the query interface of SAP Business One.

Check this Note:

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=896891]

So the better option would be

option 2.Copied PLD from company_Restored to Existing DB (DB name:Company_Original).

You'll have to do this for all the 90 layouts. You may altenatively do for one or two layouts and teach this to the Client IT administrator and ask him to do the same for the rest of layouts.

[Former Member]

Dear Sir,

Thank u very much for your valuable reply.

I try to do the same (option 2)

Regards,

Thanga Raj.K