Solved

Dynamics GP Login Error

Posted on 2007-11-14
11
2,138 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Introduction: Recently, I got a requirement to zip all files individually with batch file script in Windows OS. I don't know much about scripting, but I searched Google and found a lot of examples and websites to complete my task. Finally, I was ab…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 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

16 Experts available now in Live!

Get 1:1 Help Now