Skip to content


Help Articles

  Friday, January 26, 2018   /     Nicole Albertson
This error may be caused by the Transport Layer Security  (TLS) version 1.2  being the only enabled version on the SmartConnect Server.  TLS 1.2 support for Microsoft SQL Server If you are using TLS 1.2 on your server that runs SmartConnect with TLS 1.0 and 1.1 turned off, the OLEDB Connection… [Read More]
  Monday, November 26, 2018   /     Ethan Sorenson
What is FIPS?Windows has a setting that prevents applications on the machine from using encryption that are not compliant with Federal Information Processing Standards(FIPS). This setting is typically only needed for servers that contain government data. Here is a good article about FIPS and why it… [Read More]
  Thursday, December 8, 2011   /     Kevin
Opening an Excel template provided from eOne. A message box saying that "Excel found unreadable content in '<ExcelFileName>.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes. After clicking yes, one of the following error… [Read More]
  Thursday, December 8, 2011   /     Kevin
When running a SmartConnect map, you receive an error for each document that says "The server process could not be started because the configured identity is incorrect. Check the username and password.This means that the eConnect username and password is incorrect, or that the password has expired. … [Read More]
  Tuesday, April 18, 2017   /     Lorren Zemke
In and SmartConnect 21 or newer, a native FTP connector is included. Instructions for the connector can be found in this article. … [Read More]
  Thursday, June 4, 2015   /     Nicole Albertson
Action Name: … [Read More]
  Tuesday, June 14, 2016   /     Nicole Albertson
The Manufacturing Serial Trace SmartList Builder setup is built to give you a list of the serial lot information for orders in the Manufacturing series.  The setups for Excel Report Builder and Navigation List Builder are duplicates of the SmartList Builder setup.ID: MFG_SERIALName:… [Read More]
  Monday, February 25, 2019   /     Patrick Roth
The user is running a SmartConnect integration to Dynamics GP.On one machine, the integration fails with the error:Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or… [Read More]
  Wednesday, January 29, 2014   /     David Youngquist
When browsing to the SmartConnectWCF web service, receiving an error that says "Memory gates checking failed because the free memory (373817344 bytes) is less than 5% of total memory. As a result, the service will not be available for incoming requests."In order to resolve this, you need to edit the… [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]
  Friday, March 17, 2023   /     Patrick Roth
The user has a map that used a Business Central Query using a filter on the query.Because the filter should be dynamic - a user defined global variable, GBL_LASTDATEMODIFIED, was used and initially set as 2023-02-01. … [Read More]
  Monday, March 13, 2023   /     Patrick Roth
I'm using SmartConnect 21 and trying to connect to an Excel source file map and running into this error:An error occurred retrieving the Excel file sheets: Archive file cannot be size 0.I've also seen the same error one other time when the user trying to pull up an existing map where the data source… [Read More]
  Monday, February 27, 2023   /     David Youngquist
These downloads are provided only for adding new SmartConnect clients to already existing installations of SmartConnect.   Any new installations should be using the current version of SmartConnect which you can download on our SmartConnect Downloads pageSmartConnect 9 ( 10… [Read More]
  Monday, February 27, 2023   /     Madalynn Woolery
Here are the steps to update the email address for an automatic payment. 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… [Read More]
  Monday, February 27, 2023   /     Madalynn Woolery
Here are the steps to purchase or create a quote for SmartConnect from 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… [Read More]
  Monday, February 6, 2023   /     Patrick Roth
I am in the SmartConnecty 21 GP Change Data Source window to create a new GP Change Data Source.After giving the new data source a new and selecting my GP Instance, I press the Product lookup button and receive the error:No Products were found in this instance of Great Plains. Please run the… [Read More]
  Friday, February 3, 2023   /     David Youngquist
Using a map with either a text or csv file, when I preview the map I see extra characters at the beginning of the first column name.   If I open the file it looks completely normal with no extra characters. Here is my preview from SmartConnect:However this is my file when I open it in Notepad,… [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]