The label properties error is kind of a red herring. It just means the system didn't find the file and they aren't always needed (or included) in the archive for the report.
You might try exporting the SQL from the queries you are using for the datasets in the report and perform an explain plan on them to see if there are any filter combinations that might cause lag in the query of the return dataset to grow to a size that causes issues with the report.
If you are using a multi-server environment you might try adding a VM and offloading the reports to the new server and setting a higher BIRT memory limit. If the issue is with the report dataset getting too large, that could help.
------------------------------
Brian Brinkmann
------------------------------
Original Message:
Sent: Wed June 26, 2024 02:49 PM
From: Carl Chaput
Subject: BIRT reports intermittently not returning any data
We are using Tririga queries in the reports. We do suspect that if we converted the tririga queries to SQL queries it might fix the issue. (This is currently our only idea to try to fix the problem.)
We do get the following error in server log when the error occurs but we also get it when the report runs.
2024-06-26 13:47:25,527 ERROR [com.tririga.platform.birt.viewer.TriResourceLocator](Default Executor-thread-448) Cannot retrieve BIRT resource. [fileName=[v2QRY]triContract__triRealEstateContract__cre_-_creRealEstateLease_-_Query_-_Payment_History_Reportii32ii.tririgalabels.properties] |
com.tririga.platform.birt.runtime.resource.BirtResourceException: Unable to process resource. [name=[v2QRY]triContract__triRealEstateContract__cre_-_creRealEstateLease_-_Query_-_Payment_History_Reportii32ii.tririgalabels.properties] |
------------------------------
Carl Chaput
Software Engineer
Travelers Insurance
-
Original Message:
Sent: Tue June 25, 2024 08:59 AM
From: Brian Brinkmann
Subject: BIRT reports intermittently not returning any data
Are you using exported or SQL datasets in the reports? Is there anything captured in the TRIRIGA or Webserver logs that correlate to the time the report is ran with the issue?
------------------------------
Brian Brinkmann
Original Message:
Sent: Mon June 24, 2024 11:14 AM
From: Carl Chaput
Subject: BIRT reports intermittently not returning any data
We have some BIRT reports that intermittently do not return any data. We can run a report and it will not return any data and we know there is data for this report. A short time later we can run the report and it will return the data. It seems to be an issue with the BIRT to TRIRIGA connection. We converted one of our simpler BIRT reports to a TRIRIGA report and that will always work. Has anyone seen a problem like this before?
Carl
------------------------------
Carl Chaput
Software Engineer
Travelers Insurance
-
------------------------------