6 Replies Latest reply on Apr 25, 2019 11:52 AM by 3886165

    Monitoring HFM Task Flows using Java API or using JHAT utility

    3886165
    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

      • 126 Views
      • Tags:
        • 1. Re: Monitoring HFM Task Flows using Java API or using JHAT utility
          Tanya Heise -Oracle
          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.

          • 2. Re: Monitoring HFM Task Flows using Java API or using JHAT utility
            KamilaP-Oracle
            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

            • 3. Re: Monitoring HFM Task Flows using Java API or using JHAT utility
              3886165
              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

              • 4. Re: Monitoring HFM Task Flows using Java API or using JHAT utility
                3886165
                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

                • 5. Re: Monitoring HFM Task Flows using Java API or using JHAT utility
                  Tanya Heise -Oracle
                  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,

                  • 6. Re: Monitoring HFM Task Flows using Java API or using JHAT utility
                    3886165
                    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.