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

What types of bookmarks can be used on a TRIRIGA form or record?

What are the types of bookmarks that can be used on a TRIRIGA form? It seems that bookmark functionality within TRIRIGA allows you to store only one of each record type. For example, a bookmark to an Employee 2 record can overwrite the saved bookmark to an Employee 1 record.

There is a difference in bookmarking a form versus a record:

• 1. Bookmark as a form: Allows a user to pin one type of form.
• 2. Bookmark as a record: Allows user to pin multiple records of each type.

However, there are instances where users cannot bookmark as a record. In this case, go to the Form Builder and open the form header properties. The following properties should be selected:

• 1. Allow bookmark to create record.
• 2. Allow bookmark to specific record.

[Admin: This post is related to the 09.21.16 post about assigning bookmarks to users.]

Is there a way to track the report runtime history in TRIRIGA?

Is it possible to determine query and report usage by username, date, and time? Can that history be retained in the application for a user-configurable period of time? If I want to track usage of any or all reports within TRIRIGA, is there a method to do so?

Yes. With the TRIRIGA 3.5.2 release, a “Track History” check box has been added to all reports that allows for a case-by-case tracking model to be used for report usage. Selecting that option will cause tracking in the “History” tab to take place. Clearing the option will cause the tracking to stop, but existing log data will be retained for a configurable period (days). This variable is found in the TRIRIGAWEB.properties file:

REP_HISTORY_AGE_CLEANUP 365

[Admin: This post is related to the 10.31.16 post about using the report run history to track performance.]

Why can’t you see the available licenses under “My Profile” tab?

I have recently upgraded to TRIRIGA 3.5.2/10.5.2. Currently, no user records are created. So I created one user record, but I can’t see the list of licenses under the “My Profile” tab in the user record. All licenses can be seen from the Tools > List Manager, and are also placed on the server under the \config\ folder. Any help would be appreciated.

See if this technote might help: Why aren’t IBM TRIRIGA employee records bringing the list of licenses available on system?

[Admin: This post is related to the 04.22.16 post about employee records not showing the available licenses.]

Why do exceptions for currency conversion appear in server.log?

How do I address the cause of currency conversion exceptions that are appearing in my TRIRIGA server.log file so they stop being logged? The exception can occur as a result of currency conversion being done when a user profile has a different currency than the base currency. Here are some examples of the exception seen in the log:

Error in Conversion from >CHINESE YUAN RENMINBI< to >US Dollars< . Using conversion rate of 1.
Error in Conversion from >NIGERIAN NAIRA< to >US Dollars< . Using conversion rate of 1.

There are generally two ways to resolve this:

• 1. Add currency conversion values to allow the currency conversion to take place. The documentation can be found in the IBM Knowledge Center: Currency.
• 2. Confirm every user profile has the same currency as the base currency. The base currency is defined in the TRIRIGAWEB.properties file.

Also, check for duplicate UOM values for currency. This could explain the exception if the first two options fail to resolve the problem…

Why can’t you see any workflows in Workflow Builder?

When I open the TRIRIGA Workflow Builder, I can’t see any workflows. But I see this error in the server.log file:

ERROR [com.tririga.platform.error.ErrorHandler]([ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)') Report handled exception: com.tririga.platform.error.PlatformRuntimeException: java.lang.RuntimeException: weblogic.servlet.jsp.CompilationException: Failed to compile JSP /html/en/default/wfBuilder/wftManagerList.jsp
wftManagerList.jsp:41:19: The type __wftmanagerlist.WorkflowComparator must implement the inherited abstract method Comparator.thenComparing(Function, Comparator)

This is a WebLogic bug. To resolve the issue, customers must go to the Oracle website to download, install, and apply a WebLogic patch (Patch 18729264).

[Admin: This post is related to the 09.26.16 post about APAR IV89199 where HTML code appears instead of workflows in Workflow Builder.]

Why don’t the query filters freeze at the top of the query any more?

I’m checking out the new TRIRIGA 3.5.0 platform. Is anyone else annoyed that the query filters don’t freeze at the top of the query any more when you scroll?

This was done to provide support for different browsers. This technote has more details: Query headers in TRIRIGA are no longer static.