java.sql.SQLException

ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: ORA-00942: table or view does not exist Error Code: 29902

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web16331

  • via Oracle Community by 560001, 10 months ago
    ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: ORA-00942: table or view does not exist Error Code: 29902
  • via Oracle Community by 578019, 11 months ago
    ORA-29902: error in executing ODCIIndexStart() routine ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286
  • via Oracle Community by 407022, 11 months ago
    ORA-29902: error in executing ODCIIndexStart() routine ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333
  • Stack trace

    • java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: ORA-00942: table or view does not exist Error Code: 29902 at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:226) at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:695) at oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:506) at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(CallQueryMechanism.java:130) at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(CallQueryMechanism.java:111) at oracle.toplink.internal.queryframework.CallQueryMechanism.executeSelectCall(CallQueryMechanism.java:193) at oracle.toplink.internal.queryframework.CallQueryMechanism.selectAllRows(CallQueryMechanism.java:563) at oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:421) at oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:498) at oracle.toplink.queryframework.ReadQuery.execute(ReadQuery.java:111) at oracle.toplink.publicinterface.Session.internalExecuteQuery(Session.java:1968) at oracle.toplink.threetier.ServerSession.internalExecuteQuery(ServerSession.java:629) at oracle.toplink.threetier.ClientSession.internalExecuteQuery(ClientSession.java:392) at oracle.toplink.publicinterface.Session.executeQuery(Session.java:1096) at oracle.toplink.publicinterface.Session.executeQuery(Session.java:1048) at oracle.toplink.publicinterface.Session.readAllObjects(Session.java:2416) at it.csi.cultura.om.supporto.ObjectManagerFrontoffice.getElencoEventiFiltrati(ObjectManagerFrontoffice.java:1431) at it.csi.cultura.backoffice.eventinotizie.ElencoEventi.execute(ElencoEventi.java:125) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.