stored procedure createTmpTable returned dbms 17

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

Re: stored procedure createTmpTable returned dbms 17

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.
Verified answer

Vinutha Holla 705 on at

Like (0)

Report

Re: stored procedure createTmpTable returned dbms 17

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