7 Replies Latest reply: Jul 7, 2014 6:51 AM by user10646442 RSS

    Calculation Manager is taking lot of time to open after applying .500 Patch

    user10646442

      Hi All,

       

      We have our EPM Environment in windows 2008 Server and have recently applied .500 Patch and all the components are working fine except Calculation Manager and when i login into workspace and open the calc Mgr its taking lot of time (8-10 Min)  to open and after which i get an error as  " There was an error retrieving the list of classic applications. Please see the Calculation manager log file for more information.

       

      I have checked the CalcMgr0.log but i don't see any error there.

       

      1) How can open the calc mgr fast without taking much time as the client is not accepting as its taking lot of time to open.

      2) How i can see to it that i don't get the above error.

       

       

      You can see the  screenshot of the above error  in my blog:

       

      http://hyperion-consulting.blogspot.in

       

       

      Regards,

      VJ

        • 1. Re: Calculation Manager is taking lot of time to open after applying .500 Patch
          KKT

          Have a look at the metalink.

           

          Calculation Manager Error "There was an Error in Retrieving List of Classic Applications. Please See the Calc Manager Log file for More Information" (Doc ID 1668344.1)


          Thanks,

          ~KKT~

          • 2. Re: Calculation Manager is taking lot of time to open after applying .500 Patch
            user10646442

            Hi,

             

            Thanks for the  reply. I have gone through the document and in our case we have ASP installed. you can also the screenshot of the same in my blog.

             

            http://hyperion-consulting.blogspot.in

            • 3. Re: Calculation Manager is taking lot of time to open after applying .500 Patch
              user10646442

              Hi,

               

              What i observed is that there is an error in HyS9CALC_amiwsd05-syserr.log

               

              WARNING: Error parsing:file:/C:/Oracle/Middleware/user_projects/domains/AMIHYSBX/servers/CalcMgr0/tmp/servers/CalcMgr0/tmp/_WL_user/CALC_11.1.2.0/eye60v/adf/META-INF/services/oracle.adf.view.rich.context.DirtyPageHandler

              Jul 7, 2014 1:06:56 AM org.apache.myfaces.trinidad.util.ClassLoaderUtils _getServices

              WARNING:

              java.lang.ClassNotFoundException: com.hyperion.calcmgr.adf.view.common.frmwkext.CalcMgrDirtyPageHandler

                at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:297)

                at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:270)

                at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:64)

                at java.lang.ClassLoader.loadClass(ClassLoader.java:306)

                at java.lang.ClassLoader.loadClass(ClassLoader.java:247)

                at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:179)

                at weblogic.utils.classloaders.ChangeAwareClassLoader.loadClass(ChangeAwareClassLoader.java:43)

                at org.apache.myfaces.trinidad.util.ClassLoaderUtils._newInstance(ClassLoaderUtils.java:376)

                at org.apache.myfaces.trinidad.util.ClassLoaderUtils._getServices(ClassLoaderUtils.java:316)

                at org.apache.myfaces.trinidad.util.ClassLoaderUtils.getServices(ClassLoaderUtils.java:281)

                at oracle.adfinternal.view.faces.context.AdfFacesContextImpl._loadDirtyPageHandler(AdfFacesContextImpl.java:894)

                at oracle.adfinternal.view.faces.context.AdfFacesContextImpl.getDirtyPageHandler(AdfFacesContextImpl.java:179)

                at oracle.adfinternal.view.faces.renderkit.rich.DocumentRenderer._getUncommittedDataWarning(DocumentRenderer.java:1731)

                at oracle.adfinternal.view.faces.renderkit.rich.DocumentRenderer.encodeAll(DocumentRenderer.java:904)

                at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1436)

                at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)

                at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:858)

                at javax.faces.component.UIComponent.encodeAll(UIComponent.java:938)

                at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)

                at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:267)

                at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)

                at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:191)

                at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:193)

               

               

              Jul 7, 2014 1:06:57 AM org.apache.myfaces.trinidadinternal.skin.SkinCSSDocumentHandler _parseAgentProperties

              WARNING: Not a valid @agent CSS property rule: max-version: 1.9.2

              Jul 7, 2014 1:06:57 AM org.apache.myfaces.trinidadinternal.skin.SkinCSSDocumentHandler _parseAgentProperties

              WARNING: Not a valid @agent CSS property rule: max-version: 532

              Jul 7, 2014 1:07:00 AM oracle.adfinternal.controller.metadata.model.xml.ValueMappingXmlImpl parse

              WARNING: ADFc: /WEB-INF/taskflow/cmviews/taskflow-def/CMViewsBTF-def.xml#CMViewsBTF-def:

              Jul 7, 2014 1:07:00 AM oracle.adfinternal.controller.metadata.model.xml.ValueMappingXmlImpl parse

              WARNING: ADFc: Failed to parse task flow call value mapping; name='productName'; value='null'.

              Jul 7, 2014 1:07:01 AM UNEXPECTED_CLIENT_OBJECT_TYPE oracle.adf.controller.internal.metadata.xml.MetadataResourceXmlImpl

              SEVERE: oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl

              Jul 7, 2014 1:07:01 AM UNEXPECTED_CLIENT_OBJECT_TYPE oracle.adf.controller.internal.metadata.xml.MetadataResourceXmlImpl

              SEVERE: oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl

              Jul 7, 2014 1:07:01 AM oracle.adf.controller.internal.metadata.xml.ValueMappingXmlImpl parse

              WARNING: ADFc: /WEB-INF/taskflow/cmviews/taskflow-def/CMViewsBTF-def.xml#CMViewsBTF-def:

              Jul 7, 2014 1:07:01 AM oracle.adf.controller.internal.metadata.xml.ValueMappingXmlImpl parse

              WARNING: ADFc: Failed to parse task flow call value mapping; name='productName'; value='null'.

              Jul 7, 2014 1:07:14 AM com.hyperion.bpm.web.common.BaseService <init>

              INFO: BaseService() - start

              Jul 7, 2014 1:07:14 AM com.hyperion.bpm.web.common.BaseService <init>

              INFO: BaseService() - end

              INFO: createService(ServiceType) The URL of the webservices is http://AMIWSD05.mycmsc.com:19000/hyperion-bpma-server/Sessions.asmx

              INFO: The Webservices timeout is set to : 600000ms

              INFO: createService(ServiceType) - end

              INFO: Registered auditor for componentType=WebServices auditor=oracle.security.jps.internal.audit.DelegateAuditor$XmlAuditor@30e234a2

              INFO: WSM-02316 The OWSM Policy Manager Application is not installed and the OWSM Agent is also not configured to use a remote OWSM Policy Manager. Hence OWSM security will be disabled.

              INFO: createService(ServiceType) The URL of the webservices is http://AMIWSD05.mycmsc.com:19000/hyperion-bpma-server/Libraries.asmx

              INFO: The Webservices timeout is set to : 600000ms

              INFO: createService(ServiceType) - end

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.epma.DimensionServerService.getService 8799

              INFO: createService(ServiceType) The URL of the webservices is http://AMIWSD05.mycmsc.com:19000/hyperion-bpma-server/Applications.asmx

              INFO: The Webservices timeout is set to : 600000ms

              INFO: createService(ServiceType) - end

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.epma.DimensionServerService.enumApplications 3058

              INFO: BaseService() - start

              INFO: BaseService() - end

              INFO: createService(ServiceType) The URL of the webservices is http://AMIWSD05.mycmsc.com:19000/hyperion-bpma-server/ObjectRepository.asmx

              INFO: The Webservices timeout is set to : 600000ms

              INFO: createService(ServiceType) - end

              INFO: BaseService() - start

              INFO: BaseService() - end

              WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.

              INFO: Product URL for application 'AMIPLN': http://AMIWSD05.mycmsc.com:19000/HyperionPlanning/servlet/HspAppManagerServlet?appname=AMIPLN

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.epma.DimensionServerService.getDeployedUrl 6911

              INFO: BaseService() - start

              INFO: BaseService() - end

              INFO: createService(ServiceType) The URL of the webservices is http://AMIWSD05.mycmsc.com:19000/hyperion-bpma-server/Properties.asmx

              INFO: The Webservices timeout is set to : 600000ms

              INFO: createService(ServiceType) - end

              INFO: MultiCurrency=False

              INFO: PlanningAppType=GENERAL

              INFO: WorkforceDeployed=False

              INFO: CapexDeployed=False

              INFO: PSBWorkforceModel=

              INFO: ProjectDeployed=False

              INFO: BaseService() - start

              INFO: BaseService() - end

              WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.

              INFO: Product URL for application 'AMIROI': http://AMIWSD05.mycmsc.com:19000/HyperionPlanning/servlet/HspAppManagerServlet?appname=AMIROI

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.epma.DimensionServerService.getDeployedUrl 234

              INFO: BaseService() - start

              INFO: BaseService() - end

              INFO: MultiCurrency=True

              INFO: PlanningAppType=GENERAL

              INFO: WorkforceDeployed=False

              INFO: CapexDeployed=False

              INFO: PSBWorkforceModel=

              INFO: ProjectDeployed=False

              INFO: BaseService() - start

              INFO: BaseService() - end

              WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.

              INFO: Product URL for application 'AMIPLAN': http://AMIWSD05.mycmsc.com:19000/HyperionPlanning/servlet/HspAppManagerServlet?appname=AMIPLAN

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.epma.DimensionServerService.getDeployedUrl 312

              INFO: BaseService() - start

              INFO: BaseService() - end

              INFO: MultiCurrency=True

              INFO: PlanningAppType=GENERAL

              INFO: WorkforceDeployed=False

              INFO: CapexDeployed=False

              INFO: PSBWorkforceModel=

              INFO: ProjectDeployed=False

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.epma.DimensionServerService.createApplications 9516

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.epma.DimensionServerService.getApplications 21388

              INFO: URL: http://AMIWSD05.mycmsc.com:19000/hfm/EIE/EIEListener.asp?action=calc_classic_getapplications&lang_id=en

              awb-sso-token=0VuonQJQlyhldwmusC2BEP1Hha1yd7Ll43WLHr291c%2B7pWWyG5tmW3vZSJohXIvUv1mOah6pho%2Bp1BlKHbu5cGiV5Lao%2FBdbwt78fM5G3bF%2BHvCttEbuMM2uCLPwg00%2F7ezw223e0y6sWn6Y3bNiqGjK1jFoJx14oJhspYgcG2PvBE5kj%2FvrRUGERfnwCQ7Uh%2BSooYr6CrG8r%2F44ElN9gPxh85XleSkTaTV63WFd5lZ2PEkOb0upCMBi5rkYwESzzReh8%2FkHcdKiEDhGzT6Tx%2BPqfcv8Lodq7r8LFJ8Vx6zM6914dslFMbt%2BPpHJMbhF9K2YLtl66GhjFyxHvyG7oLgfCks6rz5D%2BH0WBmHH506t9GymxKBLfYR%2Fgn4XwIpgb%2F%2B2xqy12PAvC7N7YxexuPdrkBbFDRzPl4kGIfVMbCDgYkEj8oKLEIvDYMJGwNDB

              HFM-VS-SC=26BEA87A_8975_47e3_8CD8_F77141A7EDBD

              Content-Typetext/html

              INFO: URL: http://AMIWSD05.mycmsc.com:19000/hfm/EIE/EIEListener.asp?action=calc_classic_getapplications&lang_id=en

              awb-sso-token=0VuonQJQlyhldwmusC2BEP1Hha1yd7Ll43WLHr291c%2B7pWWyG5tmW3vZSJohXIvUv1mOah6pho%2Bp1BlKHbu5cGiV5Lao%2FBdbwt78fM5G3bF%2BHvCttEbuMM2uCLPwg00%2F7ezw223e0y6sWn6Y3bNiqGjK1jFoJx14oJhspYgcG2PvBE5kj%2FvrRUGERfnwCQ7Uh%2BSooYr6CrG8r%2F44ElN9gPxh85XleSkTaTV63WFd5lZ2PEkOb0upCMBi5rkYwESzzReh8%2FkHcdKiEDhGzT6Tx%2BPqfcv8Lodq7r8LFJ8Vx6zM6914dslFMbt%2BPpHJMbhF9K2YLtl66GhjFyxHvyG7oLgfCks6rz5D%2BH0WBmHH506t9GymxKBLfYR%2Fgn4XwIpgb%2F%2B2xqy12PAvC7N7YxexuPdrkBbFDRzPl4kGIfVMbCDgYkEj8oKLEIvDYMJGwNDB

              HFM-VS-SC=26BEA87A_8975_47e3_8CD8_F77141A7EDBD

              Content-Typetext/html

              INFO: The custom error module does not recognize this error.

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.hfm.HFMProvider.getApplications 238493

              objType 14

              objType 14

              objType 14

              WARNING: Context menu child is not a RichMenu

              SEVERE: UNEXPECTED_CLIENT_OBJECT_TYPE ADFc: Unexpected metadata client object type.  Expected 'oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl' but found 'oracle.adf.controller.internal.metadata.xml.MetadataResourceXmlImpl'.

              SEVERE: UNEXPECTED_CLIENT_OBJECT_TYPE ADFc: Unexpected metadata client object type.  Expected 'oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl' but found 'oracle.adf.controller.internal.metadata.xml.MetadataResourceXmlImpl'.

              WARNING: ADFc: /WEB-INF/taskflow/cmviews/taskflow-def/CMViewsBTF-def.xml#CMViewsBTF-def:

              WARNING: PARSE_CALL_VALUE_FAILED ADFc: Failed to parse task flow call value mapping; name='productName'; value='null'.

              INFO: Global role for user: admin is ADMINISTRATOR

              INFO: BaseService() - start

              INFO: BaseService() - end

              INFO: select SETTINGS from CALCMGRUSERSETTINGS where USERID = ? and NAME = ?

              INFO: TARGET_COMPONENT_MISSING_CHANGE_FAILED

              SEVERE: oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl

              SEVERE: oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl

              WARNING: ADFc: /WEB-INF/taskflow/cmviews/taskflow-def/CMViewsBTF-def.xml#CMViewsBTF-def:

              WARNING: PARSE_CALL_VALUE_FAILED ADFc: Failed to parse task flow call value mapping; name='productName'; value='null'.

              objType 14

              objType 14

              objType 14

              WARNING: Context menu child is not a RichMenu

              INFO: Session locale for user 'admin' is: 'en'

              INFO: select SETTINGS from CALCMGRUSERSETTINGS where USERID = ? and NAME = ?

              INFO: select SETTINGS from CALCMGRUSERSETTINGS where USERID IS NULL and NAME = ?

              INFO: select SETTINGS from CALCMGRUSERSETTINGS where USERID = ? and NAME = ?

              WARNING: DMS-57008 The execution context put in place at the start of the request, 00iN2dwWV5NFw00Fzzw0w000026400008w,0:1, is not the execution context in place at the end of the request, 00iN2dtYdUNFw00Fzzw0w000026400008c,0:1:4. The request is as follows: Request URI:

                /calcmgr/modules/com/hyperion/calcmgr/web/filterview/Adf.do

              Request URL:

                http://amiwsd05:19000/calcmgr/modules/com/hyperion/calcmgr/web/filterview/Adf.do

              (No Query String)

              All Headers Names:

                Accept, Content-Type, Referer, Accept-Language, Accept-Encoding, User-Agent, Host, Content-Length, DNT, Cache-Control, Cookie, ECID-Context, Connection, X-Forwarded-For, Proxy-Client-IP, X-WebLogic-KeepAliveSecs, X-WebLogic-Force-JVMID

              Selected Header Values:

                ECID-Context : 1.00iN2dwWV5NFw00Fzzw0w000026400008w;kXjE1ZDLIPITj3POgJPRbIVBhVOPpSPPnVBOjTRBcPSS_ITQjURBZHORZTRPmVBT_IRBaPORoLQSqPPPrV9G^MQB^VO

                Accept-Language : en-US

                Host : amiwsd05:19000

                Content-Length : 1341

                Accept-Encoding : gzip, deflate

                Referer : http://amiwsd05:19000/workspace/index.jsp?framed=true

                User-Agent : Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)

                Connection : Keep-Alive

                Content-Type : application/x-www-form-urlencoded;charset=UTF-8

                Accept : */*

               

               

              INFO: Found existing JUApplicationDefImpl instance for calcmgrui.DataBindings.cpx

              SEVERE: UNEXPECTED_CLIENT_OBJECT_TYPE ADFc: Unexpected metadata client object type.  Expected 'oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl' but found 'oracle.adf.controller.internal.metadata.xml.MetadataResourceXmlImpl'.

              SEVERE: UNEXPECTED_CLIENT_OBJECT_TYPE ADFc: Unexpected metadata client object type.  Expected 'oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl' but found 'oracle.adf.controller.internal.metadata.xml.MetadataResourceXmlImpl'.

              WARNING: ADFc: /WEB-INF/taskflow/cmviews/taskflow-def/CMViewsBTF-def.xml#CMViewsBTF-def:

              WARNING: PARSE_CALL_VALUE_FAILED ADFc: Failed to parse task flow call value mapping; name='productName'; value='null'.

              SEVERE: oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl

              SEVERE: oracle.adfinternal.controller.metadata.model.xml.MetadataResourceXmlImpl

              WARNING: ADFc: /WEB-INF/taskflow/cmviews/taskflow-def/CMViewsBTF-def.xml#CMViewsBTF-def:

              WARNING: PARSE_CALL_VALUE_FAILED ADFc: Failed to parse task flow call value mapping; name='productName'; value='null'.

              INFO: URL: http://AMIWSD05.mycmsc.com:19000/hfm/EIE/EIEListener.asp?action=calc_classic_getapplications&lang_id=en

              awb-sso-token=gKzAmaz0WtcTguvDEuDhtxDVIniLAzKc6zkUWL%2BkItryTQViqQuSA%2Bzrc4HIx7QzeVpPL06xAqRVa4PVoTGJNsnxw6g16gY1mQVW5ZatDnLrlubKmuaapFVQdOR%2F4d9x3%2B%2FZUYd9h8THXILxiVHhUaFvp4knUO0gFb5LjiGnkihnqHVT7nFgdKVjOmdPyjdjYGFDP3GuRtfzJQRui1hUqnbjWQKgy2Tn9Fbo713Uac9W%2FKrtyUkJt7DwxLNqgbJJdQknOpEYMUfhdCHAOd4fOBcnS%2B6lLTNCreP1CXoVJqDx2V%2B%2Fr93by%2FES3RDdjseJ59CfEIa19cs%2F83%2FWEN7Uhcg54zvgCOuWebf%2FO1KhZNccDElq0NrvtIJjwNe0QHCfNDWikbpcKYLnfuXPOOdXCIKZ3cFDvUmHJRDP%2F5fEif5bz%2FrnT4Duropj1FiLJOzP

              HFM-VS-SC=26BEA87A_8975_47e3_8CD8_F77141A7EDBD

              Content-Typetext/html

              INFO: URL: http://AMIWSD05.mycmsc.com:19000/hfm/EIE/EIEListener.asp?action=calc_classic_getapplications&lang_id=en

              awb-sso-token=gKzAmaz0WtcTguvDEuDhtxDVIniLAzKc6zkUWL%2BkItryTQViqQuSA%2Bzrc4HIx7QzeVpPL06xAqRVa4PVoTGJNsnxw6g16gY1mQVW5ZatDnLrlubKmuaapFVQdOR%2F4d9x3%2B%2FZUYd9h8THXILxiVHhUaFvp4knUO0gFb5LjiGnkihnqHVT7nFgdKVjOmdPyjdjYGFDP3GuRtfzJQRui1hUqnbjWQKgy2Tn9Fbo713Uac9W%2FKrtyUkJt7DwxLNqgbJJdQknOpEYMUfhdCHAOd4fOBcnS%2B6lLTNCreP1CXoVJqDx2V%2B%2Fr93by%2FES3RDdjseJ59CfEIa19cs%2F83%2FWEN7Uhcg54zvgCOuWebf%2FO1KhZNccDElq0NrvtIJjwNe0QHCfNDWikbpcKYLnfuXPOOdXCIKZ3cFDvUmHJRDP%2F5fEif5bz%2FrnT4Duropj1FiLJOzP

              HFM-VS-SC=26BEA87A_8975_47e3_8CD8_F77141A7EDBD

              Content-Typetext/html

              INFO: The custom error module does not recognize this error.

              INFO: EPMCAL-00002 Exiting com.hyperion.calcmgr.provider.hfm.HFMProvider.getApplications 238789

              objType 14

              objType 14

              objType 14

              WARNING: Context menu child is not a RichMenu

              • 4. Re: Calculation Manager is taking lot of time to open after applying .500 Patch
                user10646442

                Hi,

                There were also some errors logged in HyS9Planning_amiwsd05-syserr.log.. Find below is the log file information.

                 

                 

                 

                 

                Jul 7, 2014 1:23:43 AM com.hyperion.planning.HspJSImpl <init>

                INFO: Planning application (AMIPLAN) successfully initialized.

                Jul 7, 2014 1:23:43 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:23:43 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:23:47 AM com.hyperion.planning.olap.HspEssbasePool createObject

                SEVERE: Cannot establish the OLAP connection: {0} .

                com.hyperion.planning.olap.EssbaseException (1030818)

                  at com.hyperion.planning.olap.HspEssbaseMainAPI.EssLogin(Native Method)

                  at com.hyperion.planning.olap.HspEssConnection.EssLoginWithAPSCheck(HspEssConnection.java:102)

                  at com.hyperion.planning.olap.HspEssConnection.connect(HspEssConnection.java:125)

                  at com.hyperion.planning.olap.HspEssConnection.<init>(HspEssConnection.java:82)

                  at com.hyperion.planning.olap.HspEssbasePool.createObject(HspEssbasePool.java:482)

                  at com.hyperion.planning.HspPool.createObjects(HspPool.java:111)

                  at com.hyperion.planning.HspPool.access$000(HspPool.java:14)

                  at com.hyperion.planning.HspPool$ObjectCreatorThread.run(HspPool.java:84)

                Jul 7, 2014 1:23:50 AM com.hyperion.planning.olap.HspEssbasePool createObject

                SEVERE: Cannot establish the OLAP connection: {0} .

                com.hyperion.planning.olap.EssbaseException (1030818)

                  at com.hyperion.planning.olap.HspEssbaseMainAPI.EssLogin(Native Method)

                  at com.hyperion.planning.olap.HspEssConnection.EssLoginWithAPSCheck(HspEssConnection.java:102)

                  at com.hyperion.planning.olap.HspEssConnection.connect(HspEssConnection.java:125)

                  at com.hyperion.planning.olap.HspEssConnection.<init>(HspEssConnection.java:82)

                  at com.hyperion.planning.olap.HspEssbasePool.createObject(HspEssbasePool.java:482)

                  at com.hyperion.planning.HspPool.createObjects(HspPool.java:111)

                  at com.hyperion.planning.HspPool.access$000(HspPool.java:14)

                  at com.hyperion.planning.HspPool$ObjectCreatorThread.run(HspPool.java:84)

                Jul 7, 2014 1:23:54 AM com.hyperion.planning.olap.HspEssbasePool createObject

                SEVERE: Cannot establish the OLAP connection: {0} .

                com.hyperion.planning.olap.EssbaseException (1030818)

                  at com.hyperion.planning.olap.HspEssbaseMainAPI.EssLogin(Native Method)

                  at com.hyperion.planning.olap.HspEssConnection.EssLoginWithAPSCheck(HspEssConnection.java:102)

                  at com.hyperion.planning.olap.HspEssConnection.connect(HspEssConnection.java:125)

                  at com.hyperion.planning.olap.HspEssConnection.<init>(HspEssConnection.java:82)

                  at com.hyperion.planning.olap.HspEssbasePool.createObject(HspEssbasePool.java:482)

                  at com.hyperion.planning.HspPool.createAvailiableObject(HspPool.java:246)

                  at com.hyperion.planning.HspPool.getObject(HspPool.java:145)

                  at com.hyperion.planning.olap.HspEssbasePool.getObject(HspEssbasePool.java:524)

                  at com.hyperion.planning.olap.HspEssbasePool.getConnectionInternal(HspEssbasePool.java:358)

                  at com.hyperion.planning.olap.HspEssbasePool.getConnection(HspEssbasePool.java:340)

                  at com.hyperion.planning.olap.HspEssbaseJniOlap.setApplicationID(HspEssbaseJniOlap.java:1211)

                  at com.hyperion.planning.HspJSImpl.setAppIDinEssbase(HspJSImpl.java:500)

                  at com.hyperion.planning.HspJSImpl.<init>(HspJSImpl.java:184)

                  at com.hyperion.planning.HspJSHomeImpl.createHspJS(HspJSHomeImpl.java:659)

                  at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(HspJSHomeImpl.java:422)

                  at com.hyperion.planning.calcmgr.metadata.HspCalcMgrMetadata.getApplicationsXml(HspCalcMgrMetadata.java:84)

                  at com.hyperion.planning.appdeploy.HspAppDefinition.getClassicAppsMetadata(HspAppDefinition.java:2172)

                  at com.hyperion.planning.appdeploy.HspAppDefinition.getClassicAppsMetadata(HspAppDefinition.java:2165)

                  at HspAppManagerServlet.generateCalcMgrXML(HspAppManagerServlet.java:803)

                  at HspAppManagerServlet.Handle(HspAppManagerServlet.java:365)

                  at HspAppManagerServlet.doPost(HspAppManagerServlet.java:143)

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

                  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

                  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

                  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at HspValidationFilter.doFilter(HspValidationFilter.java:10)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

                  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

                  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

                  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

                  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

                  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

                  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

                  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                Jul 7, 2014 1:23:54 AM com.hyperion.planning.olap.HspEssbasePool getConnectionInternal

                SEVERE: Cannot establish the OLAP connection: {0} .

                java.lang.Exception: No object were successfully created. This can be caused by any of the following: The OLAP Server is not running, The DBMS is not running, the DBMS is running on a different machine that the one specified, the name and password provided were incorrect.

                  at com.hyperion.planning.HspPool.getObject(HspPool.java:147)

                  at com.hyperion.planning.olap.HspEssbasePool.getObject(HspEssbasePool.java:524)

                  at com.hyperion.planning.olap.HspEssbasePool.getConnectionInternal(HspEssbasePool.java:358)

                  at com.hyperion.planning.olap.HspEssbasePool.getConnection(HspEssbasePool.java:340)

                  at com.hyperion.planning.olap.HspEssbaseJniOlap.setApplicationID(HspEssbaseJniOlap.java:1212)

                  at com.hyperion.planning.HspJSImpl.setAppIDinEssbase(HspJSImpl.java:500)

                  at com.hyperion.planning.HspJSImpl.<init>(HspJSImpl.java:184)

                  at com.hyperion.planning.HspJSHomeImpl.createHspJS(HspJSHomeImpl.java:659)

                  at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(HspJSHomeImpl.java:422)

                  at com.hyperion.planning.calcmgr.metadata.HspCalcMgrMetadata.getApplicationsXml(HspCalcMgrMetadata.java:84)

                  at com.hyperion.planning.appdeploy.HspAppDefinition.getClassicAppsMetadata(HspAppDefinition.java:2172)

                  at com.hyperion.planning.appdeploy.HspAppDefinition.getClassicAppsMetadata(HspAppDefinition.java:2165)

                  at HspAppManagerServlet.generateCalcMgrXML(HspAppManagerServlet.java:803)

                  at HspAppManagerServlet.Handle(HspAppManagerServlet.java:365)

                  at HspAppManagerServlet.doPost(HspAppManagerServlet.java:144)

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)

                  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

                  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

                  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

                  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at HspValidationFilter.doFilter(HspValidationFilter.java:10)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

                  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

                  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

                  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

                  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

                  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

                  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

                  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                Jul 7, 2014 1:23:54 AM com.hyperion.planning.HspJSImpl <init>

                INFO: Planning application (AMIPLN) successfully initialized.

                Jul 7, 2014 1:23:54 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:23:54 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:23:57 AM com.hyperion.planning.olap.HspEssbasePool createObject

                SEVERE: Cannot establish the OLAP connection: {0} .

                com.hyperion.planning.olap.EssbaseException (1030818)

                  at com.hyperion.planning.olap.HspEssbaseMainAPI.EssLogin(Native Method)

                  at com.hyperion.planning.olap.HspEssConnection.EssLoginWithAPSCheck(HspEssConnection.java:102)

                  at com.hyperion.planning.olap.HspEssConnection.connect(HspEssConnection.java:125)

                  at com.hyperion.planning.olap.HspEssConnection.<init>(HspEssConnection.java:82)

                  at com.hyperion.planning.olap.HspEssbasePool.createObject(HspEssbasePool.java:482)

                  at com.hyperion.planning.HspPool.createObjects(HspPool.java:111)

                  at com.hyperion.planning.HspPool.access$000(HspPool.java:14)

                  at com.hyperion.planning.HspPool$ObjectCreatorThread.run(HspPool.java:84)

                Jul 7, 2014 1:24:01 AM com.hyperion.planning.olap.HspEssbasePool createObject

                SEVERE: Cannot establish the OLAP connection: {0} .

                com.hyperion.planning.olap.EssbaseException (1030818)

                  at com.hyperion.planning.olap.HspEssbaseMainAPI.EssLogin(Native Method)

                  at com.hyperion.planning.olap.HspEssConnection.EssLoginWithAPSCheck(HspEssConnection.java:102)

                  at com.hyperion.planning.olap.HspEssConnection.connect(HspEssConnection.java:125)

                  at com.hyperion.planning.olap.HspEssConnection.<init>(HspEssConnection.java:82)

                  at com.hyperion.planning.olap.HspEssbasePool.createObject(HspEssbasePool.java:482)

                  at com.hyperion.planning.HspPool.createObjects(HspPool.java:111)

                  at com.hyperion.planning.HspPool.access$000(HspPool.java:14)

                  at com.hyperion.planning.HspPool$ObjectCreatorThread.run(HspPool.java:84)

                Jul 7, 2014 1:24:04 AM com.hyperion.planning.olap.HspEssbasePool createObject

                SEVERE: Cannot establish the OLAP connection: {0} .

                com.hyperion.planning.olap.EssbaseException (1030818)

                  at com.hyperion.planning.olap.HspEssbaseMainAPI.EssLogin(Native Method)

                  at com.hyperion.planning.olap.HspEssConnection.EssLoginWithAPSCheck(HspEssConnection.java:102)

                  at com.hyperion.planning.olap.HspEssConnection.connect(HspEssConnection.java:125)

                  at com.hyperion.planning.olap.HspEssConnection.<init>(HspEssConnection.java:82)

                  at com.hyperion.planning.olap.HspEssbasePool.createObject(HspEssbasePool.java:482)

                  at com.hyperion.planning.HspPool.createAvailiableObject(HspPool.java:246)

                  at com.hyperion.planning.HspPool.getObject(HspPool.java:145)

                  at com.hyperion.planning.olap.HspEssbasePool.getObject(HspEssbasePool.java:524)

                  at com.hyperion.planning.olap.HspEssbasePool.getConnectionInternal(HspEssbasePool.java:358)

                  at com.hyperion.planning.olap.HspEssbasePool.getConnection(HspEssbasePool.java:340)

                  at com.hyperion.planning.olap.HspEssbaseJniOlap.setApplicationID(HspEssbaseJniOlap.java:1211)

                  at com.hyperion.planning.HspJSImpl.setAppIDinEssbase(HspJSImpl.java:500)

                  at com.hyperion.planning.HspJSImpl.<init>(HspJSImpl.java:184)

                  at com.hyperion.planning.HspJSHomeImpl.createHspJS(HspJSHomeImpl.java:659)

                  at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(HspJSHomeImpl.java:422)

                  at com.hyperion.planning.calcmgr.metadata.HspCalcMgrMetadata.getApplicationsXml(HspCalcMgrMetadata.java:84)

                  at com.hyperion.planning.appdeploy.HspAppDefinition.getClassicAppsMetadata(HspAppDefinition.java:2172)

                  at com.hyperion.planning.appdeploy.HspAppDefinition.getClassicAppsMetadata(HspAppDefinition.java:2165)

                  at HspAppManagerServlet.generateCalcMgrXML(HspAppManagerServlet.java:803)

                  at HspAppManagerServlet.Handle(HspAppManagerServlet.java:365)

                  at HspAppManagerServlet.doPost(HspAppManagerServlet.java:143)

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

                  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

                  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

                  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at HspValidationFilter.doFilter(HspValidationFilter.java:10)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

                  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

                  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

                  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

                  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

                  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

                  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

                  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                Jul 7, 2014 1:24:04 AM com.hyperion.planning.olap.HspEssbasePool getConnectionInternal

                SEVERE: Cannot establish the OLAP connection: {0} .

                java.lang.Exception: No object were successfully created. This can be caused by any of the following: The OLAP Server is not running, The DBMS is not running, the DBMS is running on a different machine that the one specified, the name and password provided were incorrect.

                  at com.hyperion.planning.HspPool.getObject(HspPool.java:147)

                  at com.hyperion.planning.olap.HspEssbasePool.getObject(HspEssbasePool.java:524)

                  at com.hyperion.planning.olap.HspEssbasePool.getConnectionInternal(HspEssbasePool.java:358)

                  at com.hyperion.planning.olap.HspEssbasePool.getConnection(HspEssbasePool.java:340)

                  at com.hyperion.planning.olap.HspEssbaseJniOlap.setApplicationID(HspEssbaseJniOlap.java:1212)

                  at com.hyperion.planning.HspJSImpl.setAppIDinEssbase(HspJSImpl.java:500)

                  at com.hyperion.planning.HspJSImpl.<init>(HspJSImpl.java:184)

                  at com.hyperion.planning.HspJSHomeImpl.createHspJS(HspJSHomeImpl.java:659)

                  at com.hyperion.planning.HspJSHomeImpl.getHspJSByApp(HspJSHomeImpl.java:422)

                  at com.hyperion.planning.calcmgr.metadata.HspCalcMgrMetadata.getApplicationsXml(HspCalcMgrMetadata.java:84)

                  at com.hyperion.planning.appdeploy.HspAppDefinition.getClassicAppsMetadata(HspAppDefinition.java:2172)

                  at com.hyperion.planning.appdeploy.HspAppDefinition.getClassicAppsMetadata(HspAppDefinition.java:2165)

                  at HspAppManagerServlet.generateCalcMgrXML(HspAppManagerServlet.java:803)

                  at HspAppManagerServlet.Handle(HspAppManagerServlet.java:365)

                  at HspAppManagerServlet.doPost(HspAppManagerServlet.java:144)

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)

                  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

                  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

                  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

                  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at HspValidationFilter.doFilter(HspValidationFilter.java:10)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

                  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

                  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

                  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

                  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

                  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

                  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

                  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                Jul 7, 2014 1:24:04 AM com.hyperion.planning.HspJSImpl <init>

                INFO: Planning application (AMIROI) successfully initialized.

                Jul 7, 2014 1:24:04 AM oracle.dms.servlet.DMSServletFilter compareStartAndEndContexts

                WARNING: The execution context put in place at the start of the request, 00iN2bpIQTfFw00Fzzw0w000026400004R,0:1, is not the execution context in place at the end of the request, 00iN2arYX6VFw00Fzzw0w000026400002r,0:1:4:4. The request is as follows: Request URI:

                  /HyperionPlanning/servlet/HspAppManagerServlet

                Request URL:

                  http://AMIWSD05.mycmsc.com:19000/HyperionPlanning/servlet/HspAppManagerServlet

                Query String:

                  action=calc_get_apps_metadata&include_children=false&include_all_classic_apps=false

                All Headers Names:

                  Accept-Language, awb-sso-token, Content-Type, User-Agent, Host, Content-Length, ECID-Context, Connection, X-Forwarded-For, Proxy-Client-IP, X-WebLogic-KeepAliveSecs, X-WebLogic-Force-JVMID

                Selected Header Values:

                  ECID-Context : 1.00iN2bpIQTfFw00Fzzw0w000026400004R;kXjE1ZDLIPHQj8HUkLQSdVQRGSPOiUPQiNRBnLQSqSPPoV8InGTGkGTJXUPObLQSJLQSqSPPoG

                  Accept-Language : en

                  Host : AMIWSD05.mycmsc.com:19000

                  Content-Length : 0

                  User-Agent : Jakarta Commons-HttpClient/3.1

                  Connection : Keep-Alive

                  Content-Type : text/xml; charset=UTF-8

                 

                 

                Jul 7, 2014 1:24:05 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:24:05 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:53:43 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:53:43 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:53:54 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:53:54 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:54:05 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 1:54:05 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:23:43 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:23:43 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:23:54 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:23:54 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:24:05 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:24:05 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:53:43 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:53:43 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:53:54 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:53:54 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:54:05 AM com.hyperion.planning.sql.HspSQLImpl executeUpdate

                INFO: An error occurred executing query SQL_UPDATE_OLU_STATUS_STATUS with parameters [2, 1589393214]

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                Jul 7, 2014 2:54:05 AM com.hyperion.planning.utils.HspActivityThread executeLeasedActivity

                SEVERE: Error occurred while executing activity: Reset Invalid PU Sub-states

                java.sql.SQLSyntaxErrorException: ORA-00904: "SERVER_ID": invalid identifier

                 

                 

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

                  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:394)

                  at com.hyperion.planning.sql.HspSQLImpl.executeUpdate(HspSQLImpl.java:359)

                  at com.hyperion.planning.sql.actions.HspAction.executeUpdate(HspAction.java:106)

                  at com.hyperion.planning.sql.actions.HspOLUStatusCleanupCustomAction.custom(HspOLUStatusCleanupCustomAction.java:21)

                  at com.hyperion.planning.sql.actions.HspAction.custom(HspAction.java:293)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:265)

                  at com.hyperion.planning.sql.actions.HspActionSet.doActions(HspActionSet.java:206)

                  at com.hyperion.planning.db.HspPMDBImpl.resetInvalidSubstates(HspPMDBImpl.java:6735)

                  at com.hyperion.planning.utils.HspPUStatusCleaner.executeActivity(HspPUStatusCleaner.java:35)

                  at com.hyperion.planning.utils.HspActivityThread.executeLeasedActivity(HspActivityThread.java:148)

                  at com.hyperion.planning.utils.HspActivityThread.run(HspActivityThread.java:106)

                • 6. Re: Calculation Manager is taking lot of time to open after applying .500 Patch
                  KKT

                  Hi,

                   

                  Good to know, Can you share the resolution we all can get benefit from that.

                   

                  Thanks,

                  ~KKT~

                  • 7. Re: Calculation Manager is taking lot of time to open after applying .500 Patch
                    user10646442

                    Hi,

                     

                    Thanks all for your reply.

                     

                    The resolution is kept in my blog..

                     

                    http://hyperion-consulting.blogspot.in