Install

The type initializer for ‘System.Data.SqlClient.SqlConnection’ threw an exception

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 SQL connection.The error is caused by a corruption of the .NET…

[Read More]

This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms

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 would need to be enabled.The reason this is causing…

[Read More]

HTTP Error 403.14 – Forbidden when browsing the SmartConnect web client

When attempting to browse the SmartConnect web client, the browser window reports an error that says “HTTP Error 403.14 – Forbidden” followed by an additional message that says “The Web server is configured to not list the contents of this directory.”  What is causing this?This means you do not have the ASP.NET components installed on…

[Read More]

The dialog: “In order to use this Window in SmartConnect an Extender View must be created” does not show when saving Extender Window

I’ve installed a new Microsoft Dynamics GP Client and when I save my Extender Window, I’m expecting to see the dialog:In order to use this Window in SmartConnect an Extender View must be created with the same name as the Window.  Would you like to do so now?However, the dialog never appears.  How can I…

[Read More]

The SmartConnect Setup Wizard ended prematurely

I’m installing SmartConnect choosing all the installation items.After entering the information for those items and starting the install, it quickly fails and gives the error:The SmartConnect Setup Wizard ended prematurely.SmartConnect setup ended prematurely because of an error.  Your system has not been modified.  To install this program at a later time, please run the installation…

[Read More]

Enabling web services in Microsoft Dynamics 365 Business Central

When you integrate with Microsoft Dynamics 365 Business Central using SmartConnect, you are able to integrate with all the data in your instance that is published to web services. In Microsoft Dynamics 365 Business Central, only some of the objects are published to web services by default.  However, it is pretty easy to check which…

[Read More]

Connecting to Microsoft Dynamics 365 Business Central – SOAP Web Services

This article is for setting up the SmartConnect connector that uses the NAV/D365 Business Central SOAP web services.We also have a connector that uses the NAV/D365 Business Central Odata web services, which you can find here.When possible, the Odata web services are the recommended approach by eOne and Microsoft.Before setting up the connector in SmartConnect,…

[Read More]

Error: SQL Script parse error: invalid syntax, during SmartConnect install

When installing SmartConnect we are getting the error message, SQL script parse error: invalid syntax. The install then rolls back all actions. We have tried installing several versions of SmartConnect with the same results on each one.  ———————————————————————————————————————-In this case the user was entering a SmartConnect user password that contained a single quote (‘). When…

[Read More]

There is a problem with this Windows Installer package. A DLL required for this install to complete could not be run.

When installing SmartConnect 2018, receiving a message that says, “There is a problem with this Windows installer package.  A DLL required for this install to complete could not be run.  Contact your support personnel or package vendor.”   I downloaded the SmartConnect install file again, and still receive the same error.  SmartConnect installs a sql.dll file in…

[Read More]

Metadata contains a reference that cannot be resolved

The full error message is:Metadata contains a reference that cannot be resolved: ‘https://yourinstance.api.crm.dynamics.com/XRMServices/2011/Organization.svc?wsdl&sdkversion=9’Microsoft changed CRM to use TLS 1.2 starting with the release of version 9. SmartConnect has been updated to use TLS 1.2 as of version of 20.18.0.9. If you are on version 20.18.0.9, and still receiving this error, then the registry will need…

[Read More]

RECENT POSTS


RM Apply Detail SmartList Builder Template
The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement
GlobalFileName not populated when using in a script
Wrong Date in Dynamics CRM/D365 for Customer Engagement Data Source
NAV 2017 Error: Data object not provided

POPULAR POSTS


Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
Manufacturing Serial Trace SmartList Builder Template
The server process could not be started because the configured identity is incorrect.
How to update SmartConnect from 10.0.0.51 to SmartConnect 2014
Running a map in SmartConnect and receiving an error that says "The source was not found, but some or all event logs could not be searched."

CATEGORIES

ARCHIVES

open all | close all

TAGS

CRM Demo Dynamics Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Flexicoder GP GPUG integration integration manager Meet the Team Microsoft Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners release SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk