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
-
------------------------------