0 Replies Latest reply: Dec 11, 2012 12:41 AM by 8786 - oracle RSS

    ADF Error on ODI Console

    8786 - oracle
      Hi All,

      ODI Version: 11.1.1.5.0
      We have set up an '---Execution Type Repository---' for ODI.
      An ODI server is configured for the same repository and application 'odiconsole' is deployed.

      Now when we login to odiconsole and try to view the scenario, it throws the following ADF Error :
      ----------------------------------
      ADFC-10004: cannot set managed bean property 'loadDetails'

      ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server
      Exception during PPR,#19
      ----------------------------------

      And while checking the server's log, following error can be seen:
      ----------------------------------
      Error Code: 942
      Call: SELECT I_PACKAGE, PACK_NAME, FIRST_USER, LAST_USER, FIRST_DATE, LAST_DATE, INT_VERSION, I_TXT_PACK, I_FOLDER FROM SNP_PACKAGE WHERE (I_PACKAGE = ?)
      bind => [205001]
      Query: ReadObjectQuery(referenceClass=OdiPackage sql="SELECT I_PACKAGE, PACK_NAME, FIRST_USER, LAST_USER, FIRST_DATE, LAST_DATE, INT_VERSION, I_TXT_PACK, I_FOLDER FROM SNP_PACKAGE WHERE (I_PACKAGE = ?)"); nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

      at oracle.odi.core.persistence.jpa.springeclipselink.SessionFactoryUtils.convertTopLinkAccessException(SessionFactoryUtils.java:25)
      at oracle.odi.core.persistence.jpa.toplink.JpaTopLinkOdiEntityManagerFactory.convertTopLinkAccessException(JpaTopLinkOdiEntityManagerFactory.java:174)
      at oracle.odi.core.persistence.jpa.toplink.JpaTopLinkOdiEntityManagerFactory.translateExceptionIfPossible(JpaTopLinkOdiEntityManagerFactory.java:135)
      at oracle.odi.core.persistence.jpa.JpaOdiEntityManager.translateDataAccessException(JpaOdiEntityManager.java:200)
      at oracle.odi.core.persistence.jpa.JpaOdiEntityManager.findById(JpaOdiEntityManager.java:65)
      at sun.reflect.GeneratedMethodAccessor335.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at oracle.odi.core.OdiInstance$TransactionalOdiEntityManagerInvocationHandler.invoke(OdiInstance.java:227)
      at $Proxy119.findById(Unknown Source)
      at oracle.odi.domain.finder.toplink.AbstractTopLinkOdiEntityManagerFinder.findById(AbstractTopLinkOdiEntityManagerFinder.java:122)
      at oracle.odi.repex.model.domain.project.PackageService.getById(PackageService.java:44)
      at oracle.odi.repex.model.domain.project.PackageService.getById(PackageService.java:39)
      at oracle.odi.repex.view.browser.runtime.scenario.ScenarioBean$Details.<init>(ScenarioBean.java:209)
      at oracle.odi.repex.view.browser.runtime.scenario.ScenarioBean.setLoadDetails(ScenarioBean.java:120)
      ... 228 more
      Caused by: 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.executeForDescribe(T4CPreparedStatement.java:924)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
      at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
      ----------------------------------

      Now again, we tested same thing with '---Development Type Repository---', if we trying view the scenarios on ODIConsole, we can see them.


      Please suggest why ADF Error comes and what is the actual reason of not able to view scenarios in execution type respository.