0 Replies Latest reply: Aug 20, 2013 10:29 AM by Don'Tknow999-Oracle RSS

    Taking exactly 10 min to open the task list using smartview

    Don'Tknow999-Oracle

      Hi All,

       

      We are using hyperion smartview 11.1.2.2

       

      when I connect to hyperion planning task list using smartview it is taking exactly 10 min to open the task but the same is taking only 3 seconds in our Production environment. Can someone help me out.

       

      I have also followed the below but it did not help me out.

       

      It might be that APS is timing out, I assume you are running OHS

      if so stop OHS, go to <MIDDLEWARE_HOME>\user_projects\<instance_name>\httpConfig\ohs\config\OHS\ohs_component

      edit mod_wl_ohs.conf

       

      In there you will see something like

       

      < LocationMatch ^/aps>

      SetHandler weblogic-handler

      WeblogicCluster <APS_SERVER>:13080

      < /LocationMatch>

       

      add

       

      WLIOTimeoutSecs 3600

       

      so it looks like

       

      < LocationMatch ^/aps>

      SetHandler weblogic-handler

      WeblogicCluster <APS_SERVER>:13080

      WLIOTimeoutSecs 3600

      < /LocationMatch>

       

      Save, start OHS and try again.

       

       

       

      Below is our planning0.log

       

      SUBSYSTEM = HTTP USERID = <WLS Kernel> SEVERITY = Error THREAD = [ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)' MSGID = BEA-101017 MACHINE =   CONTEXTID = 0000K2RgbvYCsl95nfp2iZ1I4pUX00000x TIMESTAMP = 1377001701090 
      WatchAlarmType: AutomaticReset
      WatchAlarmResetPeriod: 30000
      >
      ####<Aug 20, 2013 8:28:21 AM EDT> <Warning> <HTTP>  <Planning0> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000K2RgbvYCsl95nfp2iZ1I4pUX00000x> <1377001701106> <BEA-101138> <ServletContext@30584151[app:PLANNING module:HyperionPlanning path:/HyperionPlanning spec-version:2.5 version:11.1.2.0] One of the getParameter family of methods called after reading from the ServletInputStream. Not merging post parameters.>
      ####<Aug 20, 2013 8:28:21 AM EDT> <Info> <WorkManager> <AMIWSP01> <Planning0> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000K2RgbvYCsl95nfp2iZ1I4pUX00000x> <1377001701106> <BEA-002936> <maximum thread constraint WatchManagerEvents is reached>
      ####<Aug 20, 2013 8:28:22 AM EDT> <Alert> <Diagnostics>  <Planning0> <oracle.dfw.impl.incident.DiagnosticsDataExtractorImpl - Incident Dump Executor (created: Tue Aug 20 08:28:21 EDT 2013)> <<WLS Kernel>> <> <> <1377001702028> <BEA-320016> <Creating diagnostic image in C:\Oracle\Middleware\user_projects\domains\AMIHYPRD\servers\Planning0\adr\diag\ofm\amihyprd\planning0\incident\incdir_69426 with a lockout minute period of 1.>
      ####<Aug 20, 2013 8:39:11 AM EDT> <Error> <WebLogicServer> <Planning0> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1377002351544> <BEA-000337> <[STUCK] ExecuteThread: '28' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "635" seconds working on the request "Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 635907 ms
      [
      POST /HyperionPlanning/SmartView HTTP/1.1
      Accept: */*
      Accept-Language: en-US
      Accept-Encoding: gzip
      ORA_EPM_SVCLIENT_CLIENTIP: 10.101.6.194
      ORA_EPM_SVCLIENT_EXTENSIONS: b78f60ca-e18b-401d-a10f-626c0118daf2;AF52322C-D60B-41f1-A8C8-0C299FBB0AA4
      Content-Encoding: gzip
      User-Agent: HttpApp/1.0
      Content-Length: 212
      Cache-Control: no-cache
      Cookie: JSESSIONID=DtdJSTgFpg67nJ2wvxKncMtlvKFJvZn9Q5Ljj0y4t5nZGkDRbsvN!165491247; ORA_EPMWS_User=admin; ORA_EPMWS_AccessibilityMode=false; ORA_EPMWS_ThemeSelection=BpmTadpole
      Connection: Keep-Alive
      X-Forwarded-For: 10.101.6.194
      Proxy-Client-IP: 10.101.6.194
      X-WebLogic-KeepAliveSecs: 30
      X-WebLogic-Force-JVMID: 165491247

      ]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
      Thread-203 "[STUCK] ExecuteThread: '28' for queue: 'weblogic.kernel.Default (self-tuning)'" <alive, in native, suspended, priority=1, DAEMON> {
          com.hyperion.planning.olap.HspEssbaseMainAPI.EssGetCalcList(HspEssbaseMainAPI.java:???)
          com.hyperion.planning.olap.HspEssConnection.essGetCalcList(HspEssConnection.java:306)