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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...