Technical FAQs

Ask a Question

How to Restore a Deleted Source in ION EEM

Issue
Restoring a source which has been deleted.

Product
ION EEM

Environment
ION EEM (versions 3.95 SP1. 3.96. 4.0, 4.0 R2, 5.0)

Cause
A source has been deleted using the Admin Tool (right Click and Delete), accidentally or otherwise, and needs to be restored.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*


When a source has been deleted using the Admin Tool, it is not actually deleted from the system.  Rather it is 'marked' as hidden within the database.
This prevents the source from being recreated should DatabaseLoader -pairs be run again.

To undelete or unhide the source, the sources 'hidden' attribute in the SRC_Source needs to be modified to be 'false' instead of 'true'.
This will make the source appear again in the admin tool on the sources tab.

Execute the following query using a query window in SQL Management Studio:

Select *
from SRC_Source
where hidden = 1


Locate and note the value contained in the SourceID column of the results for the source to be restored.
Execute the following query, replacing x with the SourceID noted in the prior step.

Update SRC_Source
set hidden = 0
where SourceID = x


The source should now once again appear in the Admin Tool on the sources tab by clicking the Refresh button.

** see attachment containing the SQL script text


Was this helpful?
What can we do to improve the information ?