[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2276
  • Last Modified:

Dynamics GP Login Error

A user keeps getting this error:
"The stored procedure smCleanupFilesBeforeLogin returned the following results. DBMS: 0, Microsoft Dynamics GP 20505"

It started after two people made an attempt to open the same file at the same time. Now one of them gets this error when trying to login. She is able to login after she does the swich user ( her user ID ) but all dates are set at 00/00/0000 and her reports dont work. How would I clear the DBMS or what ever to close that attempt.
0
GD_GRAY
Asked:
GD_GRAY
  • 5
  • 4
  • 2
1 Solution
 
digital_thoughtsCommented:
You could try stopping and restarting the SQL Server service(s).
0
 
GD_GRAYAuthor Commented:
That server has two other active DB's with about 40 clients attached so Im not able to at this time. It would be nice if I could start / stop it like IIS.
0
 
digital_thoughtsCommented:
In SQL Server 2005 you can take a database offline, then back online, that might work.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
GD_GRAYAuthor Commented:
Can I do it in 2000 ? Thats what I run
0
 
digital_thoughtsCommented:
Yes, you can do that in SQL Server 2000 as well, just right-click on the database, under "All Tasks" select the "Take Offline" then repeat to bring back online.
0
 
digital_thoughtsCommented:
Were you able to get your issue corrected?
0
 
GD_GRAYAuthor Commented:
No, Ive even restarted the SQL server itself, and she still gets the same error. This is nuts.
0
 
JMorschCommented:
You could try clearing the system locks by running the query:

SELECT * from TempDB..DEX_SESSION where Session_ID not in (SELECT SQLSESID from DYNAMICS..ACTIVITY)
0
 
JMorschCommented:
sorry that query will allow you to see if there is something there that shouldn't be....  in a perfect setup that query would have 0 records to show

if you have some you can run:
DELETE TempDB..DEX_SESSION where Session_ID not in (SELECT SQLSESID from DYNAMICS..ACTIVITY)

to delete them
0
 
GD_GRAYAuthor Commented:
LoL, I still get the error... Thanks but Im going to accept this and close this ticket. Thank for your help.
0
 
GD_GRAYAuthor Commented:
the error is still here, but he was a big help
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now