Thursday, December 16, 2010

An open operation on table XXX failed because path does not exist

Who hasn't come across this error? If you have been long enough in the Microsoft Dynamics GP world, you will probably even have a prescribed set of steps to address this issue:

  1. Restart the SQL Server service to clear all tempdb database tables from memory
  2. Clear out the local temp folder
  3. Making sure the temp folder actually exists
  4. Making sure the %TEMP% environment variable exists
  5. Making sure your anti-virus software is not placing some sort of restriction on the folder

And then some more...

Just recently I ran across this issue with Microsoft Dynamics GP 2010 and I thought, how bad can this be? I started by walking through the prescribed steps as mentioned above, but still could not resolve the issue. I also remembered that my friend Allan Cahill over at Developing for Dynamics GP had blogged about this in his article Unexplained Temp Table Errors so I went checking his findings. In his case the issue had to do with the Anti-virus software interfering with the temp directory during scanning for viruses. So, we did the same at the client with no positive outcome.

I then remembered that my also friend David Musgrave had written a more recent article on the issue and in his article he detailed that the same issues could occur if the user lacked write permissions to the folder specified by the %TEMP% environment variable. I went inquiring with the client's IT department and it turned out they had just rolled out some new Group Policies which inadvertly disabled access to the %TEMP% folder.

The client proceeded to make the necessary adjustments via Group Policy and had all users reboot their computers. Now Microsoft Dynamics GP was happy! No more errors! It's amazing how complex things have become since my first days with v3.15 and Windows 95. There's sure much more involved today and much more to look out for. If you don't believe me, read my last month's article Microsoft Dynamics GP - More than just Program Files!


Following this post, I will also publish an issue that we found as a result of the permissions issue on the %TEMP% folder.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

2 comments:

Nancy said...

Hi Mariano,

Do these steps apply in a Citrix environment? GP users access through Citrix. Only one user is receiving these type of temp table errors when attempting an ADP import. Do we need to recreate their profile OR is it a permissions issue to the temp files in Citrix?

Thanks.

Mariano Gomez said...

Nancy,
Yes, they do. I have other articles explaining issues you may run into if using roaming profiles on Citrix or TS and how to overcome. I wrote those either this month or last month. Check them out.

MG.-
Mariano Gomez, MVP