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: Restart the SQL Server service to clear all tempdb database tables from memory Clear out the local temp folder Making sure the temp folder actually exists Making sure the %TEMP% environment variable exists 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
Go here to read the rest:
An open operation on table XXX failed because path does not exist