Where do you set or change the host name URL?

I installed IBM TRIRIGA Application Platform 3.5.3 in Linux CentOS 7. While running the TRIRIGA installer, I selected an embedded server, that is IBM WebSphere Application Server (WAS) Liberty Profile This server is successfully installed and up and running.

From the log, I found that the server host where IBM TRIRIGA is accessed has an URL something like this: http://some.static.ab-xyz.com:8001. This URL value was taken by default. I did not provide this value. My question is: How do I change this host name URL? Where is the setting for this?

I’m not sure what log you’re looking at and what specifically you’re seeing. What is set as your FRONT_END_SERVER value in your TRIRIGAWEB.properties file?

[Admin: To see other related posts, use the Hostname tag.]

Continue reading

Having issues with OM packages & nav items during upgrade to 3.5.3

Our customer has seen an issue when installing TRIRIGA 3.5.3 (Linux, Server build number: 276955) on an existing database (on 3.4.2 / 10.4.2). Everything goes well until starting up the server. Generally, TRIRIGA will run a database upgrade on the first startup when a build number difference is detected.

In the OM log, we notice that TRIRIGA tried to import the upgrade OM package… The import process started with the triPlatformObjectLabelManager package, but it failed to import a navigation item, which is newly created for Object Label Manager. I haven’t found any log which can explain this failure. I’ve checked the NAV_ITEM table. This navigation item wasn’t there before the upgrade process. Then all of the other packages are stuck on a pending status. Nothing happens after “Creating package from Zip file”. This behavior causes a lot of SQL update failures.

Meanwhile, on our Dev environment (Windows, Server build number: 279835), the upgrade went very well. You can find the difference in the logs. The OM log was set on “Debug” level on both servers. Note that the build number is slightly different between these two enviroments. Have you seen this kind of issue? Where can I find more details about the navigation item import failure?

[Admin: This post is related to the 02.17.17 post and 05.19.16 post about inconsistent OM validation results. To see other related posts, use the Object Migration tag or Upgrade tag.]

Continue reading

Why is there a connectivity issue with TRIRIGA and DB2 on RHEL?

Recently, I have been getting some connectivity issue with TRIRIGA 3.5.2.x and DB2 on (Red Hat) RHEL 7.2. The connection between TRIRIGA breaks suddenly and the app crashes. When I see the error logs, it says:

2017-04-20 08:01:33,694 ERROR [com.tririga.design.smartobjecttype.dataaccess.DBConnectionDAO](DataImportAgent) FAILED DATA CONNECTION java.sql.SQLNonTransientException: [jcc][t4][2043][11550][4.18.60] Exception java.net.ConnectException: Error opening socket to server localhost/ on port 50,000 with message: Connection refused (Connection refused). ERRORCODE=-4499, SQLSTATE=08001 DSRA0010E: SQL State = 08001, Error Code = -4,499
Caused by: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.18.60] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill() - insufficient data (-1). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
at com.ibm.db2.jcc.am.kd.a(kd.java:328)

On the login page, it asks me to contact the system administrator. I have to restart the app and the database to make it work again. Interestingly, the app and the database server are on the same machine/VM. As always, any help is appreciated.

This almost looks like an ipTables or some sort of SecureLinux function getting in the way of the network connection and terminating it. Have you tested it by turning off the seLinux services and ipTables? If it runs better, then start adding rules to prevent the secure frameworks from stepping on the network connections.

Continue reading

Can you migrate TRIRIGA from Linux OS to Windows OS or mix them?

Can you change operating systems? That is, start with Linux and migrate to Windows. Currently, we’re on TRIRIGA 3.3.1 and upgrading to the latest platform, and in the process, we would like to move to Windows Server. A related but hypothetical question: Can you run TRIRIGA with the app server on Linux and the process server on Windows?

