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

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…

Continue reading

Where can you find information about IBM TRIRIGA 3.5.2 and 10.5.2?


Where is the information regarding IBM TRIRIGA Application Platform 3.5.2 and IBM TRIRIGA 10.5.2 features, installation, and more?

[Admin: This post is related to the 06.13.16 post about finding 3.5.1 and 10.5.1 information, the 12.11.15 post about finding 3.5.0 and 10.5.0 information, and the 10.01.15 post about finding 3.4.2 and 10.4.2 information. To see other related posts, search “where is the latest“ or “where can you find“.]

Continue reading

Where can you find information about the IBM TRIRIGA Connector for Business Applications (CBA)?


The IBM TRIRIGA Connector for Business Applications (CBA) is a SOAP API for the TRIRIGA platform. The technical specification and documentation for this API can be found here: IBM TRIRIGA Application Platform 3 Connector for Business Applications Technical Specification.

Continue reading

Document Upload Java Client Example

The following is sample Java client code demonstrating a document upload via CBA on 3.5 platform with MTOM enabled, using Apache CXF and JAXB. This code utilizes stubs generated from the CXF WSDL to Java utility (classes such as TririgaWS and TririgaWSPortType are generated from this). Note that this is just an example for demonstrative purposes, it is not code officially supported by IBM. Please review the Connector for Business Applications Technical Specification guide for more information on working with CBA…

Continue reading

Maintaining a Java Client Session Example

The following is sample Java code demonstrating usage of the Apache CXF BindingProvider to maintain a single client session for multiple CBA requests with 3.5 platform. This code utilizes stubs generated from the CXF WSDL to Java utility (classes such as TririgaWS and TririgaWSPortType are generated from this). Note that this is just an example for demonstrative purposes, it is not code officially supported by IBM. Please review the Connector for Business Applications Technical Specification guide for more information on working with CBA…

Continue reading

Why are your retired integration workflows being republished?


Why are your retired integration workflows being republished after restarting your server?

This is working as designed. The integration object is controlled by the platform, so any changes it finds will be added back upon an application server restart. You can find more information in the IBM Knowledge Center topic: Object upgrades. Note that if you add an integration object record called IGNORE_UPGRADE, then no updates will be made to the integration object and it will not apply fixes in the future that are added to the package.

Continue reading

Top Ten TRIRIGAFEEDIA posts of July 2016


Yes, it’s that time again! In July 2016, TRIRIGAFEEDIA earned 4842 views from 1543 visitors, which represented a distinct drop from last month, most likely due to the U.S. Fourth of July holiday. Yet this top ten represented 5.7% or 276 of these views, which was the highest “spike” for any set of top-ten posts so far, wow.

Like last time, there was a lot of activity with certification training, UX learning, and the TRIMAX community. Again, the UX activity was led by the UX Lessons. But this time, the big surprise was Levin Global’s presentation “From data to comprehensive property management”, nice! So, here were the top-ten posts of July 2016.

Rank Post Hits
1 How do you earn a professional TRIRIGA certification? 53
2 *UX Lessons 51
3 From data to comprehensive property management 29
4 What are the TRIRIGA training paths to certification? 25
5 Exploring the TRIRIGA user group community 23
6 What does the TRIRIGA scheduler engine do and how is it used? 23
7 Where can you find the IBM TRIRIGA process flow diagrams? 21
8 *What exactly is TRIRIGA UX? 18
9 How do TRIRIGA custom tasks work? 17
10 Are you planning to attend TRIMAX 2016 in October? 16
*Technically, a page, not a dated post. But worth ranking.

20160801a

Rank Country Hits
1  United States 2559 (52.9%)
2  India 871 (18.0%)
3  Canada 207 (4.3%)
4  Hong Kong SAR China 156 (3.2%)
5  United Kingdom 150 (3.1%)
6  Spain 135 (2.8%)
7  Poland 76 (1.6%)
8  Russia 68 (1.4%)
9  Sri Lanka 66 (1.4%)
10  Singapore 62 (1.3%)

[Updated 08.12.16]

TRIRIGAFEEDIA Versus Knowledge Center

In a previous Top Ten post, I revealed a scary statistic. Based on the 6-month period ending February 29, 2016, TRIRIGAFEEDIA is getting about 30% (16198/54143) as many views, or 3 views for every 10 views of TRIRIGA on the IBM Knowledge Center (KC), wow. Has it changed since then? Sadly, I don’t have the latest KC numbers.

Luckily, I have the latest TRIRIGAFEEDIA numbers. If we assume that the KC views grew by 20% for the 6-month period ending July 31, 2016, then this blog reached 44.5% (28904/64972) as many views. But if we assume a 10% gain, then this blog rose to 48.5% (28904/59557), or 5 views for every 10 KC views! Which is crazy!

In other words, in less than 2 years, TRIRIGAFEEDIA has reached almost 50% of the activity of TRIRIGA on KC, updated for 5 years by 5-7 writers including myself. Crazy!

Knowledge Center Collections Views
All 21 TRIRIGA collections (6 months ending 02.29.16) 54143
All 21 TRIRIGA collections (assuming 20% gain) 64972
All 21 TRIRIGA collections (assuming 10% gain) 59557
All 21 TRIRIGA collections (assuming 0% gain) 54143
All 21 TRIRIGA collections (assuming 10% loss) 48729
By comparison, TRIRIGAFEEDIA (6 months ending 07.31.16) 28904

[Admin: This post appeared first on TRIRIGAFEEDIA. This post is related to the 07.01.16 post about the top-ten posts of June 2016.]