2 Replies Latest reply on Oct 9, 2015 9:42 AM by Francisco Amores

    Using ActionsService web service to load account data

    2837182

      Hi,

      We are looking to automate loading the accounts data to an EPM-HFM Application.

      We wre able to load it through the front-end.Regarding automation,we were able to configure the OWSM policies for the web service,create the native user in weblogic console and import and use the public key to web service client proxy.

       

      The URL of the wsdl we are calling is http://192.168.50.21:7363/oracle-epm-fm-webservices/ActionsService?wsdl

      The method we are trying to invoke is iActionsService.loadData("clustername", "Application name", "E:\\testpad\\Hyperion\\data\\DATA.txt", null, ",", DataLoadMode.MERGE, false, false);

      The errors as below are found at the log file immediately after running.Please help us in finding what need to be done in fixing these errors.Are we passing the right params to the web service?

      Do we still need to make any other changes at weblogic/em to get this to work?Please suggest.

       

      Oracle EPM -Fusion Edition

      version - 11.1.2.4.0.79

       

      Thanks and regards,

      Guna

       

      From the logs we find that

      we could be able to login to the application -  Session is created with Session id : 5e95de6f-e828-4121-8765-36c186e72355

      An unexpected error has occurred -

      oracle.epm.fm.common.exception.HFMException: EPMHFM-65536: An unexpected error has occurred.

      at oracle.epm.fm.common.exception.ExceptionHelper.handleException(ExceptionHelper.java:45)

      at oracle.epm.fm.domainobject.loadextract.LoadExtractOM.loadData(LoadExtractOM.java:281)

       

      AN EPMHFM-65925 error has occurred

      java.lang.NullPointerException

      at org.apache.thrift.protocol.TCompactProtocol.writeString(TCompactProtocol.java:325)

      at oracle.epm.fm.thrift.protocol.TMultiplexedProtocol.writeString(TMultiplexedProtocol.java:112)

      at oracle.epm.fm.common.service.loadextract.LoadExtractHandlerService$loadData_args$loadData_argsStandardScheme.write(LoadExtractHandlerService.java:10236)

      at oracle.epm.fm.common.service.loadextract.LoadExtractHandlerService$loadData_args$loadData_argsStandardScheme.write(LoadExtractHandlerService.java:10152)

      at oracle.epm.fm.common.service.loadextract.LoadExtractHandlerService$loadData_args.write(LoadExtractHandlerService.java:10087)

      at org.apache.thrift.TServiceClient.sendBase(TServiceClient.java:63)

      at oracle.epm.fm.common.service.loadextract.LoadExtractHandlerService$Client.send_loadData(LoadExtractHandlerService.java:639)

      at oracle.epm.fm.common.service.loadextract.LoadExtractHandlerService$Client.loadData(LoadExtractHandlerService.java:629)

      at oracle.epm.fm.domainobject.loadextract.LoadExtractOM.loadData(LoadExtractOM.java:269)

      at oracle.epm.fm.actions.LoadDataAction.execute(LoadDataAction.java:100)

      at oracle.epm.webservices.fm.ActionsService.LoadData(ActionsService.java:315)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

       

      Message was edited by: 2837182