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 3.5.2.3 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

How do you import the upgrade OM packages to custom environments?


We have already upgraded our platform to 3.5.2.1. We are currently in the process of upgrading our application from 10.3.2 to 10.5.2.

For the application upgrade, we have set up a staging environment with an initial install of 10.5.2 and we have configured all BOs, forms, and other objects to meet our current customization. My question is: What if we import the IBM upgrade OM packages (sequential from 10.4 to 10.5.2) to our current environment (which has all customization)? It would definitely overwrite all the customization and configuration, but does it affect the record data as well (e.g. lease records)?

When it overwrites the customization at the BO and form level, would it corrupt the record data since some of the custom fields on the records won’t exist at the BO level any more? And what happens after we import all our customization back in the current environment from the staging environment?

The short answer is: You wouldn’t apply the IBM upgrade OM packages. Instead, you’d build OMs in your now customized 10.5.2 environment and then apply them to your current environment.

[Admin: To see other related posts, use the Object Migration tag or Upgrade tag.]

Continue reading

How do you populate the request class drop-down in work task?


I’m having issues with request classes on work tasks. We created a project (including work location). But now, when we create a task from the project, very few of the values (including work location) are mapped onto the null work task. The drop-down that comes from the request class depends solely on this work location.

Also, the work location of the task gets its value from the project (as mapped). But now, when we try to get the drop-down for the request class based on work location, random values are shown. When I reselect the same work location, and then go back to the request class, I see the correct values. Any thoughts on this behavior? How do you get the request class list for the very first time without reselecting the work location in a work task that was created from the project?

[Admin: To see other related posts, use the Mapping tag or Work Tasks tag.]

Continue reading

Why do duplicate opportunity rows show in the Assessment tab?


We have an issue with duplicate opportunity rows in the building’s Assessment tab. The issue seems tied to the building system class smart section and the underlying table reporting against it, T_TR_DEF_LI_IT_TR_BUI_SY_CL, while in a building record, Assessment tab, when we create a new opportunity, fill in the building system class smart section (not the building system item one), and create draft.

If a user then tries to change the building system class, but then decides to not save and instead just closes the form, the row that is entered into the table T_TR_DEF_LI_IT_TR_BUI_SY_CL for the temp data, is not removed when the record is closed without saving. Which results in the opportunity query on buildings displaying the opportunity twice. This seems to be a general issue with the use of these tables, since it also happens when you do the same steps on a work task and a facility project; an extra row remains in T_TR_WO_TA_TR_FACILIT_PROJ.

Has anyone else encountered this issue and found a way to correct it? Using the steps below, can anyone confirm that the issue happens for them as well?

This issue is being addressed through PMR 12839,082,000 / APAR [IJ00504].

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

Continue reading

ValuD: What do you look for in a TRIRIGA mobility solution?


Mobility has revolutionized business. Gartner predicts that by 2022, 70% of software interactions in enterprises will occur on mobile devices. What does that mean for facility maintenance?  With service technicians always on-the-go, accessing TRIRIGA remotely can help maximize efficiency and productivity by combining the convenience and power of handheld devices, like smartphones and tablets, with the robust capabilities of TRIRIGA

How can MobilD help

ValuD’s MobilD – Mobility Delivered for TRIRIGA – brings a role-based user experience and intuitive dashboard and KPIs to ensure the requester views information that is directly relevant to his/her role and gets quicker access to data. MobilD can help the requester to:

  • Create all types of asset-related service requests for self and their team
  • Select the location as well as the user-specific asset by scanning the bar code or the QR code of the asset
  • Provide a brief description of the problem
  • Add and update attachments like images, documents, audio and video
  • Assign service request priority
  • Track open and closed service requests in real time
  • Receive notifications
  • View survey requests on task completion and perform survey actions
  • Change password from mobile…

[Admin: This post is related to the 10.11.17 post by ValuD about an IBM TRIRIGA mobility solution for technicians, and the 07.28.16 post about mobilizing IBM TRIRIGA with MobilD. To see other related posts, use the ValuD tag or MobilD tag.]

Continue reading