Report Broadcast monitoring

Ryan Kearbey shared this question 5 months ago
Answered

Hello,

We would like to develop a script that looks at the report broadcasting and monitor for any failures. Are the broadcast logs kept in a readable log file on the YF server somewhere, or maybe in a postgres table? Please let me know the location.

For example, a report failed to broadcast on 4/3/2022. Our script will monitor the log file (or query postgres) on a daily basis to look for these types of failures.

/e7373b6fc3032d971974e56ea7927a87

Comments (4)

photo
1

Hi Ryan,

Thanks for reaching out to support. You can find this info in the Yellowfin Configuration Database, under the reportbroadcastresult table.

abbcdc763f0ac18b0f71027befa1775e"where broadcastsuccess = 0" should turn up any failures.

Hope this helps! Let me know if you have any additional questions.

Thanks,

Eric

photo
1

Hi Eric, thanks, this is what I was looking for. Follow-up question: is there a table(s) in the YF config database for Transformation and Signals errors?

Ryan

photo
1

Hi Ryan,

Here's some table locations for you -

Transformations - etlrunlog

Signals - event, where eventtypecode = "signals*"

Hope this helps! Let me know if you need anything else here.

Thanks,

Eric

photo
1

Thanks again Eric. That's all I needed.

Ryan