Reports are not sent by e-mail to the configured recipients (4249503)

Although email recipients are configured, reports (both manual and scheduled) are not sent via email.

Alarm emails are successfully delivered, as are test email's from the email configuration dashboard.

Issue can be tracked by issue number MSQL-75, formerly FGL-16659.

To confirm that MSQL-75/FGL-16659 is the cause of the issue:

For a V5.6.* FMS, check the Diagnostic Snapshot (located within a FMS support bundle) for the "Email Reports Sample" rule as listed below.  If the rule is in a "Hibernating" state, move on to the workaround below.

-----------------------------------------------
Rule name: Email Reports Sample id: 877e64db-3193-4ea5-8150-22ead239ee9d
Type: Simple
Topology change scoping query invalidations: 0
Full syncronizations: 0
----------
Rulette on Topology object: No topology object. id: null

Hibernating
----------
-----------------------------------------------

For a V5.7.* FMS, check that the following three items are true. If so, try WORKAROUND 1 under the Resolution section.

1. The rule has 0 triggers and 0 rulette instances in the rule diagnostic dashboard.  See the screenshot listed below.

2. The MonitoringPoliciies rule have the following entry.
             
3. FMS is federation master and has "DB2_UI" or "SQLServer_UI" cartridges installed.

RESOLUTION 1

1) Verify that the report rule: "Email Reports Sample" and "

one or the other is enabled.

Dashboard | Administration | Rules & Notifications | Manage Rules

2) Check the "Last Fired" field of the Administration | Rules & Notifications | Rule Diagnostics | Email Reports Sample.

RESOLUTION 2

Please check the details of Recipients e-mail addresses that the reports are being sent to and make sure that the e-mail addresses have a comma (,) rather than a semi colon (;) between each e-mail address. 

RESOLUTION 3 

WORKAROUND 1:

1. Navigate to FMS | Dashboards | Administration | Rules & Notifications | Manage Registry Variables
2. Search for #FORGE_PC_Rule and delete all results (if no entries are listed here, run the attached script 'KB125628_deleteRegistryVariable')
3. Navigate to FMS > Dashboards | Administration | Rules & Notifications | Rule Management
4. Search for "Email Reports Sample"
5. Disable this rule and then re-enable it
6. Test sending a report via email

WORKAROUND 2 (Deprecated)

Import the attached "Email-reports-sample.xml" file into your FMS

1. Save the Email-reports-sample.xml on your FMS server
2. Navigate to %FMSHome%/bin and run the following command (specifying username/password and path to the xml file)

• • Windows: fglcmd -usr -pwd -cmd util:configimport -f /Email-reports-sample.xml
  • Linux: ./fglcmd.sh -usr -pwd -cmd util:configimport -f /Email-reports-sample.xml