Microsoft Dynamics GP (Archived)

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

(0) Share

Report

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

I have the same question (0)

All responses (48)

Answers (1)

Amit Thakkar on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

yayayayaay 145 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Dedi Hermawan 295 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Enrique Velazquez on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rob Klaproth 1,730 on at

Like (0)

Report

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. :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Derek Albaugh on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Rob Klaproth 1,730 on at

Like (0)

Report

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!

Was this reply helpful? Yes No