What is the “Integration” check box for in workflow Start task?

What is the “Integration” check box for in the workflow Start task?

Assuming you are referring to the Start task of an asynchronous workflow, when this property is selected, the workflow is used to migrate data from staging tables in IBM TRIRIGA records. This type of workflow is used extensively in IBM TRIRIGA DataConnect. 

Check out this IBM Knowledge Center topic about DataConnect that describes the “Integration” check box: Workflow task settings.

[Admin: The same question is also posted in the main Application Platform forum. To see other related posts, use the Staging tag or DataConnect tag.]

Continue reading


How do you move classifications from one environment to another?

I recently set up a new environment in which I need to migrate the classifications (not just the record data) from the existing system. What is the fastest way to do this and ensure that the classifications are set up properly in the new system?

I migrated the BOs and forms. I checked the Include association for the BO to itself and with the classification BO. The form has been added to the “Includes/Forms” tab of itself as well as the classification form. But I still don’t see this BO added under the classification hierarchy when I click on “New” to create the root record.

[Admin: This post is related to the 03.29.17 post about creating a classification. To see other related posts, use the Classifications tag or Object Migration tag.]

Continue reading

What is the purpose of the TRI_REORG_ANALYSIS table?

We are working on a DB2-to-Oracle migration for TRIRIGA 3.5.2/10.5.2 by using SQL*Loader. The TRI_REORG_ANALYSIS table recently caught our eye. This table exists in DB2, but does not exist in Oracle. But today, after we generated a new DB2 backup, this table is no longer there.

My question is: Is this a temporary table used for calculation or cache purposes?

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

How do you migrate documents from one environment to another?

Is it possible to migrate documents from one TRIRIGA environment to another?

Yes, documents can be migrated from one environment to another, but I would recommend that you focus on “system” documents like BIRT reports, or Excel sheets used for offline processes. I would not use object migration (OM) to migrate documents in large quantities…

[Admin: This post is related to the 12.02.16 post about integrating with CMIS or ECM solutions, the 06.09.16 post about using an ECM solution instead of Document Manager, and the 04.13.16 post about uploading 6500 locations with several attachments each.]

Continue reading

How long does it take to migrate 3000 projects into TRIRIGA?

We are in a process of implementing Capital Projects and were wondering if we can get some timelines from any of your previous data migration experiences. We have a system setup based on the Performance Best Practices document, advanced infrastructure, with a total of 4 GB JVM. So, approximately how long will it take for me to migrate the following into TRIRIGA?

  • (a) 3000 Capital Projects with 200+ cost codes per project, multiple bids per project, change orders.
  • (b) 500 Projects with 200+ cost codes per project, multiple bids per project, change orders.

I understand it’s difficult to gauge, but we’d like just a ballpark timeline. Any number or timelines will be of great help.

Continue reading

Planning your IBM TRIRIGA installation or migration

Planning for a new installation or migration of an existing IBM TRIRIGA installation can be a complicated endeavor, because there are so many different possible configurations for the IBM TRIRIGA n-tier architecture. Here are some links that will help you with your planning:

  • Hardware Requirements: For the minimum recommendation in terms of physical hardware, please review this information.
  • Archive of IBM TRIRIGA Support Matrices: Review the applicable compatibility matrix for your TRIRIGA Application Platform version to make sure your target environment will be compatible. Click the Attachments tab to see all matrices.
  • Installing IBM TRIRIGA Application Platform: Review the overview of hardware configuration for your version. As an example, here is the link to IBM TRIRIGA Platform 3.5.0.
  • Best Practices for System Performance: Review the performance best practices document and implement any recommendations that apply to your target environment.
  • System Sizing: Review the system sizing information available here and take action accordingly.

This is a lot of information to go through, but taking the time to review this information during your planning phase of your installation or migration will allow you to make informed decisions based on your intended use of the IBM TRIRIGA product, and to plan accordingly.

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

Continue reading