HELP ARTICLES

Help Articles SmartConnect

  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]
  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]
  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
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
This article will discuss how to upload and download files to an SFTP with SmartConnect 20.16 or newer using the WinSCP API. … [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]
  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, 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]
  Tuesday, December 17, 2013   /     David Youngquist
When running a SmartConnect map, getting an error that says "The source was not found, but some or all event logs could not be searched.  To create the source, you need permission to real all event logs and to make sure that the new source name is unique.  Inaccessible logs: Security"This message… [Read More]
  Friday, November 15, 2013   /     David Youngquist
You cannot update from SmartConnect 10.0.0.51 to 2014.  You need to update to either SmartConnect 2010, 2011, or 2012 first.The steps to update to 2014 would be as follows. 1. Run the system maintenance on your 10.0.0051 version of SmartConnect (Tools – SmartConnect – System Maintenance).… [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]

FILTER BY PRODUCT


ARCHIVES

open all | close all

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