TRIRIGA is OS agnostic. You can run a Linux app server and Windows database server, and vice versa. You could even throw AIX in the mix and have that run the process server, or any mix there of. In the lab, we have OS X MacBook Pros with a mixture of Windows and Linux VMs. Personally, I think Linux+Intel is a more stable server platform that has far fewer up-time issues versus Wintel (Windows+Intel). These days, most shops are migrating from Windows to Linux.

Continue reading

Can you remove TRIRIGA BIRT report files from /tmp folder in Linux?

Can the IBM TRIRIGA BIRT report files be removed from /tmp folder in Linux? We can see BIRT-related files in the Linux /tmp folder being generated from the TRIRIGA user sessions… Can these files be removed from the system on a regular basis?

Yes, they can be removed. You can remove those BIRT temporary files from the /tmp folder if they are at least 2 days old, even if the system is up and running (no need to shut it down). We do not expect user sessions holding BIRT report rendering for more than 1 day, but we are letting it go 2 days for security. For new versions (3.5 and onward), this works better and we do not expect to have a large amount of BIRT-report related files in the /tmp folder (but this may happen for older versions).

Continue reading

When and how do you clean up application server temp files?

Over time, the temp (temporary) directory may fill up with files on the application server or process server. You may want to clean up these files over time, it is generally safe to delete files over 2 days old. We suggest setting up a cronjob (Linux/Unix) or Scheduled Task (Windows) that deletes temp files owned by the user running the TRIRIGA application, over 2 days old.

As an example, on a Linux environment, the following command can be placed into a shell script file, then run nightly at 1 am.

(1) Shell script file: /path/to/script/cleanTririgaTemp.sh

find -mtime +2 -user tririga -exec rm {} \;

(2) Don’t forget to chmod to make it executable:

chmod u+x /path/to/script/cleanTririgaTemp.sh

(3) Then run crontab -e and set the script to run daily at 1am:

0 1 * * * /path/to/script/cleanTririgaTemp.sh

Continue reading

Having an issue with installing TRIRIGA on WebLogic

I’m having an issue with an installation on WebLogic. The installer only works if TRIRIGA is installed on WebLogic’s AdminServer node. I’ve found on a forum, not regarding TRIRIGA but WebLogic, that the script used by the installer is not compatible with any node other than AdminServer.

Does anyone have any documentation or reference where TRIRIGA on WebLogic can only be installed on the AdminServer node? This is doing a clean installation of TRIRIGA 3.5.1 on Linux with WebLogic 12c.

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

Having an issue with community reports after upgrade to

We upgraded from TRIRIGA to 3.5, and then applied the patch But when we log in as a non-Admin user and click on Community Reports, we get an error: “Not able to retrieve Community Report.”

The user is in a security group that has “View Access” to the Community Report. If I click “OK” on the error and then I filter and click “Apply Filter”, the reports show up in the Community Reports. We are running the TRIRIGA instance on Linux, WebSphere Liberty, Oracle We are not seeing this issue with Admin users.

The root cause to this issue is that there are reports that have references to documents that no longer exist in Document Manager. You can run the following SQL to identify which reports exist that has no valid document referenced. If you delete these reports or set a document, this issue will go away. We will be resolving this permanently in our next release after 3.5.1.

select rep_name, rep_template_id, format_doc_name, format_doc_id from rep_template_hdr r
where not exists (select spec_id from ibs_spec i where i.spec_id = r.format_doc_id) and r.format_doc_id > 1

[Admin: This post is related to the 12.08.14 post about community reports not being shown for non-Admin users.]

Continue reading

OpenJDK is not supported and should be removed

OpenJDK is not supported nor will it work properly with IBM TRIRIGA and the IBM TRIRIGA Application Platform installer. It is preferred and our best practice that the OpenJDK package be completely uninstalled from the server.

It may be possible to use the “alternative” command on Linux to point to a supported IBM or Oracle JDK. Please consult your Linux Operating System’s manual for information on how to use “alternative” if the OpenJDK cannot be removed.

Continue reading