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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SmartList Error: Wrong number of parameters sent to script 'Explorer_Get_SQL_Join_Info'.

(0) ShareShare
ReportReport
Posted on by

Hi, all

I'm getting a weird error on the Inventory->Items->default SmartList (*): 

Unhandled script exception:
Wrong number of parameters sent to script 'Explorer_Get_SQL_Join_Info'.

This is on GP2016. We have Extender in use, with some SmartList integration.

Other (non-default) Item SmartLists are fine - so I figure this is something to do with the default SmartList settings. I looked in Adminsitration->System->SmartList Options, but everything looks OK.

We have several GP companies, and it's the same in all of them - again, pointing to something in DYNAMICS that's not right.

This *may* relate to an upgrade we did a few months back, from GP10 (yes, GP10) to GP2016. The transition for Extender was less-than-smooth, and there may be some garbage hanging about in a table somewhere. I'm suspecting that this may be Extender-related, but I don't really have any evidence that this is the case.

Any clues as to where I should be looking?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    No responses to this? Anyone from Microsoft on here who might have a clue?

  • MG-16101311-0 Profile Picture
    26,225 on at

    I know this is going to sound weird. Do you by any chance have a forms dictionary for SmartList or Extender? If so, rename both of them. Check your DYNAMICS.SET file to see the name of both the SmartList and Extender forms dictionaries and their location.

  • Community Member Profile Picture
    on at

    Thanks, Mariano - I did indeed have an EXP1493F.DIC and a UDFORM.DIC, and tried renaming these. Same error though.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans