IV96379: BIRT “Export Report” option defaults to PostScript


With TRIRIGA 3.5.2.1 and BIRT 4.3.1 on Windows Server 2012 R2, we see that the “Export Report” option in a BIRT report defaults to “PostScript”, whereas in the current TRIRIGA 3.4.2.5 production version, it is defaulted to “Excel”. We want this export report option to be defaulted to “Excel” in TRIRIGA 3.5.2.1 as well. Only after upgrading from 3.4.2.5 to 3.5.2.1, we are seeing this change.

The BIRT engine did not sort the export options by default. Moving forward, the list of format options when exporting a BIRT report are now in alphabetical order, with the default being Excel XLS.

[Admin: To see other related posts, use the Export tag or BIRT tag.]

Continue reading

Why doesn’t canceling the BIRT request stop the report process?


When a BIRT report is launched in TRIRIGA on the Reports tab or elsewhere, a Progress Bar popup appears with a “Cancel” button.

  • 1. If I click “Cancel”, will that kill the Select statement that is running against the database on the database server?
  • 2. If I click “Cancel”, will that release the database connection that is used when a BIRT report starts to run?

The answer to both questions is “No”. The thread will be consumed until the Select statement is complete. There is no messaging included in the log that the Select process was orphaned due to user interaction. The process simply continues to run until the results are retrieved and then stops. So, effectively:

  • 1. No, canceling a request will not kill the Select statement.
  • 2. No, the thread remains unaware that the request was canceled.

When the results are returned, the thread will process them, and then hit the canceled thread. There may be a message in the log warning about an IO socket being disconnected, or some other exception dealing with the dead connection.

[Admin: To see other related posts, use the Thread tag or BIRT tag.]

Continue reading

How do you fix failure to export reports to Excel due to timeout?


There are many installation scenarios that can cause TRIRIGA reports, especially BIRT reports, to fail to export due to timeout. Microsoft Excel exports are often the ones that you can observe because all of the file formatting happens during export.

Let’s focus on WebSphere Liberty installations, but this recommendation can be used for other web servers with some tweaks. Mostly, this is related to timeout settings, especially for HTTPS (SSL/TLS) connections. A good troubleshooting test is to perform the same action in a non-HTTPS (HTTP) connection. Does the report export? If so, take note of the time needed to export it and plan to extend the timeout in the HTTPS connection to at least double the time.

Refer to the IBM Knowledge Center > WebSphere Liberty > HTTP Endpoint topic. Look for the “sslOptions”, and also double-check the “httpOptions”, for timeouts.

[Admin: This post is related to the 04.20.17 post about setting the TRIRIGA session expiration warning in the portal. To see other related posts, use the Timeout tag.]

Continue reading

IV96009: Vulnerability in running BIRT reports shows stack traces


During our penetration test, a vulnerability was identified that related to the leakage of sensitive information. This vulnerability exists application-wide.

We needed to make the errors from BIRT into MID errors, and send the stack trace to the log. Moving forward, we resolved an issue when running BIRT reports that, in some situations, a technical stack trace would be displayed to the end user when an error occurred.

[Admin: To see other related posts, use the Stack Trace tag or Vulnerability tag.]

Continue reading

Where can you find a list of available IBM TRIRIGA reports?


Here are several lists of reports delivered with the as-shipped TRIRIGA solution:

Continue reading

What are the differences between TRIRIGA on SaaS and on premise?


I have a TRIRIGA SaaS client, and administrators of my client have several questions about TRIRIGA SaaS services:

  • 1. What are the differences of the functions between TRIRIGA on SaaS and TRIRIGA on premise? Please provide a list of the differences.
  • 2. Can we use mail notifications to other users from TRIRIGA on SaaS?
  • 3. Can we make and incorporate BIRT reports into TRIRIGA on SaaS?

[Admin: This post is related to the 05.24.16 post by ValuD about SaaS with TRIRIGA, and the 11.13.15 post about TRIRIGA SaaS in the Cloud Shop.]

Continue reading