Support

The 12.19 update included a Security fix that affected the way User Options are handled.  The fix necessitated the setting of all current Report Delivery options to the default 'Email w/ Link'.  Users may reset their desired options for all reports by navigating to 'View All Reports' and choosing their desired Delivery Option.

UPDATE:  The 12.19 update made a change in where the User Options are stored. This setting has been moved to the UAO table. Since the Report Delivery Option is missing for all users after they update, they all default to the 'Email w/ Link' option.

For users who would like to try and reset users options, we have developed this SQL which can copy the current USO Report Delivery Option to the UAO table. Please use care whenever running SQL queries.  This should only copy data and insert into UAO, no data should be deleted. 

;with cteTheList -- CTE is needed so the IS Null check can be performed. 

as

    (

    select n.uid  UID

          ,u.op   NM

          ,Case 

                 when u.VL1 = 'EMailWithOutAttachment' then 'EMailWithOutLink'

                 when u.VL1 = 'EMailWithAttachment' then 'EMailWithLink'

                 else u.VL1

                end   OV 

    from ugn n inner join uso u

    on n.un = u.nm and u.op = 'ReportDeliveryType'

    )

--insert into uao (UID,NM,OV)        --> uncomment this line to do the insert

select L.UID,L.NM,L.OV from cteTheList L

left join uao a

on L.uid = a.uid and L.NM = a.nm and L.ov = a.ov

where a.UID is null