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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Smartlist Error

(0) ShareShare
ReportReport
Posted on by 36

Good Morning,

We are receiving this error message in GP when trying to use the Smartlist function, any ideas?

2235.GP.jpg

 

Thanks

Rob

Categories:
I have the same question (0)
  • robmag Profile Picture
    36 on at

    Here's some steps we tried:

    It almost seems like there is a duplicate favorite since I can see that the entries in the dexsql.log that are erroring are in the SQL table but what is trying to get input has a higher field sequence number.  Example this entry errored

    BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP86SI 0, 6, 0, 0, '', '', '', 11, 1, 1, 5147, 22001, 'Company', 0, @num OUT SELECT @num END

    The number 11 is the ASI_Field_Sequence.  But there is  the same exact entry is already in the table but with a field sequence number of 10. 

    This is just one type of error.  There are other tables that give a different error

  • Verified answer
    Derek Albaugh Profile Picture
    on at

    I've seen a '"Index 0 of local array" error launching Smartlist due to mismatches between the ASIEXP81, ADH00100 and ADH00101 but not so much Index 99.

    The first question I'd have is whether you have SmartList Builder from eOne installed and if so, whether you are on Dynamics GP 2018 as this forum indicates?

     If you are, on one of the machines where Dynamics GP is installed and showing this error, have all users log out of Dynamics GP, then rename the GP directory from something like C:\Program Files (x86)\Microsoft Dynamics\GP\ to C:\Program Files (x86)\Microsoft Dynamics\GP_OLD\.

    2. From there, in Control Panel > Programs and Features, right-click on Dynamics GP, choose 'Change' and then select the 'Repair' option when prompted with the options window. Verify the Repair process runs successfully. Its run successfully

      Repair will re-create the entire GP directory under the original name, minus modified forms/reports dictionary files, third party products, customizations, etc.

    3. Login to this 'new' Dynamics GP directory as 'sa' and see if you now recreate this 'Index 99 of local array' error message or not.

       --if not, then we'd want to add back third party products and customizations, if any, one by one, testing after each one till the error returns. I'd start with SmartList Builder, if applicable.

      --if not, generate a dexsql.log from this 'new' GP directory and re-create the SmartList error message.  At that point, we'd probably want a support case opened to troubleshoot further.

    Thanks

  • Suggested answer
    Derek Albaugh Profile Picture
    on at

    Update on this......

    Via a support case with the same exact error, we found working with eOne (at least in that case) that the issue was that a user had taken one of the default SmartLists and clicked 'Modify' and it somehow put it in the 99 series, which is for SmartLists, under the 'Additional SmartList' folder.

    Changing the series number back to 1, the SmartLists were then able to be opened.

    When SmartList Builder was removed/uninstalled, the error didn't show, so working with eOne, the customer resolved by finding the above.

    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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans