What is the exact HFM version that you are on? You mention you're on 220.127.116.11; 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.
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
Thank you for your reply.
Steps listed in the doc has already been configured. Still the same issue.
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?
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.
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.