seamusocionnaigh / fogra

A service that publishes platform events for failed CRM Analytics recipes

Fógra

fógra, m. (gs. ~, pl. ~í). 1.FÓGAIRT 2. Notice. (a)~ a thabhairt (go), to give notice (that).

Alerts for CRM Analytics Dataflow and Recipe Failures

Use scheduled Apex to query the CRM Analytics dataflow job resources REST resource, and create a platform event.

Analytics on Dataflow and Recipe run times

Analytics about analytics! Stores the data retrieved from the dataflow job resources so you can track performance over time.

Simple instructions

• Assign the Dataflow Job History Admin permission set
• Execute anonymous apex, for example, to schedule the monitor to run every 30 minutes:

String schedule = '0 30 * * * ?';//every 30 mins
System.Schedule('FetchDataflowJobDetails',schedule,new AnalyticsMonitor());

• Navigate to the Dataflow Job History folder under the Dashboards tab
• Review the Dataflow Job Failure object under Setup - Integration - Platform Events
• Decide whether to use Apex or Flows to create cases, send multiple e-mails, or in-app notifications to alert multiple stakeholders about failed jobs.

TODO

• Less lazy query of dataflowjobs -- filter on job created or or executed date and compare against last known schedule query
• better handling of the Message property -- some messages are closer to warnings i.e. the job failed because it's already in the queue -- if the message contains 'Error Id', 'Internal Server Error' or 'Java', recommend a Salesforce support case is logged
• managed package for better admin support

Preview