Using a file-based (e.g. csv, txt) UDC connector in Sense November 2017 or earlier, it might suddenly stop working in February 2018 or April 2018 displaying error code "RROR [22018] [Microsoft][ODBC Text Driver] Internal OLE Automation error while syncing UDC connector in Sense."
The setup is still the same without any configuration changes. Same will happen on a fresh installed April 2018 release.
Environment:
Qlik Sense February 2018 and April 2018.
Cause:
Broken dependencies to the MS access Runtime 2016 library after the installation.
Resolution:
Please reinstall the MS Access Runtime 2016 library 16.0.4288.1001, using the download link https://www.microsoft.com/en-US/download/details.aspx?id=50040 and reboot the Server.