Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: The Extender Window ‘MY_EXTENDER_ WINDOW’ Does Not Exist in the Destination Company


The user is in SmartConnect and is using any Microsoft Dynamics GP destination.

It is desired to add a node for an Extender window that was created.

In the Destination, when I press the “Add Extender Object” button to add my Extender Window (See below):

 
Figure 1: Use Add Extender Object to select Extender Window

We can see that SmartConnect recognizes my Extender Window (it sees them all in the lookup).

 
Figure 2: CUSTOMER_DETAIL Extender window selected

After saving the Extender window, it now shows correctly in my SmartConnect map.


Figure 3: New Extender node successfully added

At this point, everything is working correctly as I go to add my mapping to the Extender node by double clicking or selecting the highlighted line and pressing the “Map” button.

This fails with the error:

The Extender window ‘CUSTOMER_DETAIL’ does not exist in the destination company.

This is puzzling since we were just able to see the Extender window in the lookup. We also note that the SmartConnect Mapping window does open – however we do not have any fields to map to (which is another symptom/clue to the issue).
 

Figure 4: Mapping window open but no fields displayed

The next step is to see if we are getting any errors when SC is reading in SQL.

Running a SQL trace using the SQL Server Profiler, does tell us the issue.


Figure 5: Profiler Trace Results

To get a list of the fields for the Extender window, SmartConnect calls the stored procedure “ExtenderGetWindowFields”.

According to the error message:

Could not find stored procedure ‘TWO.dbo.ExtenderGetWindowFields’

Because the stored procedure does not exist in this database, the call fails and therefore doesn’t return a record set with the field names. SmartConnect interprets this as “the window doesn’t exist” and so gives the initial message.

The other possibility is that we could get a “permission denied” error here. Because SmartConnect runs under the user credentials as set up in the GP Connector (either Windows auth or a specific SQL Server User), it is possible that user doesn’t have permissions to the procedure.

So in my case, the proc doesn’t exist – but why doesn’t the proc exist?

Either it was deleted or never got created in the first place. 

For a missing proc, the easiest solution is to run Maintenance in SmartConnect. If it was a permissions error, you could change your permissions in SQL by running the Microsoft grant.sql script or change the user context that SmartConnect is running under in the GP Connector Setup.

Go to Setup -> System Maintenance and press the “Process” button to start the maintenance process. This will set up all the defaults and create or recreate all the missing procedures.


Figure 6: System Maintenance running

Once this is finished and the procedure has been created, we were able to map the Extender window fields as expected.

Regards,
Patrick Roth
eOne Solutions


Interested in learning more about SmartConnect & Extender? Email our sales team at sales@eonesolutions.com and we would be happy to assist you!

Leave a Comment





RECENT POSTS


2021 Q4 Promotions
Connect with us at Directions EMEA 2021 in Milan!
eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.