After an upgrade from 3.x to 4.x, the user experiences this error when trying to add a data connection in the Admin Tool System Settings Data Connections and when trying to add to a role's Company Access in Admin Tool Security Access Management. This only happens when trying to add BI360DW connections. All other live connections work fine.
The old BI360 data connections were left over and corrupted during the upgrade.
Note: Please make a back up of the OSR_Repository prior to making following change. Below change would need to be done by SQL DBA who is familiar with SQL and running SQL queries.
Deleting from the tables dbo.Integrations, dbo.IntegrationSettings, and dbo.SystemConnections where IntegrationName = 'SODS-MSSQL' will remove all corrupt data connections. Then re-add the BI360DW to the data connections and remove all the old BI360DW from the Company Access window.
BI360 Administration 4.x