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]
  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]
  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]
  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]
  Wednesday, April 10, 2019   /     Lorren Zemke
Using a Zip file as a SmartConnect Source … [Read More]
  Tuesday, March 5, 2019   /     Nicole Albertson
The RM Apply Detail SmartList Builder setup is designed to return the Receivables Apply Details for Microsoft Dynamics GP.  It will return the apply details for all posted RM transactions.  The script that is used in it is courtesy of Victoria Yudin via VictoriaYudin.com with only minor changes to… [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]
  Friday, February 15, 2019   /     David Youngquist
I am attempting to write an after map script and use the GlobalFileName value to report the name of the source file with the error.  The GlobalFileName field does not appear to be populated.  GlobalFileName does not automatically populate, you would need to write your own script to insert a value… [Read More]
  Wednesday, February 13, 2019   /     Ethan Sorenson
If you have ever needed to pull a time field from Dynamics CRM, the chances are the time shown in SmartConnect does not match the value seen in the CRM web client. There is a reason for this discrepancy, and in this article we will discuss how to use a calculated column to convert the time to the… [Read More]
  Wednesday, February 13, 2019   /     Ethan Sorenson
I recently ran into a unique error when importing Sales Transactions into NAV 2017.Failed to create record. Unable to call service: Data object not provided.This error message is caused by bug in the web services in NAV 2017. The Odata web services link together parent and child data and creates the… [Read More]
  Tuesday, December 4, 2018   /     Ethan Sorenson
Recently I encountered a scenario where a client machine was returning the error, "The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception", when running a map that connects to SQL. The error message is a standard .NET Framework error, that is saying .NET can't create the… [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]
  Tuesday, November 20, 2018   /     David Youngquist
 
Trying to setup the SalesForce connector and receiving the error, "INVALID_LOGIN: Invalid username, password, security token; or user locked out."First confirm that you can login to SalesForce manually using the same username, password, and security token.  If they are correct, and you can login… [Read More]
  Monday, November 19, 2018   /     Patrick Roth
I've installed the latest SmartView (Internal) on my GP 2013/2013 R2 system and it seems to work well.However when I try to use any of the GoTos for my SmartList Builder reports, SmartView gives the error:Unknown identifier 'GenerateTableTypes'.The destination GoTo window does not open. The GoTos… [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