KScope Accelatis - Black & Decker Presentation: KPI, Triggers, & Health Check
Part II of our co-presentation with Black & Decker at KScope 2017. We discuss KPI, triggers, and health checks in Hyperion using Accelatis software, a company recently acquired by Datavail.
Speaker 1: This chart shows some of the KPI features that we’re using. I won’t go through all of these, but it just shows things that we’re monitoring, or data that we’re capturing. And then our actions on the right show we can set triggers in Accelatis just so that we get notifications if we reach a certain threshold.
If you look at an example on the bottom for HFM, we’re tracking the task and data audit logs to make sure that those don’t get too big. This slide shows an example of those triggers or the emails that we get from Accelatis. My self and some of the other admins will get an email saying that the audit log reached a certain threshold, we need to go in and archive it. Then we run through our process that does that. It’s really nice that we get these during the close or whenever. It’s good and bad because you can get nervous when you start seeing them, but you can be proactive about doing what you need to do to minimize any impact on the users.
Speaker 2: There is an opportunity that we haven’t discussed, though, is that you can take that trigger and then tie it to an automation drop to actually do the archiving. So, it depends on your internal process. Some of the value is a trigger could kick off an automation job that could remediate the problem. And it just depends on what your internal processes are and whether you want to handle it annually or you want the system to do some of it for you. But a lot of these things can be connected pretty easily depending on and how far you want to go.
Speaker 1: This is one of our real life examples of how we use the health checks to troubleshoot an issue. We had several HFM users reporting slowness and poor response time. A lot of times you’ll get an email, “Hey, HFM is slow”. It’s like, okay, can you give me a little more detail, but when we start seeing multiple users saying that, okay we need to go check something out, we run right to Accelatis.
As an administrator, I try logging into HFM. I can get in, but I can’t navigate to system messages, so even I’m having issues. I have access to everything. So, we ran the health checks and the results of that are up here showing that the user simulation feature generated a failure and it also showed lengthy response times, not what we would normally see. The activity analysis feature showed that HFM was having issues with a specific sequel table related to HFM.
From there, we go to our DBA and the DBA found dead locks on the HFM data audit table. As an admin, when I couldn’t get into the system messages or the audit logs, that’s why there was a dead lock on the table. Then I wasn’t able to even get back into the application. Then we performed a restart. We stopped services, and rebooted, and everything came back okay. We logged in [inaudible 00:03:12] Oracle on the specifics of the dead lock on the table and We were able to provide them with all the logs and everything that they needed. It just shows how Accelatis helped us get right to the root of the area and how Oracle … we were able to quickly provide Oracle with what they needed so they could research it.