Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Open operation on tabl...
Microsoft Dynamics GP (Archived)

Open operation on table failed because path does not exist

(0) ShareShare
ReportReport
Posted on by Jackie McNab 212

On of my Users is unable to use the Employee Maintenance screen and gets this message when she attempts to do so.

An open operation on table 'ASI_Explorer_Favorites' failed because the path does not exist. 

She reported that when she last used the system she was in the middle of working when there was a disruption in the power supply and her machine went dead so this could be as a result of the power interruption. 

i hope someone has had this issue and can advise me how to address it.  I have searched but found nothing helpful.

Regards,

Jackie

*This post is locked for comments

  • Suggested answer
    Kerwin Octavo Profile Picture
    Kerwin Octavo 12 on at
    RE: Open operation on table failed because path does not exist

    I know this is an old thread, but had this issue come up today. Closing GP and reopening it and then logging in as SA did not resolve the error.

    What fixed it was logging out of the machine entirely and then logging back in. My guess is there are temp files/folders in the user's directory that can cause this issue. Closing GP does not remove those but logging out will clear them out.

    Hope this info saves you maybe some time by not having to reboot

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,965 Most Valuable Professional on at
    RE: Open operation on table failed because path does not exist

    The tables for which the errors are occurring are all memory or local temporary tables which are stored as files in the workstation's local temp folder.

    If the temp folder is not defined correctly, does not exist, does not have write access, has a full drive or is being blocked by antivirus software, it causes these issues.

    Please see these articles from 2009 and 2010:

    winthropdc.wordpress.com/.../

    winthropdc.wordpress.com/.../

    Regards

    David

  • Nick557 Profile Picture
    Nick557 5 on at
    RE: Open operation on table failed because path does not exist

    We have been getting this as well. Hypervisor VM, GP 2016, SQL Server 2014. The VM is being accessed through VMware Horizon. Rebooting the VM fixes the error, but it is recurring.

    The error also occurs on user's physical workstations after any interruption in network connectivity, even when changing from a wired connection to Wi-Fi. This doesn't require a system reboot, only closing and reopening GP.

  • steveendow Profile Picture
    steveendow 2,281 on at
    RE: Open operation on table failed because path does not exist

    I just had this on a Hyper-V VM running GP 18.4 and SQL Server 2019. 

    The errors occurred when trying to login with sa.  Closing and relaunching GP did not seem to help.

    I rebooted the VM and the errors went away.

    An open operation on table 'WCD_Field_Security_Tag_TEMP' failed because the path does not exist

    pastedimage1641406327261v1.png

    An open operation on table 'ASI_Explorer_Favorites' failed because the path does not exist

    pastedimage1641406352768v2.png

  • STran Profile Picture
    STran 70 on at
    RE: Open operation on table failed because path does not exist

    We got the exact same error.  We had already attempted the recommended steps mentioned above.  It came back after a few months.  The user was looking up a vendor ID and came across this error.  We are on version 2015.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Open operation on table failed because path does not exist

    Glad it worked. Was this a new client installation?  Our client had just gone through a GP 2015 to GP 2018 upgrade and it was not until they started their daily routines that they noticed this. I can only assume some table had the old server name in it and the 'sa' account had the rights to update that table.

  • Verified answer
    Jackie McNab Profile Picture
    Jackie McNab 212 on at
    RE: Open operation on table failed because path does not exist

    Thank you Richard E Wheeler. 

    Your second option, login as sa and then have the user login after worked.  Everything is back to normal for her.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Open operation on table failed because path does not exist

    I just had one of these with one of my clients this morning. The first thing I tried was running the command prompt and typing in %temp%. Then delete all the files you find in the user's temp folder. When that did not work I logged in as 'sa' and went to the exact same screen our user was on and it worked. I then had the user login as themselves and all returned to normal.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans