SBX - Search With Button

SBX - Forum Post Title

Can't open SmartList in GP 2013R2 - getting unhandled script exception

Microsoft Dynamics GP Forum

Rob Klaproth asked a question on 9 Jun 2014 11:53 AM
My Badges

Question Status

Suggested Answer

When opening SmartList, we get Unhandled Script Exception:

Index 0 of local array is out of range in script

'ASI_Initialize_Explorer_Tree'. Script terminated.

If I click OK, i get into SmartList, but it won't load any of the SmartLists, not even the default ones.

We have SmartList Builder, both the microsoft one, and the eOne installed.

When I run a DEXSQL trace, I don't see much related to that, but I am seeing a:

Cannot find stored procedure 'DYNAMICS.dbo.zDP_SY30000F_1'

It looks like SY30000 is a new table in 2013R2, so I'm guessing this must be R2 related.

Reply

I believe this needs further more debugging, this is just to include that the SY30000 is a new table in GP 2013 R2, You may start from here.

I recommend troubleshooting this on the SQL Profiler level, as I suspect that some stored procedures might be missing. Running the GP utilities may get things on track again.

One more advice, back up is always a must.

Your feedback is highly appreciated,

Reply
Rob Klaproth responded on 9 Jun 2014 4:07 PM
My Badges

Hi Mahmoud, the dex traces didn't turn up much, none of the Sprocs referenced in the dex trace are missing, I ran the entire trade in SSMS and it runs without any errors.  

I've logged a case with Microsoft.  

Reply

Would be highly appreciated if you keep us updated

Your feedback is highly appreciated,

Reply
Tom Mathew responded on 9 Jun 2014 10:59 PM
My Badges

Try running the SQL maintenance for the smart list on with only the stored procedures option checked along with the recompile option.

Please keep a backup of the databases before doing this process

Reply
Pam Robertson responded on 10 Mar 2015 11:00 AM
My Badges

Rob, did you ever figure this out?  We have a customer who is getting  a short dexsql.log generated regularly since installing an update to Smartlist Builder with basically just the same message: Cannot find stored procedure 'DYNAMICS.dbo.zDP_SY30000F_1'.  Everything seems to be running properly related to GP and Smartlist. 

Reply
Leslie Vail responded on 15 Mar 2015 8:49 PM
My Badges
Suggested Answer

Hi Rob,

I just had this error and here's what I did to solve it. My problem was a difference between the ASIEXP81 and the ADH00100. It came about because of the new SmartList Designer feature. I added the missing records to the ADH00100 table and the problem was solved. Here's how it looked:

SELECT DISTINCT asiexp81.asi_favorite_dict_id

               , asiexp81.asi_favorite_type

FROM   asiexp81

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)  

The results of the query above told me I was missing the two items below. I ran the Insert statement to populate the ADH00100 table. For me, it fixed it.

begin transaction

insert into DYNAMICS..ADH00100 values ('0',  '498','3',  'Requisition Line Items','sa','-1')

insert into DYNAMICS..ADH00100 values ('0',  '499','3',  'Purchase Requisitions','sa','-1')

--commit transaction

Kind regards,

Leslie

Reply
Leslie Vail responded on 15 Mar 2015 8:49 PM
My Badges
Suggested Answer

Hi Rob,

I just had this error and here's what I did to solve it. My problem was a difference between the ASIEXP81 and the ADH00100. It came about because of the new SmartList Designer feature. I added the missing records to the ADH00100 table and the problem was solved. Here's how it looked:

SELECT DISTINCT asiexp81.asi_favorite_dict_id

               , asiexp81.asi_favorite_type

FROM   asiexp81

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)  

The results of the query above told me I was missing the two items below. I ran the Insert statement to populate the ADH00100 table. For me, it fixed it.

begin transaction

insert into DYNAMICS..ADH00100 values ('0',  '498','3',  'Requisition Line Items','sa','-1')

insert into DYNAMICS..ADH00100 values ('0',  '499','3',  'Purchase Requisitions','sa','-1')

--commit transaction

Kind regards,

Leslie

Reply

SBX - Two Col Forum

SBX - Migrated JS