Skip to Content (Press Enter)
2013-11-21 00-40-55
Curt Raddatz
1949Views
11Comments
Solved
Accidental Deletion of an eSpace
Question
Personal Environment
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
0
0
09 May 2016
Copy Link
2024-06-12 10-07-10
Daniel Martins
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.
See solution in context
8
0
16 May 2016
Copy Link
UserImage.jpg
aung thiha

Daniel Martins wrote:

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.

I tried the same way for deleted extension but it doesn't work. it is showing error on service center if I retrieve by module id. Appreciate if someone can help.


0
0
16 May 2019
Copy Link
2016-04-22 00-29-45
Nuno Reis
 
MVP
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 ;)
1
0
09 May 2016
Copy Link
2013-11-21 00-40-55
Curt Raddatz
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
0
0
09 May 2016
Copy Link
2024-06-12 10-07-10
Daniel Martins
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.
8
0
16 May 2016
Copy Link
UserImage.jpg
aung thiha

Daniel Martins wrote:

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.

I tried the same way for deleted extension but it doesn't work. it is showing error on service center if I retrieve by module id. Appreciate if someone can help.


0
0
16 May 2019
Copy Link
2013-11-21 00-40-55
Curt Raddatz
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
0
0
16 May 2016
Copy Link
UserImage.jpg
POORVI  ROY

Where will i write the query:

SELECT * FROM dbo.ossys_Esapce

Please someone help me

Please

Thanks in advance

0
1
07 Jul 2019
Copy Link
2020-04-28 17-43-32
pratiksha Dabhade

POORVI ROY wrote:

Where will i write the query:

SELECT * FROM dbo.ossys_Esapce

Please someone help me

Please

Thanks in advance


can use mysql for these query

0
0
17 Apr 2020
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

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.

0
0
07 Jul 2019
Copy Link
2019-10-04 15-01-22
Dhiraj Manwani

Please help me on this issue...

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

0
0
20 Aug 2019
Copy Link
2016-04-22 00-29-45
Nuno Reis
 
MVP

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

0
0
20 Aug 2019
Copy Link
2019-10-04 15-01-22
Dhiraj Manwani

Nuno Reis wrote:

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

Hi Nuno,


I dint got you....can you please break it in steps...?

and where do i need to find entity espace...in  service studio...?


0
0
20 Aug 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.