How do you clean up the SESSION_HISTORY table?


The SESSION_HISTORY table uses 500GB of disk space in our production environment. What is the best way to clean it up?

You would want to make appropriate backups and test this thoroughly, but this is something that can be done via the Platform Maintenance Scheduler (formerly Cleanup Agent) in the IBM TRIRIGA Admin Console. You can develop SQL to do the cleanups as they meet your business requirements, add that as a new cleanup command at the bottom section of the window, and then add a new Cleanup Schedule event in the top section of the window to have it run periodically.

This may be something that you want to reach out to a business partner for assistance with, depending on your skill and comfort level in implementing such a change. If so, you can search the IBM PartnerWorld portal.

[Admin: To see other related posts, use the Sessions tag or History tag.]

Continue reading

IV97614: Cannot revise project in Schedule tab with Gantt section


If you attempt to revise a project from the Schedule tab, where the Gantt chart is visible, your session is expired and you receive an invalid session error. The issue was observed in Internet Explorer and Chrome, but not in Firefox.

An analysis from a Fiddler trace shows that when revising the project in Chrome, this POST to GanttDataUpload.jsp seems to kill the session. In Firefox, for whatever reason, this POST doesn’t occur, and the state transition is successful. To confirm that this is the scenario you are experiencing, use the following technote to run a Fiddler trace and check for the same GanttDataUpload.jsp call: IBM TRIRIGA using Fiddler for tracing web browser traffic.

As a temporary fix, use Firefox. When the record is in a read-only state, no Save action should be called on the Gantt. Moving forward, we resolved the session-kill issue when the user performs a Revise action on a project in the Schedule tab.

[Admin: This post is related to the 08.18.15 post about using Fiddler to trace TRIRIGA web traffic. To see other related posts, use the Gantt tag or Fiddler tag.]

Continue reading

IV97203: Hierarchical query for buildings with assets ends session


Users navigating to a hierarchical query of building and asset records have experienced user kickout (or timeout) behavior when entering or clearing filters.

We needed to prevent the load of a large hierarchical query with runtime user filters in a portal section that kicks the user out. Moving forward, we resolved an issue that could cause a user’s session to be terminated if the user interacts with an hierarchal query before the query has finished loading.

[Admin: This post is related to the 06.19.17 post about a user session terminated due to a missing security token. To see other related posts, use the Filter tag.]

Continue reading

Registering for the free FM user group event at Topgolf (Jul 2017)


Event: July 27, 2017, 12:00 PM to 8:00 PM Pacific Time (Topgolf in Roseville, CA)

I want to invite you to a free one-day Facilities Management event at Topgolf in Roseville, CA, outside of Sacramento, CA. Whether you are an IBM TRIRIGA or IBM Maximo user, these sessions will provide you with best practices to implement into your organization. Session topics include:

  • Using Projects to Assemble Financial Data
  • Making the Most of Key Performance Indicators to Measure What Matters
  • Using Facility Condition Assessment to Manage Your Assets & Maintenance Budgets
  • Capturing Required Inspection Data Electronically to Ensure Organizational Compliance
  • Asking the Experts
  • Networking Made Easy with Topgolf

This event has a limited number of seats so first come first served! Please RSVP here. Download the PDF agenda here. If you have any questions, please reach out to us at events@minimaximousergroup.com.

[Admin: This post is related to the 02.06.15 post about exploring the TRIRIGA user group community. To see other related posts, use the Community tag.]

Continue reading

IV97185: User session terminated due to missing security token


In TRIRIGA 3.5.2.2, the user’s session was terminated by the server due to a missing security token on the request when interacting with forms and large queries.

We needed to add a TRIRIGA security token to two locations in the reporting engine. Moving forward, we resolved an issue that could cause a user’s session to be terminated if the user interacts with an editable query before the query has finished loading.

[Admin: To see other related posts, use the Tokens tag or Editable tag.]

Continue reading