Jump to content

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

Ted Steenvoorden

Recommended Posts

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.




Link to comment
Share on other sites

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)
UPDATE [DiscoveryJobs] SET ValidationScriptID = @ScriptID WHERE JobType = 'Windows Local Admin Accounts'


This should resolve the issue for you.


Click Studios



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...