7 Replies Latest reply on Jul 22, 2019 1:50 AM by 3592567

Monitoring HFM Task Flows using Java API or using JHAT utility

3886165 Apr 23, 2019 11:03 PM

Hello Gurus,

Is it possible to monitor the HFM Task flows - (how much volume of data, why it takes longer etc) using java api or using the JHAT utility? If so, can you please let me know how can I achieve this?

While we are on the latest release of the HFM task flows, the issue we are facing is that some of the taskflows are taking longer to complete than their expected time. Sometimes the task flow doesn't start at their scheduled time. After a restart it starts working as expected for some time and then stops getting executed at the scheduled time.

PS. We are currently on EPM 11.1.2.4 version

Regards,

Saurabh

Message was edited by: 3886165

1. Re: Monitoring HFM Task Flows using Java API or using JHAT utility

Tanya Heise -Oracle Apr 24, 2019 5:37 PM (in response to 3886165)
Hello;

What is the exact HFM version that you are on? You mention you're on 11.1.2.4; but are you on the latest patch set update? Please confirm the exact patch you're on.

“Task Flows” are Foundation jobs that are submitted to HFM: consolidations, data loads, data extracts. Have you reviewed the HFM ODL logs to see what each HFM application and Server is doing? This is the only way to tell what each is doing…For example:
Are the servers tuned correctly?
Is the database tuned?
Are the HFM server virtual and are the running on dedicate or shared VM Hosts?
Are you running other tasks at the same time?
Is the application’s rule written efficiently?

Regarding JHAT, I reached out to one of our senior technical specialists; and he confirmed that JHAT is not support outside or Oracle QE/Development.

HFM JAVA API does not “monitor” ; It just allows users to write custom code.

Are you also using Planning?

Any other comments are welcome.

Thank you.
Like Show 1 Likes(1)

Actions
2. Re: Monitoring HFM Task Flows using Java API or using JHAT utility

KamilaP-Oracle Apr 24, 2019 6:02 PM (in response to 3886165)

Hello,
There is known issue where HFM taskflows are not always running at scheduled time when there is a Planning component in the EPM System.
Do you have Planning? If so please implement the solution in the following document:
HFM Application Taskflow Will Not Run In All The Scheduled Time And Some Of Them Will Be Skipped (Doc ID 2425368.1)

Hope this help
Regards,
Kamila
Like Show 1 Likes(1)

Actions
3. Re: Monitoring HFM Task Flows using Java API or using JHAT utility

3886165 Apr 25, 2019 2:08 AM (in response to KamilaP-Oracle)

Thank you for your reply.

Steps listed in the doc has already been configured. Still the same issue.

Regards,Saurabh
Like Show 0 Likes(0)

Actions
4. Re: Monitoring HFM Task Flows using Java API or using JHAT utility

3886165 Apr 25, 2019 2:13 AM (in response to Tanya Heise -Oracle)
We are on the latest Shared Service, Planning and HFM PSU in our environment.

Are the servers tuned correctly? Yes
Is the database tuned? Yes
Are the HFM server virtual and are the running on dedicate or shared VM Hosts? Virtual Servers
Are you running other tasks at the same time? Yes, there are times when the tasks are overlapping.
Is the application’s rule written efficiently? I am not sure if I know this but after the service restart all the tasks run as expected.

That's fine but what I am curious to know is if JHAT has the functionality to achieve the task-flow functionality? Since this can be scheduled in windows it is easier to manage than the inbuilt scheduling options for taskflow which are very limited.

Are you saying there's no way to clearly monitor to find out the reason as to why some of the taskflows didn't run as per their schedule?

Regards,
Saurabh
Like Show 0 Likes(0)

Actions
5. Re: Monitoring HFM Task Flows using Java API or using JHAT utility

Tanya Heise -Oracle Apr 25, 2019 11:35 AM (in response to 3886165)

Without reviewing the logs and seeing the tasks being run, etc, it is difficult to confirm or provide a cause as to why this is happening.

if you are experiencing issues with this, you may want to consider opening a ticket with Support and have them review the logs; etc.

Thank you,
Like Show 1 Likes(1)

Actions
6. Re: Monitoring HFM Task Flows using Java API or using JHAT utility

3886165 Apr 25, 2019 11:52 AM (in response to Tanya Heise -Oracle)

SR is already open for the taskflow issue. This discussion was only to understand the possibility of using JHat utility to achieve what HFM task-flows achieve.
Like Show 0 Likes(0)

Actions
7. Re: Monitoring HFM Task Flows using Java API or using JHAT utility

3592567 Jul 22, 2019 1:50 AM (in response to 3886165)

Hi, is it however possible to use the Java api and write a program to get the taskflow status? as to whether each stage has passed or failed?
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.