EC Enterprise: Reports say Unavailable
Posted by Ryan Ohlson, Last modified by Joel Brickell on 06 February 2013 04:51 PM
|
|
Problem: Your user account has permissions to execute Reports, but when you log into EnergyCAP, it says "Unavailable" for the Installed Reports. Solution: There is likely an issue with the underlying tables which hold the available reports for all the users in EnergyCAP. The specific table which governs this is the SpecificReport table in conjunction with the ReportGroup and ReportGroupType tables. The following SQL script will repair the entries in these tables. After running the SQL script, you will need to Update the Reports again in the database for All Users. See this Help Manual Page for instructions on Updating Reports: http://help.energycap.com/reporting-on-data/updating-reports/ SQL SCRIPT (run as esuser or sa): -- ===================== INSERT INTO
INSERT INTO
-- ReportGroup.parentID is only used for public report folders, and those are always assigned to the SYSTEM user, hence always NULL for this purpose. | |
|