Article Content
Article Number | 000031679 |
Applies To | RSA Product Set: DLP RSA Product/Service Type: Data Loss Prevention, Enterprise Manager RSA Version/Condition: 9.6, 9.6 SP1, 9.6 SP2 Platform: Windows O/S Version: Windwos 2003 SP2, 2008 R2 |
Issue | Issue encountered where dashboard reports, gauges and the Enterprise Manager reports are not generating. Symptoms observed are the following:
Messages displayed on the gauge section and charts section
Error observed in the Enterprise Manager log - em.log DD MMM YYYY hh:mm:ss,xxx | ERROR - DataSourceErrorReporterImpl.reportError(68) | SQLServerException: Cannot execute as the database principal because the principal "reports_user" does not exist, this type of principal cannot be impersonated, or you do not have permission.
Message displayed on the report section, appears to hang and does not displaying the report
DD MMM YYYY hh:mm:ss,xxx | ERROR - ReportsRecoverableDataSource.getConnection(36) | Error occurred while trying to set the context of the reports connection: |
Cause | These are possible causes where dashboard charts and gauges are not generated with the following error: Error observed in the Enterprise Manager log - em.log SQLServerException: Cannot execute as the database principal because the principal "reports_user" does not exist, this type of principal cannot be impersonated, or you do not have permission.
|
Resolution | 1. Pre-check on Enterprise Manager database - RSA_DLP_EM
Important Note: The attached SQL script have pre-check built-in to verify if the reports_user exists. And the script will remove reports_user's permission, remove reports_user's account if present and proceed to re-create the reports_user with the proper permission assigned. |