Windows Local Admin Account discovery jobs give an error after upgrading to version 8

[Ted Steenvoorden]

After upgrading to version 8 we are getting the following error with our Windows Local Admin Account discovery jobs:

 

Error: An error has occurred in the Passwordstate Windows Service executing the method 'ProcessAccountsDiscoveryJob'. Error = Conversion from string "" to type 'Integer' is not valid.&stacktrace= at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(Object Value) at PasswordstateService.PasswordstateService.ProcessAccountsDiscoveryJob(DataTable DataTable)

These jobs where running without an error before the upgrade.

 

 

 

[support]

Hi Ted,

 

Sorry you've run into this issue, and we believe this bug only affects customers who have upgraded from version 7. We will have a fix in the next release for this, but for now can you please do the following:

• Edit the Discovery Job, and re-select the appropriate Host Type and Operating Systems options
• Using SQL Server Management Studio, execute the following SQL script:

DECLARE @ScriptID int
SET @ScriptID = (SELECT ScriptID FROM [ValidationScripts] WHERE ValidationScripts.ScriptName = 'Validate Password for Windows Account' AND ValidationScripts.Inbuilt = 1)
SELECT @ScriptID
UPDATE [DiscoveryJobs] SET ValidationScriptID = @ScriptID WHERE JobType = 'Windows Local Admin Accounts'

 

This should resolve the issue for you.

Regards

Click Studios

 

 

[Ted Steenvoorden]

Thank you for your feedback. That solved the problem!

 

Best regards,

Ted

 

[support]

Excellent - thanks Ted.