dynamics GP10; Stored procedure returned createtmptable DBMS: 17
One of our users is getting this on a regular basis while drilling down in smartlists. I suspect it is a network issue if it is, is there a way to improve the ability of the app to create the table it needs?
* change DNS entries?
*This post is locked for comments
I'll have to try the procedure below when I catch this issue again.
Note, the link I clicked marked this as verified but I have not yet verified it though I'm certain Vinutha's answer will work in most issues dealing with lock and conflict issues.
Hi Ralph,
Typically DBMS 17 errors are temp table related which involves the tempdb database. Based on the error messages being received, it is possible that there are locked records that are currently stuck in the temp tables causing the system to give you errors.
To deal with this, please do the following:
1. Create a backup of your company database.
2. Have all users log out of Dynamics GP.
3. Stop and start the SQL Server to clear the temp tables.
4. Run the following scripts in SQL Management Studio to clear all stuck processes:
use DYNAMICS
delete SY00800
delete SY00801
delete ACTIVITY
use TEMPDB
delete DEX_LOCK
delete DEX_SESSION
5. Check if the issue still persists.
Regards,
Vinutha
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (