1403
Views
11
Comments
Solved
Accidental Deletion of an eSpace
I did a very dumb thing.  I accidentally deleted an eSpace from Service Center, not Service Studio.  I know I'm probably screwed but thought I would ask.  Any way to recover the eSpace?

Thanks,
Curt
Staff
Rank: #63
Solution
Hi Curt,

You should be able to find the record executing the following query:
SELECT * FROM dbo.ossys_Espace

And access it to download or to re-publish via the following url:

https://<server>/ServiceCenter/eSpace_Edit.aspx?EspaceId=<eSpaceID>

I have 100% sure that is the expected behaviour, or either it was deleted by someone directly in the database or caught by the "Check Old eSpace Versions to Delete" ServiceCenter routine.

Hope it helps you.
mvp_badge
MVP
Rank: #69
Yes, if you have a backup of database.

If not, the espace table has an IsActive column that is 0 when espace is Deleted. Maybe you can try to edit that (and a few other related tables).

Oh, and before that, do a backup of database ;)
Rank: #218
No backup is available unfortunately.

It seems that the record is actually deleted.  Just a quick list of the eSpace entity records doesn't show my deleted eSpace.  I appreciate the help.

Curt
Staff
Rank: #63
Solution
Hi Curt,

You should be able to find the record executing the following query:
SELECT * FROM dbo.ossys_Espace

And access it to download or to re-publish via the following url:

https://<server>/ServiceCenter/eSpace_Edit.aspx?EspaceId=<eSpaceID>

I have 100% sure that is the expected behaviour, or either it was deleted by someone directly in the database or caught by the "Check Old eSpace Versions to Delete" ServiceCenter routine.

Hope it helps you.
Rank: #218
Thanks for the great information though I already recovered it from notes that I had.  Fortunately it was small.  Hopefully the information you posted will help someone else if they do something dumb like this.  Thanks!

Curt
Rank: #32088

Where will i write the query:

SELECT * FROM dbo.ossys_Esapce

Please someone help me

Please

Thanks in advance

mvp_badge
MVP
Rank: #2

Hi Poorvi,

You can also use an Aggregate instead of SQL. If you have a cloud server, you likely cannot access the database directly, so you'll need to create an app to do so.

Rank: #998

Please help me on this issue...

I am not able to fire the query through application sql...

mvp_badge
MVP
Rank: #69

Dhiraj, find in system the entity espace. Add it and try to query with that.