Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Index 0 of local array...
Microsoft Dynamics GP (Archived)

Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

(0) ShareShare
ReportReport
Posted on by pinopell

I just migrated to GP V 2013. When opening SmartList I ge this errer

Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

None of the sub-folders expands to list the smart list reports.

Any Help ?

Thanks

*This post is locked for comments

  • Amit Thakkar Profile Picture
    Amit Thakkar on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    First find out which record is missing with this SQL query.

    SELECT distinct A.ASI_Favorite_Dict_ID, A.ASI_Favorite_Type FROM ASIEXP81 A WHERE ASI_Favorite_Type between 498 and 22000  and NOT EXISTS (SELECT ASI_Favorite_Dict_ID, ASI_Favorite_Type FROM ADH00100 WHERE ASI_Favorite_Dict_ID = A.ASI_Favorite_Dict_ID and ASI_Favorite_Type = A.ASI_Favorite_Type )

    Once you found missing records than insert into ADH00100 table with appropriate  ASI_Favorite type.

    Post inserting records on ADH00100 table launch Smart list and your error will be disappear.

    Thanks

    Amit

  • Suggested answer
    yayayayaay Profile Picture
    yayayayaay 145 on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    pastedimage1574891985319v1.png

    If you have the same issue in GP2016, update ADH00100 with the above values

  • Dedi Hermawan Profile Picture
    Dedi Hermawan 295 on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    I have the same case and solving

    here is my simuation i write on my blogs

    wordpress.com/.../898

  • Community Member Profile Picture
    Community Member on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    I also deleted the records.  This is the only way I could get it to work.  What does this affect?  Should I put them back?

  • Enrique Velazquez Profile Picture
    Enrique Velazquez on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    It worked for me.Thanks a lot

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    OOPS.   I forgot all about this issue, and had a client today on 2013R2, and I ran clear companies to get rid of an old test company, and it wiped out the 2 ADH records, and broke Smartlist for everyone. :(  I guess I need to make sure I update the script library on their server with the new script. :)

  • Community Member Profile Picture
    Community Member on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    I just migrated to GP V 2015. When opening SmartList I get this error

    Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    None of the sub-folders expands to list the smart list reports.

    Any Help ?

    Thanks

    I get this result for the ADH00100 table query:

    ASI_Favorite_Dict_ID ASI_Favorite_Type
    0 498
    0 499
    232 22000

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    Hi Jonathan,

    This one works to me! Thank Jonathan. Thank you everyone.

    Shah.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    Rob,

    It's actually more an issue when running the ClearCompanies script. The reason being is that in the ADH00100 table, this script removes records for the new Workflow 2.0 functionality that should be there, whether it is used or not.

    Because these records are removed from the ADH00100 but not the other corresponding tables, it causes the issues such as the error being seen when attempting to access SmartList and SmartList not working once you get into that window.

    The 'fix' is a new release of the ClearCompanies script which ignores the ADH00100 table.

    Thanks,

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at
    RE: Index 0 of local array is out of range in script 'ASI_Initialize_Explorer_Tree'. Script terminated

    Jonathan, for all of my clients who have had this error message, NONE of them were using SmartList Designer, they were all new upgrades from 10.0 or 2010 to 2013R2, so they didn't even have the designer available to them.

    I just did another 2010 to R2 upgrade this past week, they had 37 companies, and they did NOT have the issue, but they also did not have SmartList Builder, I think it has something to do with SmartList Builder and not designer, but I would want to see what others who are seeing this error say.

    Is Microsoft planning on fixing this in the next service pack (the year end update)?

    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

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…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans