Skip to content


Help Articles

  Tuesday, August 1, 2017   /     Lorren Zemke
When trying to log into SmartConnect we receive an error stating, Login failed for user 'SmartConnect'. This may occur trying to log into SmartConnect, running a map, trying to start the SmartConnect Windows Service. Basically, the error could occur anywhere in SmartConnect. … [Read More]
  Thursday, December 8, 2011   /     Kevin
When trying to import notes into CRM using SmartConnect, you receive the following error: The entity with a name = '1' was not found in the MetadataCache.This occurs when the Object Type attribute is incorrectly mapped in the entity mapping screen. In CRM the Object Type is a picklist, but the… [Read More]
  Monday, June 18, 2018   /     Nicole Albertson
The SmartList Favorites SmartList Builder setup is designed to return a list of SmartList Favorites along with their save level. … [Read More]
  Friday, January 5, 2018   /     Nicole Albertson
The GL Trial Balance Summary by Year SmartList Builder setup is designed to return the Beginning Balance, Yearly Net Change, and Ending Balance for each account for each History and Open year.  This is data similar to the General Ledger Summary Trial Balance that can be printed in Microsoft… [Read More]
  Friday, July 14, 2017   /     David Youngquist
When logging into SmartConnect, receiving an error that says, "Your login failed.  Please contact your system administrator".   … [Read More]
  Wednesday, March 26, 2014   /     David Youngquist
Running a map with dollar amounts mapped to it.  For each transaction that tries to get imported, receiving an error that says "Failed to convert parameter value from a String to a Decimal".  The odd thing is if the transaction amounts are integers, the map runs.  It's only when decimal places… [Read More]
  Thursday, May 4, 2017   /     David Youngquist
Starting in Microsoft Dynamics GP 2013, there is a new option added to the SmartList window.  On a standard installation, pressing this button will open the Microsoft SmartList Designer product.  If you have SmartList Builder installed, pressing the button will open eOne SmartList Builder.   … [Read More]
  Thursday, May 26, 2016   /     Brady Swenson
Running a map using the WCF Webservice returns the error message "The Request failed with HTTP status 405: Method Not Allowed".Typically, this indicates an issue with the Real time and SmartList web service URL, which is found under the SmartConnect Dynamics GP Connector.To correct this issue, log… [Read More]
  Tuesday, March 28, 2017   /     David Youngquist
When launching SmartView internal, receiving an error that says "A network-related or instance-specific error occurred while establishing a connection to the SQL Server.  The server was not found or was not accessible.  Verify that the instance name is correct and that SQL Server is configured to… [Read More]
  Thursday, December 8, 2011   /     Kevin
How to write a case statement in a data source query using the Microsoft ODBC Text driver. The syntax for a case statement using the Microsoft ODBC Text driver is different than it would be in SQL. This is an example of a case statement: iif(F15='DropShip','1661','2684') as ACCT This is… [Read More]
  Monday, January 30, 2023   /     David Youngquist
When attempting to browse the SmartConnect WCF web service, the browser window reports an error that says "HTTP Error 500.19 - Internal Server Error" followed by an additional message that says "The requested page cannot be accessed because the related configuration data for the page is invalid." … [Read More]
  Friday, December 30, 2022   /     Patrick Roth
I'm running a integration and once in a while see this saysError: The client has been inactive since <date & time> and it has exceeded the inactivity timeout of 50000 ms.  Stopping the connection.[caption id="attachment_39719"… [Read More]
  Friday, December 16, 2022   /     Patrick Roth
My customer had been using SmartConnect 2018 and an ODBC query against an on-prem Microsoft CRM for a number of years and was working fine even after updating to SC 21.Recently, they moved to Microsoft CRM CE.  After enabling their Dataverse Tabular Data Stream (TDS) endpoint that emulates a SQL… [Read More]
  Monday, December 12, 2022   /     David Youngquist
After performing an upgrade of Extender, receiving an error when launching Dynamics GP that says, "Message #24574 is missing."All 18.X versions of Extender use a customer account code to register the product.   All the error message is indicating is that you have updated to a newer version and you… [Read More]
  Monday, December 12, 2022   /     David Youngquist
After performing an upgrade of SmartList Builder, receiving an error when launching Dynamics GP that says, "Your registered version of SmartList Builder does not match the installed version of SmartList Builder"All 18.X versions of SmartList Builder use a customer account code to register the… [Read More]
  Thursday, December 8, 2022   /     Nicole Albertson
Here are the steps to pay for a product renewal on eOne's website:  Go to and select the Sign In button at the top, right-hand side of the screen.Be sure that eOne Portal is marked and select Sign In.Enter your email and password and select Sign In.Select the My Account >… [Read More]
  Thursday, November 3, 2022   /     Maksudul Haq
The following steps are for creating integration:If you do not have SmartConnect Login. See the Getting Started with Click on Connections, then Create Connection button. You will see all applications connections available list. Here is the Print screen… [Read More]
  Wednesday, July 13, 2022   /     Patrick Roth
I am running a SmartConnect integration to Microsoft Dynamics GP that works correctly on all my machines except for one.  On the problem machine, when the integration runs, it fails with the error:Login failed for user 'eonedemo\EONE-2014$'.[caption id="attachment_38604" align="aligncenter"… [Read More]
  Friday, July 1, 2022   /     David Youngquist
Installing the 32 bit Excel Add-in for SmartConnect 21.  It appears to install successfully, however it does not show up in Excel, and there is not any way to add it.  If you are using a 64 bit operating system, but you have 32 bit Excel installed, there is an additional registry setting that… [Read More]
  Friday, July 1, 2022   /     David Youngquist
Using an Excel data source, and receiving an error that says "Connection could not be validated".  When clicking on Details, the message says "ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"If you are on SmartConnect 2018 or lower you need… [Read More]