New Reports have no broadcast option

Chris Hvidsten shared this problem 2 years ago
Defect Logged

I've noticed that when I create new reports on data sources that have allowed broadcasts in the past, the broadcast button does not show up on the ouput page of the active report. Yet, older reports do show the broadcast button.

There is no broadcast option on the data editing screen either.

Comments (2)

photo
1

Hi Chris,

I can see that you've selected v7.1 as the Product Version for this ticket, and yet it sounds to me exactly like a bug that we identified just a few weeks in v7.3, so I'm going to make the assumption that you were on v7.1 and then upgraded to v7.3

The column in the Yellowfin config db that stores whether broadcasts or subscriptions are allowed for the data source is ReportViewSource.SchedulesPermitted. And the possible values are 0, 1, 2, 3, 4, 5, 6, 7. These values are derived from various combinations of sums of the following:

Broadcasts On = 1

Subscribe On = 2

Data Profiling On = 4


And the bug is that the SchedulesPermitted column doesn't get set with one of the valid values from 0 to 7, instead it gets set with the Data Source ID. So if you look at the values of the SchedulesPermitted column in your Yellowfin database you'll see that there are some 6 or 7 digit numbers in there that are actually the Data Source ID.


The workaround for this bug is to just run an update query to set the data source to have whatever permissions you want it to have, for example, if you want it to have Broadcast and Subscribe but no Data Profiling, then the value you want is 1 + 2 = 3, so you would run:


UPDATE ReportViewSource  SET SchedulesPermitted = 3 WHERE SourceId = <insert ID here>


and then the Data Source will have Broadcast and Subscribe permissions turned on.

regards,

David

photo
1

Hi Chris,


I'm cleaning up my work list and I noticed this ticket is still in the Awaiting Reply mode, so I'm just wondering how you got on with this?

regards,

David