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”
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.
After opening up the Linked Integration Window, just click “Process” in that window, and then click “Save” on the Data Source Setup window.
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.
