Solved

Dynamics GP Login Error

Posted on 2007-11-14
11
2,198 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Using dates in 'DOS' batch files has always been tricky as it has no built in ways of extracting date information.  There are many tricks using string manipulation to pull out parts of the %date% variable or output of the date /t command but these r…
VALIDATING DATES One method of validating dates is to jam the date into the DATE command and see if it accepts it by examining the system's errorlevel value. A non-zero result indicates failure. A typical example might look something like the fol…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

691 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