Affected Versions: RMS 10.5
1. ManageSoft database on SQL Server Standard or Enterprise Edition
Steps to perform:
1. Start "RMSdatabase daily database maintenance" job
2. Verify history of execution of job
1. "Populate discovery from inventory" step fails with following error:
Executed as user: NT AUTHORITY\SYSTEM. Reading device information from inventory [SQLSTATE 01000] (Message 0) Deleting old devices [SQLSTATE 01000] (Message 0) Updating existing devices [SQLSTATE 01000] (Message 0) Adding new devices [SQLSTATE 01000] (Message 0) The formal parameter "@DeviceRoleOverride" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output. [SQLSTATE 42000] (Error 8162). The step failed.
An issue with the PopulateNetworkDevices stored procedures can cause the above error message.
Execute SQL-script from the hotfix according to the instructions provided in the Instructions.txt file.