2 Replies Latest reply on Mar 2, 2012 1:12 AM by 916285

    ERPI data load error

    916285
      Hello,
      We are loading one month data from peoplesoft to planning application using ERPI 11.1.2.1. It takes about 1 hrs to load one month data.Is it normal? When looking at ODI PS_GL_LOAD_BALANCES_DATA is always successful but COMM_LOAD_BALANCES fails at the end with this error.Did anyone have this error before. Message in HyS9aifWeb-sysout file is:


      FROM AIF_HS_BALANCES
      WHERE LOADID = 132
      [EssbaseRuleFile] Locking rules file AIFData
      [EssbaseRuleFile] Successfully locked rules file AIFData
      [EssbaseRuleFile] Copying rules file OWBPLAND for data load as AIFData
      [EssbaseRuleFile] Unlocking rules file AIFData
      [EssbaseRuleFile] Successfully unlocked rules file AIFData
      [EssbaseRuleFile] The data rules file has been created successfully.
      [EssbaseRuleFile] Locking rules file AIFData
      [EssbaseRuleFile] Successfully locked rules file AIFData
      [EssbaseRuleFile] Load data into the cube by launching rules file...
      <Mar 1, 2012 1:09:30 PM PST> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "625" seconds working on the request "weblogic.servlet.internal.ServletRequestImpl@3bc2189[
      POST /aif/services/HPLService HTTP/1.1
      Content-type: text/xml;charset="utf-8"
      Accept: text/xml, multipart/related, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
      Soapaction: "http://DEVAPPHPN001.indymacdev.biz:19000/aif/services/HPLServiceexecuteDataLoad"
      User-Agent: JAX-WS RI 2.1.7-b01-
      Content-Length: 638
      Connection: Keep-Alive
      Proxy-Client-IP: 10.205.101.108
      X-Forwarded-For: 10.205.101.108
      X-WebLogic-KeepAliveSecs: 30
      X-WebLogic-Force-JVMID: 2124105652

      ]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
      Thread-176 "[STUCK] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'" <alive, suspended, priority=1, DAEMON> {
      jrockit.net.SocketNativeIO.readBytesPinned(SocketNativeIO.java:???)
      jrockit.net.SocketNativeIO.socketRead(SocketNativeIO.java:24)
      java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)
      java.net.SocketInputStream.read(SocketInputStream.java:107)
      com.essbase.services.olap.main.main_direct.EssNetClient.readFrom(Unknown Source)
      com.essbase.services.olap.main.main_direct.EssNetClient.readPackage(Unknown Source)
      com.essbase.services.olap.main.main_direct.EssNetClient.receiveResponse2(Unknown Source)
      com.essbase.services.olap.main.main_direct.EssNetClient.adNetReceiveResponse(Unknown Source)
      com.essbase.services.olap.main.main_direct.EssAPIData._adImport(Unknown Source)
      com.essbase.services.olap.main.main_direct.EssAPIData.ImportToEssbaseASO(Unknown Source)
      com.essbase.services.olap.main.main_direct.EssMAPIDir.BeginDataload(Unknown Source)
      com.essbase.server.framework.EssOlapMainService.BeginDataload(Unknown Source)
      com.essbase.server.framework.EssOrbPluginDirect.essMainBeginDataload(Unknown Source)
      com.essbase.api.session.EssOrbPlugin._invokeMainMethod(Unknown Source)
      com.essbase.api.session.EssOrbPlugin._invokeMethod2(Unknown Source)
      com.essbase.api.session.EssOrbPlugin._invokeMethod(Unknown Source)
      com.essbase.server.framework.EssOrbPluginDirect._invokeProtected(Unknown Source)
      com.essbase.api.session.EssOrbPluginEmbedded.invokeMethod(Unknown Source)
      com.essbase.api.session.EssOrbPluginEmbedded.invokeMethod(Unknown Source)
      com.essbase.api.session.EssOrbPlugin.essMainBeginDataload(Unknown Source)
      com.essbase.api.datasource.EssCube.beginDataload(Unknown Source)
      com.hyperion.aif.essbase.EssbaseRuleFile.executeDataRuleFile(EssbaseRuleFile.java:314)
      com.hyperion.aif.webservices.HPLService.executeDataLoad(HPLService.java:167)
      sun.reflect.GeneratedMethodAccessor7310.invoke(Unknown Source)
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      java.lang.reflect.Method.invoke(Method.java:575)
      org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
      org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:71)
      org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:265)
      org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
      org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:113)
      org.apache.axis.SimpleChain.invoke(SimpleChain.java:78)
      org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:435)
      org.apache.axis.server.AxisServer.invoke(AxisServer.java:132)
      org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:586)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:700)
      org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:325)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:815)
      weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:224)
      weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:108)
      weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:206)
      weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:55)
      oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
      oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:299)
      oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:405)
      oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
      oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:98)
      oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:70)
      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:55)
      oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:86)
      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:55)
      weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:25)
      weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:55)
      weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3687)
      weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
      weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:308)
      weblogic.security.service.SecurityManager.runAs(SecurityManager.java:116)
      weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2213)
      weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2135)
      weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1420)
      weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      weblogic.work.ExecuteThread.run(ExecuteThread.java:168)



      Any feedback is appreciated.Thank you for taking ime to read through.
      Regards.
        • 1. Re: ERPI data load error
          WPaffhausen
          Hello,

          Part of the message you are getting is because the WebLogic process is a bit intuitive. It knows when something is running and waits. It also assumes anything running for a certain period of time is considered "stalled/stuck" and reports it. The time it waits is dependant on the Weblogic configuration.

          As for the time it takes to load data... that is very vague. Without knowing more about your environment that is very hard to state. We know nothing about the hardware, platform, dataset size, etc. You would need to review ODI to find out what is taking the long amount of time and try and replicate it outside of ERPi/ODI to see if you get the same results.

          Thank you,
          1 person found this helpful
          • 2. Re: ERPI data load error
            916285
            Hello,
            Thank you for the feedback.Can you please share your ideas on how much approx time should it be to load following dataset.
            Dataset size=704722 (KB)
            Data Rows=878889
            Platform= Microsoft Windows x64 (64-bit) 2008 R2
            Hyperion Essbase=11.1.2.1
            ODI=11.1.1.5.
            Database product = Microsoft SQL Server 2008
            (Traget) Hyperion Planning =11.1.2.1
            (Source)Peoplesoft financial 9.1


            I really appreciate your help.

            Best Wishes.