Why aren’t the INCLUDE_EXTENSIONS file types uploaded as expected?

When trying to upload a file type that should be allowed based on the contents of the INCLUDE_EXTENSIONS and EXCLUDE_EXTENSIONS lines, the user gets a message stating that uploading a file of that type is not allowed. Why?

Adding spaces in the extension list will invalidate any other defined value after the first one listed. In the TRIRIGA 3.5.2 and later releases, more variables were added to the TRIRIGAWEB.properties file, for more-precise control over what can be loaded as an attachment to a record, or added to Document Manager. These variables are documented in the TRIRIGA Release Notes, but to give the basic information, these are the two new sets of variables:


Any file extensions can be added here, but the format of the list needs to be properly set. Use only comma-separated values (CSV) without spaces to build the string. If there are any spaces in the list, remove them…

[Admin: To see other related posts, use the “include_extension” search phrase.]

Continue reading

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:


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

Continue reading

How do you copy your Oracle DB schema for TRIRIGA Support?

To create a logical copy of your TRIRIGA database schema, use the Oracle data pump for exporting database dump files. More information can be found here in the Oracle Help Center. It is recommended to run these steps from your database server with a privileged database user, and to stop the TRIRIGA application beforehand.

(1) Create directory object in Oracle where you want to download the dump. Information on how to do this can be found here in the Oracle Help Center.

(2) Run the export command expdp as follows. Substitute the variables properly.

expdp <db_admin>/<admin_pw> DUMPFILE=<dpump_dir>:<filename>.dmp SCHEMAS=<schema_name> LOGFILE=<dpump_dir>:expschema.log

[Admin: The same article is also posted in the Watson IoT Support blog.]

Continue reading

Why doesn’t the TRIRIGA installer see that the JDK is installed?

I have a valid JDK installed and my PATH is set up correctly. Why is the TRIRIGA installer telling me that “No Java virtual machine could be found” in my PATH and that I must install a VM prior to running the install?

Most likely the problem is that your JAVA_HOME environment variable is not set. The JAVA_HOME environment variable needs to be set to the directory in which your JDK is installed:

bash-4.1$ set JAVA_HOME=/u1/jdk1.8.0_91 ; export JAVA_HOME

If you are getting the “No Java virtual machine could be found” error message and your JAVA_HOME environment variable is not set, setting it and rerunning the platform installer command should resolve the problem:

bash-4.1$ set JAVA_HOME=/u1/jdk1.8.0_91 ; export JAVA_HOME
bash-4.1$ ./install_tririga_v3.5.1_Linux.bin

Note: OpenJDK must be removed from any Linux environment before installing TRIRIGA.

Continue reading

How do you use a TRIRIGA helper object to create notifications?

I am trying to better understand the concept of using a helper object in order to create notifications, and I have some questions:

  • 1) The receivers of the notifications: I read that the people records have to be associated with the notification helper record inside the workflow by using the “Notify” association and I implemented it… How does TRIRIGA distinguish which users are supposed to receive the notification through this association? How can I define a specific user or users or user group to receive the notifications? It seems as if I have no control at the moment on who is receiving them.
  • 2) The variables triInput*TX of the mapping in the helper object: While I can successfully display the mapped variables 1-8 in the notification content message, for some reason the 9th variable always displays the triIdTX field (meaning the ID of the notification content message), no matter if I map the variable to a field or not!
  • 3) triLinkedRecordTX field in the mapping: I know that by mapping this field to “source”, at the end of the notification, a hyperlink with the instruction of clicking to open the related record is added. Is it possible to modify this text or instruction, as well as the actual hyperlink address (in other words, modify the template used to create this part)?

Continue reading

Is there a way to hide the triLog > triLocationRetire popup form?

While it is generally needed by our client, I would like to ask if it is possible to hide the triLog > triLocationRetire form that pops up when we retire a building, and according to a specific condition check that takes place inside a workflow? In other words, when we push the Retire button, a check is made. If the condition is true, the triLocationRetire should pop up. If not, an error message should appear in the Attention section of the form.

The problem is that, in the last case, the triLocationRetire form pops up and it actually needs to be filled in and submitted before the error message is shown. Obviously, this is inconvenient and impractical for the client, so I am looking for a way to hide the popup form in this specific case. Any suggestions would be greatly appreciated! Thank you very much in advance!

TRIRIGA introduced conditional popup logic in platform You can see an example in this out-of-the-box workflow: “triReserveCheckInLog – Synchronous – Validation – Pre-Popup Form – Cancellation Review” (triLog module, triReserveCheckInLog BO). You can dynamically set which popup form to be displayed or set it to not display any popups at all. The pre-popup form workflow needs three things:

  • 1. “triPopupForm” input parameter, defined in the Start task parameters.
  • 2. “triPopupForm” return value, defined in the Start task parameters.
  • 3. A Variable task pointing to the System module, triPopupForm BO.

Continue reading

Do you recommend any TRIRIGA performance monitoring tools?

We are planning to upgrade to the 3.4.1 platform soon and are interested in any tools that have been used for monitoring TRIRIGA performance over the different components. We are already aware of the performance monitoring available from the Admin Console but we are more interested at any tools (third party, freeware, commercial, etc…) that anyone here has used and find effective in helping to pinpoint where different components of the infrastructure are being hit hardest by certain processes, such as whether a bottleneck is at the client machine, network, database, or application server level.

We have followed recommendations set in the Performance Best Practices guide and are looking for tools to help to further tune our system, or at least determine if a bottleneck is not in our control. Any feedback from your experiences will be greatly appreciated!

Glad you’ve taken a look through the best practices! As far as end-to-end monitoring, we’ve seen others use Dynatrace as a holistic system tracing tool to help identify bottlenecks. It provides great information and can get very granular. Here’s some more info on it…

There are several tools that can do system monitoring. We don’t recommend one over another. These monitoring tools can be set up to monitor several single instance variables within TRIRIGA. In the Administrator Console, there is a Performance Monitor tab. You can pull the URLs that will retrieve the current value of your system. For example, you can set up alerts to warn you if free memory exceeds a certain threshold, or if a system has a high number of users logged in. Here are the properties we can monitor…

Continue reading