Broadcast Overwrite Issue - Urgent
Hope you are having a good day today.
Our report occurs broadcast overwrite issue, which is descripted as follows.
1. We created a new report called logins by Date*, and setup the broadcast report.
2. We received the broadcast report around 11:30 AM today successfully.
And we also could find out the related event data from our YF DB, the sql is shown below and results is attached as broadcast_logins by date_before update.csv.
select * from reportheader r
left outer join reportbroadcast b on b.reportid = r.reportid
left outer join event e on b.broadcastid = e.unitid
Where r.reportname = 'Logins by Date*'
and (e.eventcode in ('rptbroadcast','rptbroadcastsent') OR e.eventcode IS NULL)
3. Then we udpatd the report by adding a new filter, and re-setup the broadcast time for testing.
4. Then the broadcast did not send through around 11:45 AM today, and the YF DB does not have the event data as well when I checked around 11:50 AM, the results have been attached for you.
We use patch 20160727 7.2.
Much appreciate if you could advise us how to resolve this issue ASAP.