The following probes fail to start after upgrading UIM 8.51 to 9.0.2; maintenance_mode, sla_engine and discovery_server (discovery_server starts but fails after some time)
Data_engine .log starts up fine but shows the following errors:
2) ExecuteNoRecords [Microsoft OLE DB Provider for SQL Server] Incorrect syntax near 'go'.
0 de: COM Error [0x80040e14] IDispatch error #3092 - [Microsoft OLE DB Provider for SQL Server] Incorrect syntax near 'go'.
COM Error [0x80040e14] IDispatch error #3092 - [Microsoft OLE DB Provider for SQL Server] Could not find stored procedure 'spn_bas_VerifyFeature'.
QoSInsert::VerifySettings - error: [COM Error [0x80040e14] IDispatch error #3092 - [Microsoft OLE DB Provider for SQL Server] Could not find stored procedure 'spn_bas_VerifyFeature'.] sp: [ spn_bas_VerifyFeature ]
Cause
The UIM 9.02 upgrade was executed with user that does not have all of the required permissions.
Environment
Release : 9.0.2
Component : UIM - INSTALL
Resolution
Rerun the UIM install, setupCAUIMServer.exe, with the designated Windows user per the UIM install guide - Microsoft SQL Server Log in Requirements