Compliance Reports Generate FunctionBlock Error

Version: 1.0
Date: 10/07/2010

Problem

When running compliance reports from the website, you may receive a stop error similar to:

Code:
Stop Error Code: (FunctionBlock:GetMangeableAccounts): 80040E21
Cause

Out of date statistics can cause bad execution plans to be chosen by SQL's query optimizer.

Resolution

Using SQL Management Studio, connect to the E/RPM compliance database ad run a new query:

Code:
Update Statistics dbo.tbl_ComplianceRenderedAccountAudit with fullscan;
Update Statistics dbo.tbl_ComplianceReportAlljobMessages with fullscan;
Update Statistics dbo.tbl_ComplianceReportAllJobs with fullscan;
Update Statistics dbo.tbl_ComplianceReportAllStoredPasswords with fullscan;
Update Statistics dbo.tbl_ComplianceReportAllSystems with fullscan;
Update Statistics dbo.tbl_ComplianceReportAllSystemsInGroups with fullscan;
Update Statistics dbo.tbl_ComplianceReportBase with fullscan;
Update Statistics dbo.tbl_ComplianceReportDelegatedManager with fullscan;
Update Statistics dbo.tbl_ComplianceReportDelegatedManagerGroup with fullscan;
Update Statistics dbo.tbl_ComplianceReportGroups with fullscan;
Update Statistics dbo.tbl_ComplianceReportJobupdatePassword with fullscan;
Update Statistics dbo.tbl_ComplianceReportJobWebOperation with fullscan;
Update Statistics dbo.tbl_ComplianceReportOperationMessages with fullscan;
Update Statistics dbo.tbl_ComplianceReportScheduleJobInfo with fullscan;
Update Statistics dbo.tbl_ComplianceReportSystemsInGroups with fullscan;
Applies To

Enterprise Random Password Manager (ERPM)
Random Password Manager (RPM)