Back

Real Time MSSQL data source integrations fail after upgrading to SmartConnect 21.1.0.1531

Published: Nov 05, 2024
Post Author Written by David Youngquist

After upgrading to SmartConnect 21.1.0.1531 my existing MSSQL real time data sources are no longer working. The Run Number on the Integration is not updating, nor is the SQL data getting send. There are no error messages in the SmartConnect event log.


This is caused by a new parameter that was added to the eOneMssqlRealTimeStoredProcedure. There is a new parameter named “Encoding” that has been added to the stored procedure.

Any real time MSSQL data sources made prior 21.1.0.1531 will stop working until you Re-register the data source.

To do that, open up the Data Sources tab in SmartConnect and double click on your MSSQL Real time data source. In my screenshot below, you can see mine is named “PM00200_SQLTABLE”

PM00200 realtime

In order to fix the maps, all you need to do is Click on the “Linked Integrations” button in the window, which will open up the list of maps the data source is linked to like this.

PM00200 realtime 2 1

After opening up the Linked Integration Window, just click “Process” in that window, and then click “Save” on the Data Source Setup window.

PM00200 realtime 3

This will recreate the real time SQL trigger on the SQL source table, and it will include the additional parameter that was added in SmartConnect 21.1.0.1531

If you have multiple real time MSSQL data sources, you need to open each source one at a time, and re-register each of the real time MSSQL sources. This does not apply to any other type of real time data sources.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.