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

Affected Versions: RMS 10.5

 

Scenario:

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

Results:
1. "Populate discovery from inventory" step fails with following error:

Error details

Message
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.

 

Issue:

An issue with the PopulateNetworkDevices stored procedures can cause the above error message.

 

Fix:

Execute SQL-script from the hotfix according to the instructions provided in the Instructions.txt file.

 

 

Attachment:

Hotfix #6273.zip

 

Have more questions? Submit a request

Comments

Powered by Zendesk