Resolve Microsoft Dynamics GP Temp Table Errors
Try our expert suggestions for resolving temp table issues in Microsoft Dynamics GP
Some GP error messages can be extremely frustrating and difficult to diagnose. Particularly, errors that mention a “temp” file. These errors are listed below:
- An open operation on table ‘ASI_Explorer_Favorites’ failed because the path does not exist.
- An open operation on table ‘coPeriodCache’ failed because the path does not exist.
- An open operation on table ‘CM_TrxHist_Temp’ failed because the path does not exist.
The table on which the error occurs can differ and the above are just a few examples that we have seen. The error usually takes the form of “An open operation on table ‘____’ failed because the path does not exist.
What this boils down to is an issue with the TEMP folder on the workstation where the client is installed. The issue has been well documented in various places, and there are multiple suggestions. I will combine as much of that information here so that you can troubleshoot from one place.
David Musgrave’s blog has a couple of posts on this error. The links are below:
- Unexplained Temp Table Errors | David Musgrave’s Winthrop Development Consultants Blog (wordpress.com)
- An open operation on table ‘[TEMP Table]’ errors | David Musgrave’s Winthrop Development Consultants Blog (wordpress.com)
The key takeaway from these blog posts is that antivirus can interfere with the temp files that the Dynamics GP application creates during normal use. The fix here is to add the following exclusions to your AV scans:
If this does not resolve the issue, Microsoft has a KB article that discusses a related error message. There are additional directories that should be excluded from the AV Scans. You can find that article here: FP cannot close table – Dynamics GP | Microsoft Learn. This error message can also indicate a connection between the server and the client being dropped, which will be discussed in a later blog.
Other things to check when this error occurs include:
- %TEMP% environment variable is set on all servers
- %TEMP% environment variable is not pointing to an invalid path on all servers
- %TEMP% path has full control access for the users on all servers
- %TEMP% path drive is not running out of space
- %TEMP% path contents are not being deleted by some sort of cleanup process.
- Run a repair on the Dynamics GP installation
- Rebuild the custom forms and reports dictionary
If you have additional questions about Dynamics GP or other Microsoft products, fill out the form below. Also, check out our GP Enhancement package and AP Automation for GP!