Feeding your TRIRIGA information needs

Tag Archives: Platform

When learning about new technologies and tools, it often helps to get one’s hands just a little bit dirty and see what really makes them work. That’s the idea behind the new Bootcamp labs at IBM InterConnect 2017, March 19-23 in Las Vegas.

These instructor-led labs run 3 to 4 hours, giving enrollees the opportunity to do hands-on work with new products and technologies. Attendees can find a deeper dive in these sessions led by subject matter experts…

This lab offers attendees a basic understanding of how connected operations work. Use a simulated temperature sensor (a gauge meter in Maximo) to send a temperature reading to the Internet of Things (IoT) Quickstart. The message is then sent to NODE-RED, which parses the message. When a reading changes, it goes into a REST-API call that inserts the meter reading into the referenced asset meter readings. The reading updates the measure point and triggers a work order using Maximo functionality, or if one chooses to do so, using a TRIRIGA work task…

[Admin: This post is related to the 02.06.15 post about exploring the TRIRIGA user group community, and the 06.07.16 post about using sensors with Watson IoT to create TRIRIGA work tasks.]

I have a problem with a TRIRIGA environment. Due to an inefficient integration, we have a large number of records with a negative Object ID ready to be cleaned by the Cleanup Agent. But it seems that the Cleanup Agent can’t clean that many records.

Can I configure something or execute something into the database to clean everything in parts? I guess that I cannot simply execute a delete into the database, where the object_id < 0, since there must be more things to clean.

No, you should not go into the back-end and execute a delete on the database. There is a lot more to clean up. What do you mean the Cleanup Agent cannot clean that many records? Are you getting an exception? The OBJECT_ID must be negative, the OBJECT STATE should be null, and the UPDATED_DATE must be over 24 hours earlier for the Cleanup Agent to pick up the records to delete. It also might take a couple runs of the Cleanup Agent to delete all of the associated records.

[Admin: This post is related to the 02.24.16 post about cleaning up after retiring a record, and the 07.14.15 post about cleaning up millions of workflow instance records. As a side note, starting with version 3.4, the Cleanup Agent name was changed to Platform Maintenance Scheduler.]

After a platform upgrade, certain invalid Database Views appear. But the TRIRIGA application works fine. So are these Database Views safe to remove? Here’s the list of Database Views:

M_TRIPAYMENTAUDITSETUP

M_TRISERVICEMATRIX

V_CLASSIFICATION

V_LOCATION

V_TRIASSET

V_TRIBUDGET

V_TRICOMMON

V_TRICOSTCODE

V_TRICOSTITEM

V_TRICOSTITEMLINK2

V_TRIINSPECTION

V_TRIPEOPLE

V_TRIPRODUCTSANDSERVICES

V_TRIPROJECT

V_TRIPROPOSAL

V_TRISETUP

V_TRISPECIFICATION

V_TRISUBMITTAL

V_TRITASK

The above invalid Database Views are doing fine in the minor platform releases, but are never in use. They were used for older pass-through BOs that newer 10.x application versions do not use. Consult with your DBA to drop the Database Views. They can always be recreated when you need them.

Watson IoT Academy includes courses and training to give you the edge you need to maximize your IoT experience. Our experts have developed detailed courses to keep you up to date on the latest features in your IBM IoT solutions, with offerings that include practical simulations and best practices.

Conquer Your Facilities Challenges

IBM Facilities Management solutions enable you to make faster, more informed decisions through identification of high-return real estate transactions, simplified facility planning, and automated facilities processes. Use business analytics to identify underperforming facilities, resources and management processes against planned performance targets. Leverage management dashboards to increase the effectiveness of anyone who uses the system…

UX Framework: Object Labeling

Tom Fitts, TRIRIGA Platform Developer, presents the new object versioning enhancements, which support our classic platform and UX Framework. First, he gives an overview and roadmap of object labeling. Next, he dives deeper into the snapshot (versioning) of UX metadata, object label definitions, and best practices.

UX Framework: Globalization

Venice Inid, TRIRIGA Platform Developer, presents the new UX globalization options in our classic platform tools and UX designer tools, which support the UX Framework. First, she talks about the dictionary, translatable text, and other options. Next, she shows us where to find the options in the globalization tools.