11-09-2013 07:52 AM
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.
Solved! Go to Solution.
11-09-2013 11:27 AM
i reccommand to restore latest db backup. if you dont have latest backup then restore deleted table dbdict from that backup.
11-10-2013 05:47 AM
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.
11-10-2013 10:28 AM
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.
11-11-2013 01:11 AM
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.
11-05-2014 05:12 AM
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.