HEAT 20x: Some reports do not show in the Report workspace

Version 1

    Details

    Often for the Administrator and Report Manager roles (to which, at least, all out-of-the-box reports should be published) many reports may stop displaying normally, and the list of reports may appear drastically reduced.  Interestingly, the reports may display on the Home page in the Reports dashboard part.


    Resolution

    The exact cause of this will vary, but the following should address the issue. You can also use select statements around this to verify the problem (for example, "select * from frs_def_reports where UnLocked=1" should match the number of currently-shown reports):


    Update frs_def_reports
    Set UnLocked =1
    Where UnLocked = 0