Forum Stats

  • 3,733,811 Users
  • 2,246,823 Discussions
  • 7,856,882 Comments

Discussions

Run Consolidation on HFM 11.2 using JHAT utility

User_RUHNJ
User_RUHNJ Member Posts: 51 Blue Ribbon

I am trying to use JHAT utility to run consolidations on my HFM 11.2 application. I have created setenv.cmd file and updated my jhat.bat accordingly. Then I have created TestConsol.txt file to pass the consolidation parameters. It looks like below


LEQ is the entity name. I get below errors when I run the jhat.bat


I doubt if there is a problem with the POV i am passing via txt file. I could not find a syntax to pass the consolidation variables. Can somebody help me on this?

Tagged:

Comments

  • Anand Thota
    Anand Thota Member Posts: 28 Red Ribbon

    Hi,

    Please try with below POV,

    Logon("false", "__Domain__", "__UserName__", "__Password__");

    OpenApplication("__Server__", "__App__");

    SetPOV("Scenario","Year", "Month", "<Scenario View>", "Entity", "<Entity Currency>", "Account", "[ICP Top]", "Custom1", "Custom2", "Custom3", "Custom4");

    Consolidate("AllWithData");

    CloseApplication();

    Logout();

    Please change the Scenario, entity, account and custom dimension members as per your requirement.

    Thanks,

    Anand Thota.

  • User_RUHNJ
    User_RUHNJ Member Posts: 51 Blue Ribbon

    Thanks Anand for responding. I tried passing POV in suggested format. Still I am receiving below null point exception error. I am created setenv.cmd file on the HFM server.


    D:\Oracle\Middleware\EPMSystem11R1\..\jdk1.8.0_181\bin\java.exe -client -cp ;D:\Oracle\Middleware\EPMSystem11R1\..\oracle_common\modules\oracle.webservices_11.1.1\wsclient.jar;D:\Oracle\Middleware\EPMSystem11R1\..\oracle_common\modules\oracle.jrf_11.1.1\jrf.jar;D:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Server\jhat.jar;D:\Oracle\Middleware\EPMSystem11R1\common\jlib\11.1.2.0\epm_j2se.jar;D:\Oracle\Middleware\EPMSystem11R1\common\jlib\11.1.2.0\epm_hfm_web.jar -D"EPM_ORACLE_INSTANCE=D:\Oracle\Middleware\user_projects\epmsystem1" -D"java.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration" -D"oracle.core.ojdl.logging.config.file=D:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Server\jhat_logging.xml" -D"logging.folder=D:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\jhat" -D"org.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger" oracle.epm.fm.jhat.JHATMain -ID:\JHAT\29Mar21T1.txt

    java.lang.NullPointerException

    at oracle.epm.fm.jhat.ProcessFile.readFileAndExecute(ProcessFile.java:76)

    at oracle.epm.fm.jhat.JHATMain.main(JHATMain.java:30)

    java.lang.NullPointerException

    at oracle.epm.fm.jhat.ProcessFile.readFileAndExecute(ProcessFile.java:119)

    at oracle.epm.fm.jhat.JHATMain.main(JHATMain.java:30)

  • User_RUHNJ
    User_RUHNJ Member Posts: 51 Blue Ribbon
    edited March 30

    Thanks Anand. Issue was resolved for me after enclosing the file name in quotes when running the JHAT command.

    i.e., jhat.bat -I”D:\JHAT\hfmconsolcommand.txt” -O”D:\JHAT\hfmconsolcommand.log”

  • Anand Thota
    Anand Thota Member Posts: 28 Red Ribbon

    can you confirm, which POV syntax you are using ?

    you can close the discussion, if everything is okay .


    Thanks,

    Anand Thota

  • User_RUHNJ
    User_RUHNJ Member Posts: 51 Blue Ribbon

    Logon("false", "", "admin", "password1" );

    OpenApplication("HFMCluster", "TestApp");

    SetPOV("Actual", "2020", "Oct", "<Scenario View>", "LEQ", "<Entity Currency>", "A1011", "[ICP None]", "[None]", "[None]", "[None]", "[None]");

    Consolidate("Impacted");

    CloseApplication();

    Logout();


    POV order -Scenario, Year, Period, View, Entity, Account, ICP, C1, C2, C3, C4


    Regarding closing the discussion I do not see an option for that.

  • Anand Thota
    Anand Thota Member Posts: 28 Red Ribbon

    i think you can mark as solution accepted.


    Thanks,

    Anand Thota

Sign In or Register to comment.