Re: Accidentally deleted the incident Dbdict record. Please HELP! (518 Views)
Reply
Trusted Contributor
Posts: 388
Registered: ‎06-17-2013
Message 1 of 7 (559 Views)
Accepted Solution

Accidentally deleted the incident Dbdict record. Please HELP!

Hi Experts,

 

I have accidentally deleted the incident Dbdict record from Database Manager.  My job is at stake by doing this. Now the system has gone unstable. User can't submit the request.

How do I make my system stable again?

 

Please Help me by providing a solution.

 

Regards,

Sanjeev

 

Super Advisor
Posts: 239
Registered: ‎06-29-2011
Message 2 of 7 (541 Views)

Re: Accidentally deleted the incident Dbdict record. Please HELP!

u need to restore the db or dbdict for perticular table...

i reccommand to restore latest db backup. if you dont have latest backup then restore deleted table dbdict from that backup.
Thanks,

Deepesh
Honored Contributor
Posts: 900
Registered: ‎10-14-2010
Message 3 of 7 (524 Views)

Re: Accidentally deleted the incident Dbdict record. Please HELP!

Hi ,

 

if you have development server(which is copy of production system) then take unl of incidents dbdict from that system and load it in Prod system.

 

If you dont have dev system then unload take unload from OOB system and add the fields to this new dbdict which were added during customization, use datadict for field reference if you dont know which fields are newly added.

 

 

 

Re,

Abhijit K

 

Frequent Advisor
Posts: 36
Registered: ‎09-11-2013
Message 4 of 7 (518 Views)

Re: Accidentally deleted the incident Dbdict record. Please HELP!

Hi,

 

I am almost certain that when you delete the dbdict record, the whole table is gone. That means all the records that were in it are lost. 

 

The only solution here would be to restore a backup of the dbdict + all the records in the table.

 

Best Regards,

Miro

Trusted Contributor
Posts: 388
Registered: ‎06-17-2013
Message 5 of 7 (501 Views)

Re: Accidentally deleted the incident Dbdict record. Please HELP!

Hi all,

 

Thanks for the response.

I din't have any sort of backup. No database backup nor the .unl backup.

So what I did is, I have copied the create script from another server where service manager is installed and ran the create script in the affected server. After creating the table created the "incidents" database dictonary and then ran the "import newly created columns from SQL"

Solved the issue. Thankfully my job is saved.

I am not worried about the deleted data becasue this server is still in development environment(testing server). Yet to be migrated to production environment.

 

However, from now on, I will always remember to keep a backup of database before editing dbdict records.

 

Regards,

Sanjeev

Occasional Advisor
Posts: 13
Registered: ‎04-16-2014
Message 6 of 7 (151 Views)

Re: Accidentally deleted the incident Dbdict record. Please HELP!

I have teh same proble now,, and I have no backup !!

 

where can I find the create script?

Trusted Contributor
Posts: 388
Registered: ‎06-17-2013
Message 7 of 7 (129 Views)

Re: Accidentally deleted the incident Dbdict record. Please HELP!

Hi,

 

As you have deleted the dbdict record, its certain that the table has also been deleted from the database.

Do you have any other server where service manager is installed pointing to a different databse?

Let me know.

 

Thanks,

Sanjeev

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.