Reaching another TRIRIGAFEEDIA milestone


Last week, December 5th, 2019 was the 5th anniversary of TRIRIGAFEEDIA. Another impressive milestone! Where have I been? Well, let’s just say that 2018 and 2019 have been very busy years. And I have no doubt that 2020 will be just as interesting, if not more so. Speaking of which, you might’ve noticed by now that IBM developerWorks is showing an important banner at the top of its wiki pages:

“The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this wiki will no longer be available.”

However, I’ve also learned that our specific wiki will remain frozen in read-only mode until the end of January 2020 before disappearing. Despite the challenges, the TRIRIGA team has been busily preparing a new wiki platform alternative. While the initial wiki pages may be populated as soon as January 2020, more and more batches will steadily follow, and the final pages may appear several months later.

So if you have a favorite wiki page that you might need during our migration process, I encourage you to print them to PDF for safekeeping. In any case, I’m excited about what I’ve seen of the cool new wiki platform so far. Stay tuned! Thanks again for reading, following, and feeding TRIRIGAFEEDIA. I appreciate it!

[Updated 12.13.19]

Interestingly, one day after I posted this entry, IBM updated their wiki banner:

“The developerWorks Connections platform will be sunset on January 2, 2020. This wiki will no longer be available unless an extension has been requested.”

[Updated 12.19.19]

Unfortunately, IBM didn’t approve the direction of our new wiki alternative. So we’ll discuss our next steps in January 2020. Meanwhile, I’ve learned that our current wiki will remain frozen in read-only mode until the end of March 2020. Stay tuned!

[Admin: This post appeared first on TRIRIGAFEEDIA.]

Continue reading

How do you use Dynamic Workflow settings in Call Workflow task?


I am looking for some explanations for the “Dynamic Workflow” property settings in the Call Workflow task. When should I use it?

The Dynamic Workflow property and fields allows you to pull the workflow name to execute from a task > field, instead of the workflow name being hard-coded in the workflow. The field must contain the workflow name to execute.

Excerpt from the “Application Building” (3.5.3, PDF) user guide:

Dynamic Workflow: The values of this field are used to dynamically define the name of the workflow that this task will launch. For the “Task with Workflow Name” drop-down list, select the task record that contains the workflow name. For the “Workflow Name Field”, select the field on the task record that contains the workflow name. This record field must contain the workflow name that you want to launch.

[Admin: To see other related posts, use the Workflow tag or Workflow Builder tag.]

Continue reading

Does anyone know about Trinity for data import and export?


We are in the process of upgrading our TRIRIGA installation from 3.4.1/10.2.x to 3.5.2/10.5.2 and have run into an issue with Trinity, something that Global Services set up for us to import and export data to external systems. Does anyone know anything about it? Or know where to find any product documentation?

I work in IBM TRIRIGA Support as an L2 Support Engineer. I can tell you that Trinity is not a supported product and you would need to reach out to IBM Global Business Services (GBS) for assistance with this. I recommend starting out with a call to the IBM General Inquiries number to get in touch with GBS. That phone number is: 800-IBM-4YOU (800-426-4968).

Continue reading

Where can you find a list of available IBM TRIRIGA reports?


Here are several lists of reports delivered with the as-shipped TRIRIGA solution:

Continue reading

Why aren’t changes to security groups being saved?


Is anybody seeing this issue in TRIRIGA 3.5.2? The Release Notes say that:

“The inner Save action on the Access tab of the Security Manager is removed. The user can make multiple permission changes, mix them with general changes and member changes, and save all at the end with the Save or Save & Close actions.”

But this doesn’t seem to work. Why not?

[Admin: This post is related to the 03.07.16 post about best practices for managing your security groups.]

Continue reading

How do you update a record with Data Integrator?


I’m trying to update a record using Data Integrator. But currently, I have no good results with this. The record is just added, not updated. I would appreciate it if you could show me an example of updating the value of an existing record for an employee’s email address below. I might not have understood the publish name, or the unique key of TRIRIGA.

  • (1) triIdTX: 1000004: This is the system generated number at record creation. I assume it’s used as the unique key. (I am not sure if it is the publish name or not.)
  • (2) triLastName: Aaaaaaaa: This is the value with the same value when creating a record.
  • (3) triFirstName: Bbbbbbbb: This is the value with the same value when creating a record.
  • (4) triEmailTX: xxxxx@yy.zz.com: It was not set when creating a record. And I want to set this value as an update value.

Also, let’s suppose that some values are already set to other fields of triPeople, but are not specified in Data Integrator.

You are correct that it’s adding a record because you’re not using the Publish Name. Take a look at the documentation in Application Building for the IBM TRIRIGA Application Platform 3: Data Management (3.4.x PDF p.35 | 3.5.2 PDF p.31). I confirmed the publish name in our latest release is the same as documented: Last Name + ‘, ‘ + First Name + ‘ – ‘ + ID.

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

Continue reading

IV95450: Run MS SQL “Set Varchar” scripts after upgrade to 3.5.2.1


How do you run the MS SQL “SetVarcharColsToNumeric_MSSS.sql” and “SetVarcharColsToNumeric_MSSS_Publish_BO.sql” scripts after upgrading to TRIRIGA 3.5.2.1? According to the TRIRIGA 10.5.2 and 3.5.2 release notes:

  • “There are two scripts for MS SQL, SetVarcharColsToNumeric_MSSS.sql and SetVarcharColsToNumeric_MSSS_Publish_BO.sql. Run SetVarcharColsToNumeric_MSSS.sql first. When it completes, run SetVarcharColsToNumeric_MSSS_Publish_BO.sql.”
  • “Run the script PRIOR to installation of IBM TRIRIGA Application Platform version 3.5.0. NEVER run the script after upgrading to 3.5.0.”

Our application is 10.4 and platform is 3.5.2.1. How can the SQL script be applied to update the system fields with the sub-attribute type of CreatedDateTime to CreatedDateTime (Number) and ModifiedDateTime to ModifiedDateTime (Number)?

Continue reading