Tag: SmartConnect 2021

I’ve been doing some work with a client recently implementing SmartConnect 2021, although the client has done much of the install themselves using the manual as a guide (this was their choice to help keep costs down). When we tried to enable the REST API and navigate to the endpoint to check, we were receiving an error:

HTTP Error 500.19 – Internal Server Error

The requested page cannot be accessed because the related configuration data for the page is invalid.

We did some investigation and research and found that the issue was that one of the required features had been missed during the installation. There are three elements of the WCF Services component of the .NET Framework 4.7 Features which need to be installed, but weren’t.

The screenshot below shows my demo system with the three components installed:

Once the client added these three components, the REST API worked correctly.

We’ve recently upgraded a client from SmartConnect 2018 to SmartConnect 2021 and mosstly had no problems. One issue which came up is when users tried to run an integration which had a Microsoft Excel file as the data source. Each time they tried the integration, and on several machines, they always received the same error:

This is an error I have seen before; the users in the previous case who were having problems had the 64-bit version of Microsoft Office installed and the working ones had the 32-bit version. this required us to install the 32-bit version of the Microsoft Access Database Engine 2016 Redistributable from the command line as a silent install.

All of the clients in this case already had a 32-bit version of Excel; a quick check and I found that for SmartConnect 2021 you actually need the 64-bit version of the Microsoft Access Database Engine 2016 Redistributable which again should be installed silently from the command line.