Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Dynamics GP Login Error

Posted on 2007-11-14
11
Medium Priority
?
2,248 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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 1500 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Loops Section Overview
Suggested Courses

610 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