RMS200115: "RMSdatabase daily database maintenance" SQL job -> fails on execution of "PopulateNetworkDevices" stored procedure

Affected Versions: RMS 10.5



Input condition:

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:

Error details

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.




Hotfix #6273.zip


Have more questions? Submit a request


Powered by Zendesk