web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Help - SmartList Launc...
Microsoft Dynamics GP (Archived)

Help - SmartList Launch Error

(0) ShareShare
ReportReport
Posted on by Mohammed Vayalil 150

We have two users having issues opening smart list, they are getting the following error messages. I am afraid this disease is spreading.

  • A save operation on table 'ASI_Explorer_Favorites' has caused an unknown error(38)
  • An open operation on table 'ASI_SQL_Query_Fields' failed because the path does not exist

ASI1.PNG

ASI2.png

I couldn't reproduce the user's cloned account.

Upon further googling, it seems like this fields belong to table ASIEXP96 which I can't find  in our upgraded system. I searched google; dead end on this. Any help is appreciated.

Thanks for looking and happy holidays!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Help - SmartList Launch Error

    Hello Mohammed,

    If you capture this error in a dexsql.log, do you see any mentions of "FP: Couldn't Close Table" or anything about the SQL connection being dropped?

    Normally, when we see this type of error intermittently, it has to do with the SQL connection being dropped between SQL and Dynamics GP, thus the error.

    This may also explain why you can't reproduce this error on the user's cloned account as the connection issue isn't specific to any user account, but may be machine specific.......can you re-create or see this error on more than one machine?

    Thanks

  • Mohammed Vayalil Profile Picture
    Mohammed Vayalil 150 on at
    RE: Help - SmartList Launch Error

    Thanks Jothikrishnan.

    We recently upgraded, I will do the same for all the Smartlist and will update status here.

  • Suggested answer
    Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,881 on at
    RE: Help - SmartList Launch Error

    if you have the Smartlist Builder installed, open the smartlist which has issues by selecting the Smartlist type "Existing", and save.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans