Skip to content
+1-888-319-3663

HELP ARTICLES

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 SmartConnect.com 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]
  Thursday, January 21, 2021   /     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]
  Wednesday, June 2, 2021   /     Ethan Sorenson
When reading a REST API is common for custom fields and metadata related to a record be stored in an array. This creates a problem for SmartConnect because it parses each entry in the array as a separate line in your source. With the new source column type “ValueArray” we can now manually define… [Read More]
  Monday, April 19, 2021   /     Patrick Roth
I have created a SmartConnect email task and entered in multiple email addresses.  I have the same valid addresses on other email tasks that work fine however on this map task, SmartConnect throws the error:An invalid character was found in the email header: ','The issue is the format of the email… [Read More]
  Friday, April 2, 2021   /     David Youngquist
How can I use SmartConnect to import SOP Transactions with Avalara Avatax?SmartConnect utilizes Microsoft's eConnect procedures to import data into Dynamics GP.   According to this article on the Avalara website, "Using eConnect or another solution to import sales documents to Dynamics GP and… [Read More]
  Wednesday, March 31, 2021   /     Ethan Sorenson
ErrorWhen launching the SmartConnect client received the below message:Could not log into the SQL Servercould not initialize a collection: [eOne.SmartConnect.Engine.User.UserWebFormOptions#6c6113ce-075b-4d49-8ec1-9ea400bb6db8][SQL: SELECT userwebfor0_.UserId as UserId1_,… [Read More]
  Friday, February 5, 2021   /     David Youngquist
When opening a SmartConnect map that uses an Excel datasource, receiving an error that says this:ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x514 Thread 0x1d4c DBC 0xc1c85f4 Excel'.ERROR [01S00] [Microsoft][ODBC… [Read More]
  Thursday, January 21, 2021   /     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]
  Tuesday, January 5, 2021   /     Ethan Sorenson
ErrorA user in Business Central is receiving the error:You do not have the following permissions on TableData eOneChangeMain: ReadCauseThe SmartConnect Change Tracking Extension is installed in Business Central, and the current user is not assigned the SmartConnect Change Tracking permission… [Read More]
  Tuesday, December 29, 2020   /     David Youngquist
When importing a SOP Batch using SmartConnect, my taxes are not getting automatically calculated, I am using Avalara AvaTaxAvalara does not have any eConnect procedures that will automatically trigger a tax calculation on documents pushed in from outside of GP.   The tax calculations are only… [Read More]
  Monday, December 14, 2020   /     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 (9.1.0.51)SmartConnect 10… [Read More]
  Wednesday, October 28, 2020   /     David Youngquist
Using the Excel AddIn and attempting to run a SmartConnect map.  Receiving an error back that says "Web request did not return any data.  Verify the mapID is correct and try again."   The error message in the Excel AddIn looks like this:This means you do not have the ASP.NET components installed… [Read More]