This discussion is archived
0 Replies Latest reply: Dec 10, 2012 10:41 PM by 8786 - oracle RSS

ADF Error on ODI Console

8786 - oracle Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points