Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP10- Upgrade from GP9 Smartlist error on load

Posted on by 537

 Hello everyone,

 I recently upgraded a GP9 installation to GP10 in a test environment. When I first start GP I get the message:
To use the Smartlist capability in this product, the smartlist tables must be built. This is a one-time initialization process and may take a few minutes. do you want to proceed with the initializtion now? I hit yes and in a few seconds I get the message:

A get/change first operation on table 'ASI_MSTR_Explorer_Favorites' failed
accessing SQL data.

More info says:
Number of resultes columns doesnt match table definition.

When I go to any screen and do a lookup I get the same message:
A get/change first operation on table 'ASI_MSTR_Explorer_Favorites' failed
accessing SQL data.

Has this happened to anyone else? The related KB article (898475) offers no working solution to my case.

 Thank you!
Nelson A.

*This post is locked for comments

  • Nelsona Profile Picture
    Nelsona 537 on at
    Re: Re: GP10- Upgrade from GP9 Smartlist error on load

    Hello Richard, thanks for replying. I upgraded from 9.00.281 to 10.00.1411

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: GP10- Upgrade from GP9 Smartlist error on load

    Are you sure you followed all of the most current upgrade instructions?  I seem to remember this in the early upgrades that a table got missed.  GP then sent out a patch to the process.

    What service pack were you on in 9 and which service pack of 10 did you upgrade to?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans