Mistakenly deleted all sys_user_has_role data from my instance

shreyashett
Tera Contributor

Hello Service now team while I was working on project I mistakenly deleted all data from sys_user_has_role table data now I cant access my instance please help me with that as I have all my important data in that instance 

Instance name: dev321958 this is my instance name. Please please help me with this
3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @shreyashett 

There’s no other option left—you’ll need to reset your PDI now. Unfortunately, there’s no official support available for PDIs, so no one can assist with this issue. Please note that resetting the instance will erase everything, so proceed with caution.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AndersBGS
Tera Patron
Tera Patron

Hi @shreyashett ,

 

If you can't access your instance by going to https://developer.servicenow.com/dev.do and press start building to open your instance, then I agree with @Dr Atul G- LNG - Then the only thing would be to reset your PDI but which in that turn also will make you lose all your development that you haven't backed up.

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Mark Manders
Mega Patron

Did you even delete the admin role from your admin user? In that case, you need to reset. There is no support on PDIs. But you can check if you can just login from the developer site (from there, the auto login with the admin account is done). Resetting means your work will be gone if you didn't back it up.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark