6 Replies Latest reply on Feb 26, 2019 8:06 PM by Gianni Ceresa

    PGX3.2.0 -> cannot find loader exception

    mohanr.k

      I have PGX3.2.0 installed on  machine and the same machine (Windows) has cytoscape 3.7.1 installed. I see below exception when I run PGQL queries from cytoscape

       

      INFO: Starting ProtocolHandler ["http-nio-7007"]

      17:48:07,209 ERROR AbstractExceptionMapper - exception mapper caught exception w

      ith code PGX-ERROR-217DLY663TADM

      java.util.concurrent.ExecutionException: java.lang.UnsupportedOperationException

      : cannot find loader; this distribution of PGX does not support reading from the

      given data source; given config is {"max_num_connections":2,"format":"pg","load

      ing":{"load_edge_label":true,"create_edge_id_mapping":true},"vertex_id_type":"lo

      ng","db_engine":"RDBMS","username":"scott","error_handling":{},"name":"TEST_DA

      TA","vertex_props":[{"type":"string","name":"uid"}],"edge_label":true,"password

      ":"*******","jdbc_url":"jdbc:oracle:thin:@localhost:1521/pgdb","edge_props":[{"ty

      pe":"string","name":"label","default":" "},{"type":"double","name":"weight","def

      ault":100.0}],"attributes":{}}

              at java.util.concurrent.CompletableFuture.reportGet(Unknown Source) ~[?:

      1.8.0_201]

              at java.util.concurrent.CompletableFuture.get(Unknown Source) ~[?:1.8.0_

      201]

              at oracle.pgx.api.PgxFuture.get(PgxFuture.java:99) ~[pgx-api-3.2.0.jar:3

      .2.0]

              at oracle.pgx.rest.PgxFutureWrapper.getAsJson(PgxFutureWrapper.java:66)

      ~[classes/:?]

              at oracle.pgx.rest.EndpointUtils.checkHttpMethod(EndpointUtils.java:233)

      ~[classes/:?]

              at oracle.pgx.rest.endpoints.FutureResource.getFuture(FutureResource.jav

      a:100) ~[classes/:?]

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0

      _201]

              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0

      _201]

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1

      .8.0_201]

              at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_201]

              at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHa

      ndlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:76) ~[j

      ersey-server-2.26.jar:?]

              at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethod

      Dispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:148) ~[jersey-server-

      2.26.jar:?]

              at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethod

      Dispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:191) ~[jersey-server

      -2.26.jar:?]

              at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatch

      erProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.ja

      va:200) ~[jersey-server-2.26.jar:?]

              at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethod

      Dispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:103) ~[jersey-serv

      er-2.26.jar:?]

              at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(Resour

      ceMethodInvoker.java:493) ~[jersey-server-2.26.jar:?]

              at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Resourc

      eMethodInvoker.java:415) ~[jersey-server-2.26.jar:?]

              at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Resourc

      eMethodInvoker.java:104) ~[jersey-server-2.26.jar:?]

              at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:27

      7) [jersey-server-2.26.jar:?]

              at org.glassfish.jersey.internal.Errors$1.call(Errors.java:272) [jersey-

      common-2.26.jar:?]

              at org.glassfish.jersey.internal.Errors$1.call(Errors.java:268) [jersey-

      common-2.26.jar:?]

              at org.glassfish.jersey.internal.Errors.process(Errors.java:316) [jersey

      -common-2.26.jar:?]

              at org.glassfish.jersey.internal.Errors.process(Errors.java:298) [jersey

      -common-2.26.jar:?]

              at org.glassfish.jersey.internal.Errors.process(Errors.java:268) [jersey

      -common-2.26.jar:?]

              at org.glassfish.jersey.process.internal.RequestScope.runInScope(Request

      Scope.java:289) [jersey-common-2.26.jar:?]

              at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:

      256) [jersey-server-2.26.jar:?]

              at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHand

      ler.java:703) [jersey-server-2.26.jar:?]

              at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.ja

      va:416) [jersey-container-servlet-core-2.26.jar:?]

              at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:3

      70) [jersey-container-servlet-core-2.26.jar:?]

              at org.glassfish.jersey.servlet.ServletContainer.service(ServletContaine

      r.java:389) [jersey-container-servlet-core-2.26.jar:?]

              at org.glassfish.jersey.servlet.ServletContainer.service(ServletContaine

      r.java:342) [jersey-container-servlet-core-2.26.jar:?]

              at org.glassfish.jersey.servlet.ServletContainer.service(ServletContaine

      r.java:229) [jersey-container-servlet-core-2.26.jar:?]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:231) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:166) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at oracle.pgx.rest.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter

      .java:43) [classes/:?]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:193) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:166) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at oracle.pgx.rest.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter

      .java:43) [classes/:?]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:193) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:166) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServlet

      Filter.java:71) [log4j-web-2.11.0.jar:2.11.0]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:193) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:166) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

      alve.java:199) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

      alve.java:96) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica

      torBase.java:494) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

      ava:139) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

      ava:92) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

      ve.java:87) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

      a:343) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java

      :412) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLig

      ht.java:66) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abstract

      Protocol.java:754) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo

      int.java:1385) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBas

      e.java:49) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:

      1.8.0_201]

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

      :1.8.0_201]

              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh

      read.java:61) [tomcat-embed-core-9.0.8.jar:9.0.8]

              at java.lang.Thread.run(Unknown Source) [?:1.8.0_201]

      Caused by: java.lang.UnsupportedOperationException: cannot find loader; this dis

      tribution of PGX does not support reading from the given data source; given conf

      ig is {"max_num_connections":2,"format":"pg","loading":{"load_edge_label":true,"

      create_edge_id_mapping":true},"vertex_id_type":"long","db_engine":"RDBMS","usern

      ame":"infodba","error_handling":{},"name":"FORD_DATA","vertex_props":[{"type":"s

      tring","name":"puid"}],"edge_label":true,"password":"*******","jdbc_url":"jdbc:o

      racle:thin:@trv6s311:1521/pgdb","edge_props":[{"type":"string","name":"label","d

      efault":" "},{"type":"double","name":"weight","default":100.0}],"attributes":{}}

       

       

              at oracle.pgx.loaders.api.GraphIo.findFacade(GraphIo.java:95) ~[pgx-load

      er_api-3.2.0.jar:3.2.0]

              at oracle.pgx.engine.persistence.PersistenceManager.getLoader(Persistenc

      eManager.java:111) ~[pgx-engine-3.2.0.jar:3.2.0]

              at oracle.pgx.engine.persistence.PersistenceManager.readGraph(Persistenc

      eManager.java:130) ~[pgx-engine-3.2.0.jar:3.2.0]

              at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersis

      tenceImpl.java:481) ~[pgx-engine-3.2.0.jar:3.2.0]

              at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersis

      tenceImpl.java:474) ~[pgx-engine-3.2.0.jar:3.2.0]

              at oracle.pgx.engine.exec.Task.call(Task.java:320) ~[pgx-engine-3.2.0.ja

      r:3.2.0]

              at oracle.pgx.engine.exec.Task.run(Task.java:236) ~[pgx-engine-3.2.0.jar

      :3.2.0]

              at java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(Unknown

      Source) ~[?:1.8.0_201]

              at java.util.concurrent.ForkJoinTask.doExec(Unknown Source) ~[?:1.8.0_20

      1]

              at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(Unknown Source) ~

      [?:1.8.0_201]

              at java.util.concurrent.ForkJoinPool.runWorker(Unknown Source) ~[?:1.8.0

      _201]

              at java.util.concurrent.ForkJoinWorkerThread.run(Unknown Source) ~[?:1.8

      .0_201]