CEA troubleshooting

From PTAGISWiki

A problem with the CEA report was noticed by Don Warf's crew and reported to Doug.

Reports for individual sites work well. But when multiple sites are displayed, the results are not grouped and sorted by site.

Find the source for the report

The CEA report shows up under Data > Reports > Interactive Reports.

Those reports are displayed by a jsp that pulls from the SREE repository. To add or change Interactive Reports, the change must be registered in the SREE Enterprise Manager's replet registry. The web gui for this is http://www.ptagis.org/sree/EnterpriseManager. The file is repository.xml.

The permissions on the folder "Interactive Reports" are used if no permissions are defined on the individual reports in the folder. Here we can see that Registered Users can read, and PTAGIS Administrators can write and delete. This is the correct setting.

Selecting the CEA report shows the details of the source file used when invoking the report. From this we can tell that the file is CEA_MultiPurpose_Section.srt. We can also see that there are no permissions defined on this report, so the parent folder's permissions are used. This is the correct setting.

Gather debug information

Checking sree.log for "ERROR" tags today, the following four instances are found:

[ERROR] Mar 8, 2006 8:09:30 AM: Group columns defined in group filter not found.
[ERROR] Mar 8, 2006 8:11:18 AM: Group columns defined in group filter not found.
[ERROR] Mar 8, 2006 8:27:06 AM: Group columns defined in group filter not found.
[ERROR] Mar 8, 2006 12:35:21 PM: Group columns defined in group filter not found.

Which likely correspond to each run of the CEA report today.

Examine the source in SREE Designer

The SREE Designer is a desktop java application that can edit report templates. It depends upon the following configuration files: query.xml, datasource.xml, and stylereport.srl. Since this is an error found in production, copy the production versions of those files to a local workstation as well as the CEA_MultiPurpose_Section.srt

Actually, the CEA report also depends on query1.xml, datasource1.xml, and stylereport1.srl. The contents of those files must be merged into the config files on the workstation to replicate the production environment. This merge has been done on development.

Opening the CEA_MultiPurpose_Section.srt and viewing the fields used for grouping shows two fields: obs_site and sort_str.

Of those two fields, obs_site is listed in the Query Fields, but sort_str is not. Removing the sort_str allows the report to run correctly in the workstation test environment.