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

Advertisements

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

How Umpqua Bank is transforming real-estate with IBM TRIRIGA & IoT


I’m Tony Bailey, Senior VP of Real Estate, Facilities, Design, Construction, TPO, Physical Security teams at Umpqua Bank… As a first time presenter at TRIMAX – the combined TRIRIGA and Maximo User Group conference – I am excited to be able to meet with other companies that are at various stages in their path towards transforming both their facilities and their employee experiences using IBM TRIRIGA and Internet of Things (IoT) capabilities…

As we continue to expand our business, we will also leverage this knowledge as we deploy the Capital Planning capabilities in TRIRIGA. The lease administration capabilities are helping to streamline operations around construction procurement. For example, we are working on deploying a new e-invoicing capability that will automate many of time-intensive processes that consumed a lot of valuable resource from our business…

At TRIMAX in November, I will be sharing more details about Umpqua Bank’s project road map and lessons learned. I will be speaking about how we are incorporating IoT technologies to support our “branch of the future” vision, discussing in depth our plans to develop a dynamic floor plan – complete with traffic sensors and asset management to optimize our model – in an effort to drive just-in-time maintenance to help control costs.

I hope you are attending TRIMAX this November and I look forward to meeting you there to continue sharing best practices about our facilities management strategy.

[Admin: To see other related posts, use the Umpqua Bank tag or TRIMAX tag.]

Continue reading

Verdantix: Three takeaways for IWMS buyers in 2017 and beyond


The Verdantix benchmark of Integrated Workplace Management Systems (IWMS) has been released following a six-month research process. The benchmark assesses 14 vendors and their platforms on 71 criteria spanning real estate portfolio management through to maintenance management and 40 criteria relating to vendor success factors such as number of deployments and product strategy.

As part of the research, Verdantix interviewed a panel of 19 real estate and facilities management directors who select, implement and use software. What are the key takeaways for customers looking to invest in real estate and facilities management applications or to rationalize real estate IT with an IWMS platform?

Firstly, buyers looking to replace a roster of legacy and outdated systems with an IWMS have lots of choices. In our benchmark, seven vendors made it into the Leaders’ Quadrant: Accruent, ARCHIBUS, FM:Systems, IBM (TRIRIGA), MCS Solutions, Planon and Trimble (Manhattan), as they demonstrated an excellent breadth of functionality and strong market momentum…

[Admin: This post is related to the 08.01.16 post about the competitors of IBM TRIRIGA, and the 08.22.17 post by Verdantix about IWMS competition intensifying. To see other related posts, use the Verdantix tag.]

Continue reading

What are three ways to gain from technology advances in TRIRIGA?


Around the world, changes to the way we manage and measure facilities performance continue to place an onus on real estate executives. They must understand their holdings, and make more strategic decisions with regard to their overall portfolio. These decisions are influenced by many factors, particularly the impact of leases on the balance sheet and operations and maintenance costs. IBM continues to invest in our intelligent buildings platform, IBM TRIRIGA, to help our clients tackle the various changes occurring…

IBM TRIRIGA helps reduce the effort to meet new leasing standards

We want to help organizations comply with the new standards and understand the implications of these changes. IBM TRIRIGA supports the complete lifecycle of facilities management and will automate compliance activities to address changes that affect multiple teams and roles…

IBM TRIRIGA helps improve occupancy experience

There are also new capabilities to improve day-to-day and occupancy experience. Organizations can leverage a new Workplace Services offering that engages every-day employees through new mobile web apps that provide access to services managed by IBM TRIRIGA, anywhere, and on any device…

IBM TRIRIGA provides a new design to better engage users

Decisions are only as good as the data that supports them. Optimizing native data sets and interfaces, and managing the process of collecting and contextualizing external data, is critical. New capabilities focus on enhancing the IBM TRIRIGA Application Platform. This is the foundation for the various views and capabilities of the IBM TRIRIGA suite…

Continue reading

Verdantix: Can predictive analytics work in commercial real estate?


Improving maintenance procedures through predictive analytics has recently seen many notable developments. Siemens is integrating IBM Watson Analytics into its MindSphere platform to help implement predictive maintenance schemes. Rockwell Automation recently launched its predictive analytics capability for factories and machinery. And PTC and Deloitte Digital announced that they are jointly developing predictive maintenance solutions for factory operations.

These developments are hardly surprising. Predictive analytics enables users to detect if, and when, machinery is likely to breakdown. For example, predictive analytics enabled Duke Energy to identify a slight increase in the turbine vibration of a steam turbine – after maintenance was performed. The subsequent repairs resulted in $4.1 million of potential power generation loss being prevented. Facility managers at plants and factories are therefore likely to be looking for such solutions to keep things running.

But is predictive analytics a natural sell in the world of commercial real estate? There is certainly some evidence of this. Since 2009, UK-based retailer Sainsbury’s has used software provider Verisae’s (now part of Accruent) predictive maintenance solution to reduce product loss from refrigeration failures. Since 2016, engineering firm KONE has partnered with IBM Watson to embed intelligent analytics in its elevators and escalators to improve their performance and reduce instances of unplanned maintenance.

Nevertheless, such examples are not necessarily the norm. According to our 2016 Global Energy Leaders Survey, 46% of the 250 facility managers surveyed said improving the collection, analysis and reporting of energy data from their electrical assets is a very important priority. In contrast, more granular asset-level energy management was only considered very important by 22%. And in our 2015 Green Quadrant for Building Energy Management Software, only 18% of the customer panel we interviewed considered maintenance scheduling and predictive maintenance to be a very important asset management functionality.

The average facility manager is therefore more likely to be concerned with basic data capture than advanced solutions like predictive analytics…

[Admin: This post is related to the 07.13.17 post and 03.16.17 post about IBM Watson Analytics, and the 08.01.16 post about the competitors of IBM TRIRIGA. To see other related posts, use the Verdantix tag.]

Continue reading