5 Replies Latest reply: Apr 17, 2013 3:18 PM by PeteJ RSS

    Framework Service configuration error 11.1.2.2

    EsbRookie
      Hello,

      While configuring Reporting & Analysis for 11.1.2.2, Framework Services configuration failed. I only selected RA components from the task menu. I looked into the configtool.log and found the "table or view does not exist" error. I am not sure why I would get this error considering other repository tasks for RA were completed fine. Any clues?

      Environment: Red Hat Linux x64

      Thank you,

      Nitin

      ------------------------------------------------------------------------------------------------------------

      [2012-11-19T17:52:35.419-06:00] [EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 47] [ecid: 0000JgR5WFC8pm3LVmo2yc1GegFs00000L,0] [SRC_CLASS: com.hyperion.config.wizard.impl.RunAllTasks] trace: Executing custom task Configure Framework Services for product raframework
      [2012-11-19T17:52:35.419-06:00] [EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 47] [ecid: 0000JgR5WFC8pm3LVmo2yc1GegFs00000L,0] [SRC_CLASS: com.oracle.reportinganalysis.config.FrameworkServiceConfigurator] trace: DataBase Component details. URL: jdbc:oracle:thin:@coefsdb14:8670:epmqa, driver: oracle.jdbc.OracleDriver, userName: epmbi
      [2012-11-19T17:52:35.515-06:00] [EPMCFG] [ERROR] [EPMCFG-05020] [oracle.EPMCFG] [tid: 47] [ecid: 0000JgR5WFC8pm3LVmo2yc1GegFs00000L,0] [SRC_CLASS: com.oracle.reportinganalysis.config.FrameworkServiceConfigurator] Error: {0}[[
      java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

           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.sqribe.transformer.DBPreparedStatement.executeUpdate(Unknown Source)
           at com.brio.one.services.authentication.impl.database.BaseDatabaseManager.insertIdentity(Unknown Source)
           at com.brio.one.services.authentication.impl.database.SubjectDBManager.createSystemSubject(Unknown Source)
           at com.brio.one.services.authentication.install.AuthenticationConfigurationManager.createSubject(Unknown Source)
           at com.brio.one.services.authentication.install.AuthenticationConfigurationManager.createSubject(Unknown Source)
           at com.oracle.reportinganalysis.config.util.FrameworkServiceUtil.createSubject(FrameworkServiceUtil.java:170)
           at com.oracle.reportinganalysis.config.util.FrameworkServiceUtil.createSubjects(FrameworkServiceUtil.java:136)
           at com.oracle.reportinganalysis.config.FrameworkServiceConfigurator.execute(FrameworkServiceConfigurator.java:92)
           at com.hyperion.cis.CustomTaskProcessor.execute(CustomTaskProcessor.java:94)
           at com.hyperion.config.wizard.impl.RunAllTasks.executeCustomTask(RunAllTasks.java:899)
           at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:474)
           at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:91)
           at java.lang.Thread.run(Thread.java:662)
      Nov 19 17:52:35.515
      ORA-00942: table or view does not exist

      com.brio.one.common.DatabaseException: ORA-00942: table or view does not exist

           at com.brio.one.services.impl.database.BaseDBManager.throwDatabaseException(Unknown Source)
           at com.brio.one.services.authentication.impl.database.BaseDatabaseManager.insertIdentity(Unknown Source)
           at com.brio.one.services.authentication.impl.database.SubjectDBManager.createSystemSubject(Unknown Source)
           at com.brio.one.services.authentication.install.AuthenticationConfigurationManager.createSubject(Unknown Source)
           at com.brio.one.services.authentication.install.AuthenticationConfigurationManager.createSubject(Unknown Source)
           at com.oracle.reportinganalysis.config.util.FrameworkServiceUtil.createSubject(FrameworkServiceUtil.java:170)
           at com.oracle.reportinganalysis.config.util.FrameworkServiceUtil.createSubjects(FrameworkServiceUtil.java:136)
           at com.oracle.reportinganalysis.config.FrameworkServiceConfigurator.execute(FrameworkServiceConfigurator.java:92)
           at com.hyperion.cis.CustomTaskProcessor.execute(CustomTaskProcessor.java:94)
           at com.hyperion.config.wizard.impl.RunAllTasks.executeCustomTask(RunAllTasks.java:899)
           at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:474)
           at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:91)
           at java.lang.Thread.run(Thread.java:662)

      ]]
      [2012-11-19T17:52:35.516-06:00] [EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 47] [ecid: 0000JgR5WFC8pm3LVmo2yc1GegFs00000L,0] [SRC_CLASS: com.hyperion.config.wizard.impl.RunAllTasks] trace: Done executing custom task Configure Framework Services for product raframework