5 Replies Latest reply on May 25, 2015 10:18 AM by Paavo

    500 - Internal Server Error - Table or View does not Exist

    DLloyd

      When trying to use the sample restful service oracle.example.hr I get a 500 - Internal Server Error.

       

      I have no clue what to do next. I've even tried granting public to the emp table.  Nottin.

      Any insight you could give would be awesome.

       

      Here is the error:

       

      Request Path passes syntax validation

      Mapping request to database pool: PoolMap [_failed=false, _lastUpdate=-1, _pattern=null, _poolName=apex, _regex=null, _type=REGEX, _workspaceIdentifier=null, _serviceName=null]

      Applied database connection info

      Attempting to process with PL/SQL Gateway

      Not processed as PL/SQL Gateway request

      Attempting to process as a RESTful Service

      Determining if request can be dispatched as a Tenanted RESTful Service

      Request path has one path segment, continuing processing

      No Tenant Principal established yet, continuing processing

      APEX_LISTENER pool exists, continuing processing

       

       

       

       

      WebException [statusCode=500]
           at oracle.dbtools.rt.web.WebException.webException(WebException.java:343)
           at oracle.dbtools.rt.web.WebException.internalError(WebException.java:262)
           at oracle.dbtools.rt.web.WebErrorResponse.internalError(WebErrorResponse.java:101)
           at oracle.dbtools.rt.web.WebErrorResponse.error(WebErrorResponse.java:75)
           at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:166)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3732)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      Caused by: JDBCException [kind=NO_DATA]
           at oracle.dbtools.common.jdbc.JDBCException.wrap(JDBCException.java:88)
           at oracle.dbtools.common.jdbc.JDBCQueryProvider.query(JDBCQueryProvider.java:41)
           at oracle.dbtools.rt.jdbc.entity.JDBCTenantDispatcher.tenant(JDBCTenantDispatcher.java:104)
           at oracle.dbtools.rt.jdbc.entity.TenantDispatcherBase.target(TenantDispatcherBase.java:71)
           at oracle.dbtools.rt.jdbc.entity.TenantDispatcherBase.target(TenantDispatcherBase.java:37)
           at oracle.dbtools.rt.web.ReTargetingDispatcher.canDispatch(ReTargetingDispatcher.java:45)
           at oracle.dbtools.rt.web.RequestDispatchers.choose(RequestDispatchers.java:160)
           at oracle.dbtools.rt.web.RequestDispatchers.dispatch(RequestDispatchers.java:75)
           at oracle.dbtools.rt.web.ETags.checkPrecondition(ETags.java:53)
           at oracle.dbtools.rt.web.HttpEndpointBase.restfulServices(HttpEndpointBase.java:426)
           at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:164)
           ... 14 more
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:505)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
           at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
           at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3612)
           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3656)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
           at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:111)
           at $Proxy104.executeQuery(Unknown Source)
           at oracle.dbtools.common.jdbc.JDBCQueryImpl.resultSet(JDBCQueryImpl.java:93)
           at oracle.dbtools.common.jdbc.JDBCResultRowIterator.<init>(JDBCResultRowIterator.java:28)
           at oracle.dbtools.common.jdbc.JDBCQueryImpl.execute(JDBCQueryImpl.java:53)
           at oracle.dbtools.common.jdbc.JDBCQueryProvider.query(JDBCQueryProvider.java:38)
           ... 23 more