Ted Steenvoorden Posted August 18, 2017 Share Posted August 18, 2017 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 More sharing options...
support Posted August 19, 2017 Share Posted August 19, 2017 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 Link to comment Share on other sites More sharing options...
Ted Steenvoorden Posted August 23, 2017 Author Share Posted August 23, 2017 Thank you for your feedback. That solved the problem! Best regards, Ted Link to comment Share on other sites More sharing options...
support Posted August 23, 2017 Share Posted August 23, 2017 Excellent - thanks Ted. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.