2 Replies Latest reply: Jan 26, 2013 1:19 PM by Sh!va RSS

    Foundation installation

    hyperion start
      Gurus,
      I am in the process of configuring EPM.
      In the process configuring Foundation when I try to set up the Shared services and registry database, I get the error : FAILED TO NAVIGATE FROM REGISTRYWIZARDSTATE. ERROR WHILE INITIALIZING REGISTRY" I check the logs: REGISTRY.LOG and CONFIGTOOL.LOG.

      The errors are:
      *table or view does not exist and*
      *Error while initializing registry.*

      This is one error:

      om.hyperion.hit.wizard.FailedButRetryPossibleException: Error while initializing registry.
           at com.hyperion.config.wizard.impl.RegistryWizardState$1$1.commit(RegistryWizardState.java:394)
           at com.hyperion.hit.wizard.Wizard$NextClass.run(Wizard.java:515)
           at java.lang.Thread.run(Thread.java:619)
      Caused by: java.lang.NullPointerException
           at com.hyperion.config.document.Storage.setLink(Storage.java:398)
           at com.hyperion.cis.config.ConfigRegistryUtils.createProductComponent(ConfigRegistryUtils.java:81)
           at com.hyperion.cis.config.ConfigRegistryUtils.initializeRegistry(ConfigRegistryUtils.java:419)
           at com.hyperion.config.wizard.impl.RegistryWizardState$1$1.commit(RegistryWizardState.java:277)
           ... 2 more


      [2013-01-25T15:12:06.579-05:00] [EPMREG] [ERROR] [EPMREG-11073] [oracle.EPMREG.REG] [tid: 23] [ecid: 0000JlnLeZW6qIC0ZFM6Vr1H0hxF00000A,0] An exception when executing SQL INSERT INTO HSS_COMPONENT_PROPERTY_VALUES(PROPERTY_VALUE, PROPERTY_NAME, COMPONENT_ID) VALUES(?, ?, ?).
      [2013-01-25T15:12:06.579-05:00] [EPMREG] [ERROR] [EPMREG-11099] [oracle.EPMREG.REG] [tid: 23] [ecid: 0000JlnLeZW6qIC0ZFM6Vr1H0hxF00000A,0] Exception occurred.[[
      java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
           at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1079)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3887)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1508)
           at com.hyperion.hit.registry.utils.JDBCTemplate.executeUpdateOptimized(JDBCTemplate.java:362)
           at com.hyperion.hit.registry.JDBCRegistryUtils.setPropertyValue(JDBCRegistryUtils.java:1229)
           at com.hyperion.hit.registry.ComponentImpl.setPropertyValue(ComponentImpl.java:619)
           at com.hyperion.hit.registry.ComponentImpl.setVersion(ComponentImpl.java:1270)
           at com.hyperion.hit.registry.ComponentImpl.setBasicProperties(ComponentImpl.java:306)
           at com.hyperion.hit.registry.Registry.newComponent(Registry.java:1655)
           at com.hyperion.hit.registry.ComponentImpl.newChild(ComponentImpl.java:1228)
           at com.hyperion.config.document.Storage.newChild(Storage.java:313)
           at com.hyperion.cis.config.ConfigRegistryUtils.initializeRegistry(ConfigRegistryUtils.java:386)
           at com.hyperion.config.wizard.impl.RegistryWizardState$1$1.commit(RegistryWizardState.java:277)
           at com.hyperion.hit.wizard.Wizard$NextClass.run(Wizard.java:515)
           at java.lang.Thread.run(Thread.java:619)

      Any suggestions would be of great help.
      Thanks