Usage Note 53480: In SAS® Visual Analytics, report alerts might not work if the SAS Trusted User does not have the necessary access to all associated objects
In order for report alerts to work in SAS Visual Analytics, the SAS Trusted User must have ReadMetadata access to the following objects.
- The report itself.
- All SAS® LASR™ Analytic Server tables used by the report.
- All LASR libraries that contain the tables.
- All metadata folders associated with the report, the tables, and the libraries.
This requirement also applies to any group that the SAS Trusted User is a member of such as SAS System Services.
If the SAS Trusted User has been denied ReadMetadata access to any of these objects, then alerts do not work and e-mail notifications are not sent. Typically, the SASVisualAnalyticsHyperlink6.x.log contains relevant errors. For example:
LINK ERROR [va-alert-evaluator-11] 2014-06-17 16:08:19,462 [unknown:unknown] com.sas.bicommon.alerting.eventgen.AlertEvaluator - =============================================
LINK ERROR [va-alert-evaluator-11] 2014-06-17 16:08:19,474 [unknown:unknown] com.sas.bicommon.alerting.eventgen.AlertEvaluator - Exception in query running in AlertEvaluator.
LINK ERROR [va-alert-evaluator-11] 2014-06-17 16:08:19,474 [unknown:unknown] com.sas.bicommon.alerting.eventgen.AlertEvaluator - Cannot open report: /Shared Data/VA Reports/My Report(Report)
LINK ERROR [va-alert-evaluator-11] 2014-06-17 16:08:19,474 [unknown:unknown] com.sas.bicommon.alerting.eventgen.AlertEvaluator - =============================================
LINK ERROR [va-alert-evaluator-11] 2014-06-17 16:08:19,478 [unknown:unknown] com.sas.bicommon.alerting.eventgen.AlertEvaluator - Error evaluating report: /Shared Data/VA Reports/My Report(Report)
Root Cause: com.sas.bicommon.alerting.data.DataAlertingException: Cannot open report: /Shared Data/VA Reports/My Report(Report)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.evaluate(AlertEvaluator.java:288)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.run(AlertEvaluator.java:120)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[ 5 lines suppressed ]
Which Caused: com.sas.bicommon.alerting.data.DataAlertingException: Failed to evaluate alert for report: /Shared Data/VA Reports/My Report(Report)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.evaluate(AlertEvaluator.java:350)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.run(AlertEvaluator.java:120)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[ 5 lines suppressed ] Here is another example of what you might see in the log:
LINK ERROR [va-alert-evaluator-11] 2014-06-24 11:30:33,816 [unknown:unknown] bicommon.alerting.eventgen.AlertEvaluator - =============================================
LINK ERROR [va-alert-evaluator-11] 2014-06-24 11:30:33,824 [unknown:unknown] bicommon.alerting.eventgen.AlertEvaluator - Exception in query running in AlertEvaluator.
LINK ERROR [va-alert-evaluator-11] 2014-06-24 11:30:33,824 [unknown:unknown] bicommon.alerting.eventgen.AlertEvaluator - Error getting QueryRunner - java.lang.Exception: no properties found for data source (Reason : DataSourceNotFound)
LINK ERROR [va-alert-evaluator-11] 2014-06-24 11:30:33,824 [unknown:unknown] bicommon.alerting.eventgen.AlertEvaluator - =============================================
LINK ERROR [va-alert-evaluator-11] 2014-06-24 11:30:33,827 [unknown:unknown] bicommon.alerting.eventgen.AlertEvaluator - Error evaluating report: /Shared Data/VA Reports/My Report(Report)
Root Cause: Error getting QueryRunner - java.lang.Exception: no properties found for data source (Reason : DataSourceNotFound)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.getQueryRunner(AlertEvaluator.java:1164)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.evaluate(AlertEvaluator.java:322)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.run(AlertEvaluator.java:120)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[ 5 lines suppressed ]
Which Caused: com.sas.bicommon.alerting.data.DataAlertingException: Failed to evaluate alert for report: /Shared Data/VA Reports/My Report(Report)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.evaluate(AlertEvaluator.java:350)
at com.sas.bicommon.alerting.eventgen.AlertEvaluator.run(AlertEvaluator.java:120)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[ 5 lines suppressed ] Operating System and Release Information
| SAS System | SAS Visual Analytics | Linux for x64 | 6.3 | | 9.4 TS1M1 | |
| Microsoft® Windows® for x64 | 6.3 | | 9.4 TS1M1 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
If the SAS Trusted User has been denied ReadMetadata access to a SAS Visual Analytics report or any of the objects associated with the report, then alerts created for the report might not function properly.
| Type: | Usage Note |
| Priority: | medium |
| Date Modified: | 2014-08-06 11:08:29 |
| Date Created: | 2014-07-11 13:15:43 |
