Orphaned Database record. 1

[charlestdenver]

I had a test company that I would use to check on various problems, or go back in time to check transactions by restoring the active databases to the test one. A while back I was doing this process and the restore failed due to a disk space issue. I ended up with a corrupt database and deleted it.
The problem I'm having now is that two users have tried to log into the deleted test and even though it failed the user activity shows that the users are logged in, which ties up a couple of my licenses.
I have tried to run a delete activity sql script on the dynamics database but it is failing with the message that the test database doesn't exist.
I have also tries to have the users log into that company thru great plains. In that case we get th standard message "you are already logged into this company, would you like to view your loggins?" Doing that and trying to delete the loggin I get an error "A get change operation on table 'SY_END_ROUTINES_CHECK_MSTR' failed accessing SQL data".
The company doesn't show up in GP utilities but does on the login menu in Great Plains. The vesion is 10.
Does anyone know what SQL records I need to delete to clear this?

Thanks
Charles

 

[VictoriaYudin]

If I understand correctly, the TEST company is no longer there, but is still showing 'remnants' in some places. If so, make sure that it's not showing in the list of databases in SQL. (If it is, delete the database from SQL directly.) Then run the clear company script in KB article 855361:

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;855361.

Finally, if there are still activity records in SQL, get all the users out of GP and run the following:

delete DYNAMICS..ACTIVITY
delete DYNAMICS..SY00800
delete DYNAMICS..SY00801
delete tempdb..DEX_LOCK
delete tempdb..DEX_SESSION

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com