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 :
Finance | Project Operations, Human Resources, ...
Suggested answer

Smartlist - ASI_MSTR_Explorer_Favorites

(0) ShareShare
ReportReport
Posted on by 879

I am working on a test upgrade form GP2016R2 to GP18.3.  I am able to get the upgrade to process successfully, however I am having some issues on the back end.

When I log into the upgraded system I am getting a SmartList initialization error:

pastedimage1653672340706v1.png

That is follows by a Get/Change error on ASI_MSTR_Explorer_Favorites

pastedimage1653672385535v2.png

To remedy, I've tried the following:

1)  Reprocessed the upgrade

2)  Re-ran the Grant script against the company and Dynamics databases

3)  Backed up and recreated the ASI_MSTR_Explorer_Favorites table ASIEXP81

I starting to run out of options and the MIcrosoft Support Hub is currently not functioning.  Any suggestions as to how to resolve?

Please advise.  Thank you.

JG

Categories:
I have the same question (0)
  • Max854 Profile Picture
    25 on at
    RE: Smartlist - ASI_MSTR_Explorer_Favorites

    Did you have a fix on this issue? Challenging a relative issue yet no response from anyone and couldn't see this point taking a gander at in google.

    Myhdfs Account Login

  • Suggested answer
    Derek Albaugh Profile Picture
    on at
    RE: Smartlist - ASI_MSTR_Explorer_Favorites

    Usually when we see this type of message, either the dictionary files are not synched with the account framework that Dynamics GP is setup to have, so it's expecting something like our defaults, which is 5 segments each with a length of 9 and will throw this type of error if it sees anything different.

    The other cause of this type of error is the ASIEXP81 table is not setup correctly for how the account framework maximums are specified, for Dynamics GP.

    To verify both of these, please do the following:

    1. Have all users log out of Dynamics GP and make sure the ACTIVITY system table is empty.

    2. In the Dex.ini for GP, set the SYNCHRONIZE= line to TRUE, then save and close the file.

    3. Launch GP Utilities as 'sa' and it should synch the Dynamics.dic file. Once it reaches the 'Additional Tasks' window again, close GP Utilities.

    4. Open the Dex.ini again for GP and verify the SYNCHRONIZE= line now shows FALSE or not. If it doesn't, that is usually indicative that the Dynamics.dic file was not synched correctly, and we have other steps for that....

      If the SYNCHRONIZE= line is set to FALSE, close the Dex.ini file and launch Dynamics GP as 'sa' and see if you can now get into SmartList and have the reports show, as well as data show, or if the SmartList message still shows with no reports once you click OK past it.

    If the synchronization goes through but the SmartList window is still not showing anything, we'd probably need a support case opened, as we'd need you to run the following scripts against the DYNAMICS system database and send us all the results to verify the structure of the ASIEXP81 table, whether it is correct or not:

    a. Select * from SY003001

    b. Select * from SY00302

    c. sp_help ASIEXP81

    Thanks

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

Responsible AI policies

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

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 734 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 636

#3
Martin Dráb Profile Picture

Martin Dráb 553 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans