Solved

Dynamics GP Login Error

Posted on 2007-11-14
11
2,149 Views
Last Modified: 2010-05-18
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
Comment
Question by:GD_GRAY
  • 5
  • 4
  • 2
11 Comments
 
LVL 8

Expert Comment

by:digital_thoughts
ID: 20282702
You could try stopping and restarting the SQL Server service(s).
0
 

Author Comment

by:GD_GRAY
ID: 20282778
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
 
LVL 8

Expert Comment

by:digital_thoughts
ID: 20284495
In SQL Server 2005 you can take a database offline, then back online, that might work.
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Author Comment

by:GD_GRAY
ID: 20289149
Can I do it in 2000 ? Thats what I run
0
 
LVL 8

Expert Comment

by:digital_thoughts
ID: 20289275
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
 
LVL 8

Expert Comment

by:digital_thoughts
ID: 20319928
Were you able to get your issue corrected?
0
 

Author Comment

by:GD_GRAY
ID: 20321818
No, Ive even restarted the SQL server itself, and she still gets the same error. This is nuts.
0
 
LVL 3

Expert Comment

by:JMorsch
ID: 20358396
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
 
LVL 3

Accepted Solution

by:
JMorsch earned 500 total points
ID: 20358410
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
 

Author Comment

by:GD_GRAY
ID: 20367120
LoL, I still get the error... Thanks but Im going to accept this and close this ticket. Thank for your help.
0
 

Author Closing Comment

by:GD_GRAY
ID: 31409211
the error is still here, but he was a big help
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now