How do you export more than 1000 records with integration object?

We are currently on TRIRIGA I have an integration object that uses a static query to export records to a flat file. It works great when I click on the Execute action on the integration object. It can export more than 27,000 records. However, I only want to export a subset of those records, so I am executing it from a custom task as described here.

If there are 1000 records or less to export, executing from a custom task runs as expected. But if there are 1001 records or more, the workflow throws a NullPointerException (NPE). How can I get it to export more than 1000 records?

[Admin: To see other related posts, use the Integration Object tag or Custom Task tag.]

Continue reading


How do you use the saveRecord() with state transitions in CBA?

The IBM TRIRIGA Connector for Business Applications (CBA) has the saveRecord() method. If saveRecord() runs without an action parameter, it triggers not-audited field validation (read-only, formulas, etc.). Is it fine to use this method without an action name?

For example, saveRecord could call a state transition by its name in a parameter. But a record could be in any state, so this state transition could be not-applicable to the current state. What if a record receives the wrong transition? (I guess InvalidActionNameException.) Should this situation be handled by process design? Or by state validations in the code which is difficult to maintain? Or another way?

[Admin: To see other related posts, use the CBA tag or Connector tag.]

Continue reading

How do you equip your TRIRIGA chariot with fierce stallions?

There’s an old metaphor originating from Plato that compares the soul to that of a chariot with a pair of winged horses. Chariots of the gods were equipped with two good horses, while us mere mortals were given one good horse and one bad, unruly horse, depicting the conflicts of the soul. Due to this imbalance, we would always face hardships. But those of us who could put that unruliness to use could potentially rise high enough to hang with the gods.

What does this have to do with IBM TRIRIGA and hanging out at TRIMAX this week? Not a whole lot, I just like to throw out fascinating metaphors. However, if you’re looking to power up your facilities “chariot” with the fiercest of good stallions, and corral the unruliness of unused data,  you may want to read on.

The five fierce stallions of 2017

When it comes to fierce stallions, why have 2 when you can have 5? And when you’re talking about investments around TRIRIGA, the more the merrier.  Here are the top 5 stallions driving the chariot of your facilities management efforts this year:

  • 1. New lease accounting standards drive compliance domination…
  • 2. Analytics help you understand the performance of your chariot…
  • 3. Cloud isn’t just for mythical gods…
  • 4. Mobility enables the business to soar from anywhere…
  • 5. User experience (UX) drives Herculean engagement…

[Admin: What does TRIRIGA mean? A tririga (trī-ˈrē-gə) is a team of three horses yoked three abreast, commonly associated with the use of chariots during the Roman Empire. To see other related posts, use the TRIMAX tag.]

Continue reading

Can you run all patch helpers (10.3 to 10.5.2) after final OM import?

We have upgraded the TRIRIGA platform to and started upgrading the application from 10.2 to 10.5.2 in incremental order (10.3, 10.3.1, until 10.5.2). To minimize the outage and complexity during production implementation, we have been suggested to take a final OM package after completing 10.5.2 deployment, and apply all the customizations which might have been impacted with the upgrade. This final OM package will contain all the changes from 10.2 to 10.5.2.

Our question is on the patch helpers: Can we run all the patch helpers (from 10.3 to 10.5.2 in order) after importing the final OM package?

Also, we are running the Varchar-to-Numeric script before importing the application upgrade packages. This script is taking a long time (almost a day in two test environments), but when we tried in another environment, it’s running for more than 2 days and still didn’t get executed. Is it normal for this script to run like that? Or will it be an issue? There are no differences between the environments.

I wouldn’t recommend doing the upgrade in one package. Usually, it ends up being quite large and it will cause issues. The IBM-recommended way is to perform each OM, then run the patch helpers. Once you have upgraded the OOB OM packages, you can have one OM which has your custom objects…

[Admin: This post is related to the 10.25.17 post and 04.28.17 post about running “SetVarcharColsToNumeric” scripts. To see other related posts, use the Scripts tag.]

Continue reading

UX: How do you put a conditional check in TRIRIGA UX view?

I am new to the IBM TRIRIGA UX framework. My requirement is: “If a user contains a profile image, then display the uploaded image, or else, display the default image.” How can I put this conditional check inside the view.html page?

This doesn’t have an “else” condition, therefore just inverse your condition in another “dom-if”.

<template is=”dom-if” if=”{{condition()}}”>displayed when condition() is true


[Admin: To see other related posts, use the UX Framework tag or Perceptive tag.]

Continue reading

How do you set the report filter for last (previous) month?

I want to create a report and set the filter for last month. When I want to add a condition, it opens the token list with values. Is there any chance I can update that token list? Or does anyone know how to set the filter for the last (previous) month?

Try $$THISMONTH$$-1. You can use operators with the relative time periods for query filters.

[Admin: To see other related posts, use the Query tag or Filter tag.]

Continue reading