Skip to main content

Notifications

Announcements

No record found.

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 492

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:
  • 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

  • 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

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…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,768 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans