0 Replies Latest reply on Jun 4, 2016 5:20 PM by user9328366

    Error when get json from heterogeneous MS access table. How to get json from access DB?

    user9328366

      SQL  is fine, can get data from oracle sql developer,  table is from MS access which linked by oracle by dblink(Using ODBC). But I can NOT get json from table, only error, could you hlep? Thank you.

      64 bit windows2012, ODBC driver 64 bit,

       

      Log:

       

       

      Jun 05, 2016 12:48:11 AM oracle.dbtools.http.errors.ErrorPageFilter log

      SEVERE: java.sql.SQLException: ORA-28513: internal error in heterogeneous remot

      agent

      ORA-02063: preceding line from FUND888_ACCESS

       

       

      InternalServerException [statusCode=500, reasons=[]]

              at oracle.dbtools.rest.resource.generator.json.JSONQueryOneRowResourceG

      nerator.service(JSONQueryOneRowResourceGenerator.java:71)

              at oracle.dbtools.rest.resource.generator.ResourceGeneratorsProvider.ge

      erate(ResourceGeneratorsProvider.java:69)

              at oracle.dbtools.rest.resource.modules.ModulesDispatcherDelegate.servi

      e(ModulesDispatcherDelegate.java:132)

              at oracle.dbtools.rest.resource.modules.ModulesDispatcherDelegate.acces

      $100(ModulesDispatcherDelegate.java:26)

              at oracle.dbtools.rest.resource.modules.ModulesDispatcherDelegate$GetDi

      patcher.doGet(ModulesDispatcherDelegate.java:174)

              at oracle.dbtools.http.etags.EntityTagsProvider.etag(EntityTagsProvider

      java:114)

              at oracle.dbtools.rest.resource.modules.ModulesDispatcherDelegate.servi

      e(ModulesDispatcherDelegate.java:58)

              at oracle.dbtools.rest.resource.jdbc.JDBCResourceDispatcher.service(JDB

      ResourceDispatcher.java:75)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

              at oracle.dbtools.http.servlet.DispatchableServletBase.service(Dispatch

      bleServletBase.java:58)

              at oracle.dbtools.rest.resource.cache.CachedResourceDispatcher.service(

      achedResourceDispatcher.java:59)

              at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:1

      4)

              at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(En

      ryPoint.java:243)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:73)

              at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryF

      lteringRewrite.java:89)

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingF

      lter.java:59)

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.cors.CORSPreflightFilter.doFilter(CORSPreflightF

      lter.java:67)

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(Co

      kieSessionCSRFFilter.java:73)

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.auth.AuthenticationFilter.authenticate(Authentic

      tionFilter.java:89)

              at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(Authenticatio

      Filter.java:62)

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.url.mapping.RequestMapperBase.doFilter(RequestMapperB

      se.java:53)

              at oracle.dbtools.url.mapping.CompositeMapper$RequestMapperFilterChain.

      oFilter(CompositeMapper.java:144)

              at oracle.dbtools.url.mapping.RequestMapperBase.doFilter(RequestMapperB

      se.java:53)

              at oracle.dbtools.url.mapping.CompositeMapper.doFilter(CompositeMapper.

      ava:37)

              at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.ja

      a:89)

              at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappi

      gFilter.java:83)

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.locale.LocaleFilter.doFilter(LocaleFilter.java:5

      )

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFil

      er.java:83)

              at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponse

      ilter.java:45)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.

      ava:81)

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.ja

      a:44)

              at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)

              at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl

      java:64)

              at oracle.dbtools.http.filters.Filters.filter(Filters.java:47)

              at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:85

       

       

              at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointS

      rvlet.java:49)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

              at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndp

      intBase.java:123)

              at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java

      85)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

              at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:75

      )

              at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.jav

      :566)

              at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHand

      er.java:219)

              at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHand

      er.java:1111)

              at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java

      498)

              at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandl

      r.java:183)

              at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandl

      r.java:1045)

              at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.

      ava:141)

              at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(Con

      extHandlerCollection.java:199)

              at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCol

      ection.java:109)

              at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrappe

      .java:98)

              at org.eclipse.jetty.server.Server.handle(Server.java:461)

              at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:284)

              at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.ja

      a:244)

              at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.jav

      :534)

              at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPo

      l.java:607)

              at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPoo

      .java:536)

              at java.lang.Thread.run(Unknown Source)

      Caused by: java.sql.SQLException: ORA-28513: internal error in heterogeneous re

      ote agent

      ORA-02063: preceding line from FUND888_ACCESS

       

       

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

              at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement

      java:220)

              at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement

      java:48)

              at oracle.jdbc.driver.T4CCallableStatement.executeForDescribe(T4CCallab

      eStatement.java:769)

              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatem

      nt.java:925)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatem

      nt.java:1104)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePre

      aredStatement.java:4798)

              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepar

      dStatement.java:4845)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(Oracl

      PreparedStatementWrapper.java:1501)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

              at java.lang.reflect.Method.invoke(Unknown Source)

              at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedS

      atementProxyFactory.java:160)

              at oracle.ucp.jdbc.proxy.CallableStatementProxyFactory.invoke(CallableS

      atementProxyFactory.java:136)

              at com.sun.proxy.$Proxy49.executeQuery(Unknown Source)

              at oracle.dbtools.common.stmt.jdbc.BindableQueryImpl.executeQuery(Binda

      leQueryImpl.java:25)

              at oracle.dbtools.rest.resource.generator.json.JSONQueryOneRowResourceG

      nerator.service(JSONQueryOneRowResourceGenerator.java:67)

              ... 74 more