4 Replies Latest reply on Jun 20, 2017 1:35 PM by SemanticGuy

    ORA-20000: Service request cannot be completed

    SemanticGuy

      Hi,

       

      We continue advancing in our project, but we have found a new issue.

       

      It looks we're seeing ORA-20000: Service request cannot be completed when we perform a federated query on Fuseki (using the "SERVICE keyword") to create complex large graphs to be analyzed in third party tools (like gephi).

       

      I think this can be due to a timeout on performing the request since same request worked fine in a smaller database (now, the volume of data is ~400 bigger).

       

      Here is the stack of error appearing (it's a little large, but I bet the most important lines are the first ones:

       

      ORA-29273: échec de demande HTTP

      ORA-06512: à "SYS.UTL_HTTP", ligne 1267

      ORA-06512: à "SYS.UTL_HTTP", ligne 651

      ORA-06512: à "SYS.UTL_HTTP", ligne 1257

      ORA-06512: à "MDSYS.SPARQL_SERVICE_IMPL_T", ligne 385

      ORA-06512: à "MDSYS.SPARQL_SERVICE_IMPL_T", ligne 446

      ORA-06512: à ligne 1

       

      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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)

      at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)

      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:957)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)

      at oracle.spatial.rdf.client.jena.Oracle.executeQuery(Oracle.java:554)

      at oracle.spatial.rdf.client.jena.OracleOpExecutor.buildSemIterator(OracleOpExecutor.java:2808)

      at oracle.spatial.rdf.client.jena.OracleRepeatApply.nextStage(OracleRepeatApply.java:1252)

      at org.apache.jena.sparql.engine.iterator.QueryIterRepeatApply.makeNextStage(QueryIterRepeatApply.java:108)

      at org.apache.jena.sparql.engine.iterator.QueryIterRepeatApply.hasNextBinding(QueryIterRepeatApply.java:65)

      at org.apache.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:111)

      at org.apache.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:39)

      at org.apache.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:111)

      at org.apache.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:39)

      at org.apache.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:111)

      at org.apache.jena.atlas.iterator.Iter$2.hasNext(Iter.java:265)

      at org.apache.jena.ext.com.google.common.collect.Iterators$5.hasNext(Iterators.java:547)

      at java.util.Iterator.forEachRemaining(Unknown Source)

      at org.apache.jena.sparql.engine.QueryExecutionBase.execConstructDataset(QueryExecutionBase.java:243)

      at org.apache.jena.sparql.engine.QueryExecutionBase.execConstructDataset(QueryExecutionBase.java:236)

      at org.apache.jena.fuseki.servlets.SPARQL_Query.executeQuery(SPARQL_Query.java:334)

      at org.apache.jena.fuseki.servlets.SPARQL_Query.execute(SPARQL_Query.java:270)

      at org.apache.jena.fuseki.servlets.SPARQL_Query.executeWithParameter(SPARQL_Query.java:228)

      at org.apache.jena.fuseki.servlets.SPARQL_Query.perform(SPARQL_Query.java:213)

      at org.apache.jena.fuseki.servlets.ActionSPARQL.executeLifecycle(ActionSPARQL.java:134)

      at org.apache.jena.fuseki.servlets.SPARQL_UberServlet.executeRequest(SPARQL_UberServlet.java:354)

      at org.apache.jena.fuseki.servlets.SPARQL_UberServlet.serviceDispatch(SPARQL_UberServlet.java:315)

      at org.apache.jena.fuseki.servlets.SPARQL_UberServlet.executeAction(SPARQL_UberServlet.java:271)

      at org.apache.jena.fuseki.servlets.ActionSPARQL.execCommonWorker(ActionSPARQL.java:85)

      at org.apache.jena.fuseki.servlets.ActionBase.doCommon(ActionBase.java:81)

      at org.apache.jena.fuseki.servlets.FusekiFilter.doFilter(FusekiFilter.java:72)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

      at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)

      at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

      at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

      at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

      at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)

      at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)

      at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)

      at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)

      at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)

      at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)

      at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)

      at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

      at org.apache.jena.fuseki.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:285)

      at org.apache.jena.fuseki.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:248)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)

      at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)

      at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)

      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1368)

      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

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

       

      Any suggestion of the Jedi Semantics?

       

      Thanks