Forum Stats

  • 3,727,195 Users
  • 2,245,333 Discussions
  • 7,852,621 Comments

Discussions

Numeric Overflow code: PGX-ERROR-3I52CGGOJIZYK when running PGQL query in java

user8632123
user8632123 Member Posts: 120 Blue Ribbon

Hi,

I am getting an error "Numeric Overflow code: PGX-ERROR-3I52CGGOJIZYK" when running a PGQL query over java against the PGX server. The complete stack trace is below. I can't figure out what's wrong; very similar code ran successfully a few weeks back.

Any help would be appreciated.

Yours, user8632123.


08:57:02.094 [pgx-client-thread-1] ERROR oracle.pgx.client.PgxRemoteFuture - caught exception

oracle.pgx.common.NotFoundException: Numeric Overflow code: PGX-ERROR-3I52CGGOJIZYK

    at oracle.pgx.common.marshalers.ExceptionMarshaler.toUnserializedException(ExceptionMarshaler.java:99) ~[pgx-api-20.2.2.jar:20.2.2]

    at oracle.pgx.common.marshalers.ExceptionMarshaler.unmarshal(ExceptionMarshaler.java:123) ~[pgx-api-20.2.2.jar:20.2.2]

    at oracle.pgx.client.RemoteUtils.parseExceptionalResponse(RemoteUtils.java:130) ~[pgx-client-20.2.2.jar:20.2.2]

    at oracle.pgx.client.RemoteUtils.getResponseContent(RemoteUtils.java:98) ~[pgx-client-20.2.2.jar:20.2.2]

    at oracle.pgx.client.RemoteUtils.getResponseContent(RemoteUtils.java:66) ~[pgx-client-20.2.2.jar:20.2.2]

    at oracle.pgx.client.RemoteUtils.parse(RemoteUtils.java:153) ~[pgx-client-20.2.2.jar:20.2.2]

    at oracle.pgx.client.PgxRemoteFuture.executeRequest(PgxRemoteFuture.java:115) ~[pgx-client-20.2.2.jar:20.2.2]

    at oracle.pgx.client.PgxRemoteFuture.lambda$fetchRemoteResultAsync$3(PgxRemoteFuture.java:221) ~[pgx-client-20.2.2.jar:20.2.2]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) [?:?]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) [?:?]

    at java.lang.Thread.run(Thread.java:844) [?:?]

Exception in thread "main" java.util.concurrent.ExecutionException: oracle.pgx.common.NotFoundException: Numeric Overflow code: PGX-ERROR-3I52CGGOJIZYK

    at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:395)

    at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1999)

    at oracle.pgx.api.PgxFuture.get(PgxFuture.java:99)

    at oracle.pgx.api.PgxSession.readGraphWithProperties(PgxSession.java:1971)

    at de.deutschebahn.netx.teamrelations.PgqlOverPgx2.doSomething(PgqlOverPgx2.java:111)

    at de.deutschebahn.netx.teamrelations.PgqlOverPgx2.main(PgqlOverPgx2.java:105)

Caused by: oracle.pgx.common.NotFoundException: Numeric Overflow code: PGX-ERROR-3I52CGGOJIZYK

    at oracle.pgx.common.marshalers.ExceptionMarshaler.toUnserializedException(ExceptionMarshaler.java:99)

    at oracle.pgx.common.marshalers.ExceptionMarshaler.unmarshal(ExceptionMarshaler.java:123)

    at oracle.pgx.client.RemoteUtils.parseExceptionalResponse(RemoteUtils.java:130)

    at oracle.pgx.client.RemoteUtils.getResponseContent(RemoteUtils.java:98)

    at oracle.pgx.client.RemoteUtils.getResponseContent(RemoteUtils.java:66)

    at oracle.pgx.client.RemoteUtils.parse(RemoteUtils.java:153)

    at oracle.pgx.client.PgxRemoteFuture.executeRequest(PgxRemoteFuture.java:115)

    at oracle.pgx.client.PgxRemoteFuture.lambda$fetchRemoteResultAsync$3(PgxRemoteFuture.java:221)

    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)

    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)

    at java.base/java.lang.Thread.run(Thread.java:844)

Best Answer

  • oskarvanrest-Oracle
    oskarvanrest-Oracle Member Posts: 14 Employee
    edited April 12 Accepted Answer

    Hi,

    I think the problem is that sys_guids are 128 bits but the largest ID data type in PGX is the Java Long, which is only 64 bits.

    You could try to reduce the guids to 64 bits but I think then the chance of getting a collision becomes too large if you have a large dataset, so ideally you may want to try to use an auto-increment column (SEQUENCE) instead.

    The error you show is the client-side stacktrace, which does not contain much information, so I'm not sure where exactly it fails.

    If you open the server-side log (/var/log/oracle/graph/pgx-server.log) you should be able to find the "real" stack trace by searching for the same error code PGX-ERROR-3I52CGGOJIZYK

Answers

  • user8632123
    user8632123 Member Posts: 120 Blue Ribbon
    edited March 23

    PS: We may have located the problem: a colleague inserted vertices and edges using sys_guids as IDs. Apparently the PGX server cannot handle those. This would mean that the database structure and the PGX code have a certain discrepancy (the one allowing unrestricted Oracle numbers, the other probably using java longs) and I would ask you to log a bug on this.

  • oskarvanrest-Oracle
    oskarvanrest-Oracle Member Posts: 14 Employee
    edited April 12 Accepted Answer

    Hi,

    I think the problem is that sys_guids are 128 bits but the largest ID data type in PGX is the Java Long, which is only 64 bits.

    You could try to reduce the guids to 64 bits but I think then the chance of getting a collision becomes too large if you have a large dataset, so ideally you may want to try to use an auto-increment column (SEQUENCE) instead.

    The error you show is the client-side stacktrace, which does not contain much information, so I'm not sure where exactly it fails.

    If you open the server-side log (/var/log/oracle/graph/pgx-server.log) you should be able to find the "real" stack trace by searching for the same error code PGX-ERROR-3I52CGGOJIZYK

  • user8632123
    user8632123 Member Posts: 120 Blue Ribbon

    Hi oskarvanrest-Oracle,


    thanks for your reply! We have switched to using sequences. Also thanks for pointing out the correct log file, where I located the server stack trace (and am appending it below for information).


    Yours, user8632123.


    08:56:59,663 [https-jsse-nio-7007-exec-5] INFO GraphResource - create graph. graphName = null config = {"loading":{},"format":"pg","db_engine":"RDBMS","attributes":{},"password":"*******","jdbc_url":"jdbc:oracle:thin:@//******","name":"TEAMRELATIONS","vertex_props":[{"name":"PRODUCT_NAME","dimension":0,"type":"string"}],"vertex_id_type":"long","error_handling":{},"edge_props":[],"username":"ntdc02"}

    08:56:59,684 [Thread pool #29] INFO JdbcUtils - connect using credentials/datasource in graph config

    08:57:00,235 [Thread pool #29] INFO JdbcUtils - connect using credentials/datasource in graph config

    08:57:00,235 [Thread pool #28] INFO JdbcUtils - connect using credentials/datasource in graph config

    08:57:00,765 [Thread pool #28] WARN CommonAbstractReaderTask - vertex with ID 2081669100894589164 does not have property PRODUCT_NAME

    08:57:00,770 [Thread pool #29] INFO Task - >> [ERROR] LoaderException: READ_GRAPH failed

    08:57:00,770 [Thread pool #29] INFO Task - ParallelError of 1 java.util.NoSuchElementException: Numeric Overflow

    oracle.pgx.runtime.LoaderException: ParallelError of 1 java.util.NoSuchElementException: Numeric Overflow

    at oracle.pgx.loaders.api.LoaderUtils.batchInvoke(LoaderUtils.java:73) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ReaderTaskContext$1.batchInvoke(ReaderTaskContext.java:80) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:402) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:333) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.processSeparatedData(PgxLoader.java:188) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.loadGraphAndProperties(PgxLoader.java:146) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.AbstractLoader.loadGraphAndProperties(AbstractLoader.java:102) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.persistence.PersistenceManager.readGraph(PersistenceManager.java:139) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:604) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:597) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.call(Task.java:358) [pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.run(Task.java:278) [pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.RtsTask.run(RtsTask.java:52) [pgx-engine-20.2.2.jar:20.2.2]

    at com.oracle.rts.Job$1.run(Job.java:146) [callisto-rts-2.7.jar:?]

    Caused by: oracle.pgx.common.ParallelExecutionException: ParallelError of 1 java.util.NoSuchElementException: Numeric Overflow

    at oracle.pgx.runtime.parallel.RtsStrategy.executeAndCatchParallelError(RtsStrategy.java:177) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeParallel(RtsStrategy.java:161) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.ThreadPool.executeParallel(ThreadPool.java:164) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.Parallel.executeParallel(Parallel.java:89) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.LoaderUtils.batchInvoke(LoaderUtils.java:71) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    ... 13 more

    Caused by: oracle.pgx.common.ParallelExecutionException: java.util.NoSuchElementException: Numeric Overflow

    at oracle.pgx.runtime.parallel.RtsStrategy.lambda$null$7(RtsStrategy.java:166) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at com.oracle.rts.ParallelFor.lambda$parallelFor$4(ParallelFor.java:208) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.LongPairConsumer.doSegment(LongPairConsumer.java:22) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.UpcallHandler.run(UpcallHandler.java:30) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.RTS.parallelLoopJNI(Native Method) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.ParallelFor.lambda$parallelFor$5(ParallelFor.java:213) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.TagContext.run(TagContext.java:301) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.ParallelFor.parallelFor(ParallelFor.java:212) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.TagContext.parallelFor(TagContext.java:269) ~[callisto-rts-2.7.jar:?]

    at oracle.pgx.runtime.parallel.RtsStrategy.lambda$executeParallel$8(RtsStrategy.java:162) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeAndCatchParallelError(RtsStrategy.java:173) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeParallel(RtsStrategy.java:161) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.ThreadPool.executeParallel(ThreadPool.java:164) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.Parallel.executeParallel(Parallel.java:89) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.LoaderUtils.batchInvoke(LoaderUtils.java:71) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    ... 13 more

    Caused by: java.util.NoSuchElementException: Numeric Overflow

    at oracle.pgx.loaders.db.pg.rdbms.RdbmsPgIterator.next(RdbmsPgIterator.java:58) ~[opg-pg_rdbms_loader-20.4.0.jar:20.4.0]

    at oracle.pgx.loaders.db.pg.rdbms.RdbmsPgIterator.next(RdbmsPgIterator.java:18) ~[opg-pg_rdbms_loader-20.4.0.jar:20.4.0]

    at oracle.pgx.loaders.db.pg.AbstractPgParser.getNextVertex(AbstractPgParser.java:80) ~[pgx-pg_common-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.VertexReaderTask.loadElements(VertexReaderTask.java:66) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ElementReaderTask.call(ElementReaderTask.java:338) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ElementReaderTask.call(ElementReaderTask.java:41) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.lambda$null$7(RtsStrategy.java:164) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at com.oracle.rts.ParallelFor.lambda$parallelFor$4(ParallelFor.java:208) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.LongPairConsumer.doSegment(LongPairConsumer.java:22) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.UpcallHandler.run(UpcallHandler.java:30) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.RTS.parallelLoopJNI(Native Method) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.ParallelFor.lambda$parallelFor$5(ParallelFor.java:213) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.TagContext.run(TagContext.java:301) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.ParallelFor.parallelFor(ParallelFor.java:212) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.TagContext.parallelFor(TagContext.java:269) ~[callisto-rts-2.7.jar:?]

    at oracle.pgx.runtime.parallel.RtsStrategy.lambda$executeParallel$8(RtsStrategy.java:162) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeAndCatchParallelError(RtsStrategy.java:173) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeParallel(RtsStrategy.java:161) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.ThreadPool.executeParallel(ThreadPool.java:164) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.Parallel.executeParallel(Parallel.java:89) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.LoaderUtils.batchInvoke(LoaderUtils.java:71) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    ... 13 more

    08:57:02,064 [https-jsse-nio-7007-exec-3] ERROR AbstractExceptionMapper - exception mapper caught exception with code PGX-ERROR-3I52CGGOJIZYK

    java.util.concurrent.ExecutionException: oracle.pgx.runtime.LoaderException: ParallelError of 1 java.util.NoSuchElementException: Numeric Overflow

    at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:357) ~[?:1.8.0_282]

    at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1908) ~[?:1.8.0_282]

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

    at oracle.pgx.rest.PgxFutureWrapper.getAsJson(PgxFutureWrapper.java:66) ~[pgx-webapp_common-20.2.2.jar:20.2.2]

    at oracle.pgx.rest.EndpointUtils.checkHttpMethod(EndpointUtils.java:248) ~[pgx-webapp_common-20.2.2.jar:20.2.2]

    at oracle.pgx.rest.endpoints.FutureResource.getFuture(FutureResource.java:118) ~[pgx-webapp_common-20.2.2.jar:20.2.2]

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

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_282]

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_282]

    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_282]

    at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$6(ResourceMethodInvocationHandlerFactory.java:52) ~[jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176) ~[jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:469) ~[jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:391) ~[jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:80) ~[jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:253) [jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) [jersey-common-2.29.1.jar:?]

    at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) [jersey-common-2.29.1.jar:?]

    at org.glassfish.jersey.internal.Errors.process(Errors.java:292) [jersey-common-2.29.1.jar:?]

    at org.glassfish.jersey.internal.Errors.process(Errors.java:274) [jersey-common-2.29.1.jar:?]

    at org.glassfish.jersey.internal.Errors.process(Errors.java:244) [jersey-common-2.29.1.jar:?]

    at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) [jersey-common-2.29.1.jar:?]

    at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:232) [jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) [jersey-server-2.29.1.jar:?]

    at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:392) [jersey-container-servlet-core-2.29.1.jar:?]

    at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) [jersey-container-servlet-core-2.29.1.jar:?]

    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:365) [jersey-container-servlet-core-2.29.1.jar:?]

    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:318) [jersey-container-servlet-core-2.29.1.jar:?]

    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) [jersey-container-servlet-core-2.29.1.jar:?]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at oracle.pgx.rest.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:43) [pgx-webapp_common-20.2.2.jar:20.2.2]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at oracle.pgx.rest.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:43) [pgx-webapp_common-20.2.2.jar:20.2.2]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at oracle.pgx.rest.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:43) [pgx-webapp_common-20.2.2.jar:20.2.2]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at oracle.pgx.rest.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:43) [pgx-webapp_common-20.2.2.jar:20.2.2]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.13.2.jar:2.13.2]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_282]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_282]

    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.37.jar:9.0.37]

    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_282]

    Caused by: oracle.pgx.runtime.LoaderException: ParallelError of 1 java.util.NoSuchElementException: Numeric Overflow

    at oracle.pgx.loaders.api.LoaderUtils.batchInvoke(LoaderUtils.java:73) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ReaderTaskContext$1.batchInvoke(ReaderTaskContext.java:80) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:402) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:333) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.processSeparatedData(PgxLoader.java:188) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.loadGraphAndProperties(PgxLoader.java:146) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.AbstractLoader.loadGraphAndProperties(AbstractLoader.java:102) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.persistence.PersistenceManager.readGraph(PersistenceManager.java:139) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:604) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:597) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.call(Task.java:358) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.run(Task.java:278) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.RtsTask.run(RtsTask.java:52) ~[pgx-engine-20.2.2.jar:20.2.2]

    at com.oracle.rts.Job$1.run(Job.java:146) ~[callisto-rts-2.7.jar:?]

    Caused by: oracle.pgx.common.ParallelExecutionException: ParallelError of 1 java.util.NoSuchElementException: Numeric Overflow

    at oracle.pgx.runtime.parallel.RtsStrategy.executeAndCatchParallelError(RtsStrategy.java:177) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeParallel(RtsStrategy.java:161) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.ThreadPool.executeParallel(ThreadPool.java:164) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.Parallel.executeParallel(Parallel.java:89) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.LoaderUtils.batchInvoke(LoaderUtils.java:71) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ReaderTaskContext$1.batchInvoke(ReaderTaskContext.java:80) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:402) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:333) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.processSeparatedData(PgxLoader.java:188) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.loadGraphAndProperties(PgxLoader.java:146) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.AbstractLoader.loadGraphAndProperties(AbstractLoader.java:102) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.persistence.PersistenceManager.readGraph(PersistenceManager.java:139) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:604) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:597) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.call(Task.java:358) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.run(Task.java:278) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.RtsTask.run(RtsTask.java:52) ~[pgx-engine-20.2.2.jar:20.2.2]

    at com.oracle.rts.Job$1.run(Job.java:146) ~[callisto-rts-2.7.jar:?]

    Caused by: oracle.pgx.common.ParallelExecutionException: java.util.NoSuchElementException: Numeric Overflow

    at oracle.pgx.runtime.parallel.RtsStrategy.lambda$null$7(RtsStrategy.java:166) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at com.oracle.rts.ParallelFor.lambda$parallelFor$4(ParallelFor.java:208) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.LongPairConsumer.doSegment(LongPairConsumer.java:22) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.UpcallHandler.run(UpcallHandler.java:30) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.RTS.parallelLoopJNI(Native Method) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.ParallelFor.lambda$parallelFor$5(ParallelFor.java:213) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.TagContext.run(TagContext.java:301) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.ParallelFor.parallelFor(ParallelFor.java:212) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.TagContext.parallelFor(TagContext.java:269) ~[callisto-rts-2.7.jar:?]

    at oracle.pgx.runtime.parallel.RtsStrategy.lambda$executeParallel$8(RtsStrategy.java:162) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeAndCatchParallelError(RtsStrategy.java:173) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeParallel(RtsStrategy.java:161) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.ThreadPool.executeParallel(ThreadPool.java:164) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.Parallel.executeParallel(Parallel.java:89) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.LoaderUtils.batchInvoke(LoaderUtils.java:71) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ReaderTaskContext$1.batchInvoke(ReaderTaskContext.java:80) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:402) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:333) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.processSeparatedData(PgxLoader.java:188) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.loadGraphAndProperties(PgxLoader.java:146) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.AbstractLoader.loadGraphAndProperties(AbstractLoader.java:102) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.persistence.PersistenceManager.readGraph(PersistenceManager.java:139) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:604) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:597) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.call(Task.java:358) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.run(Task.java:278) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.RtsTask.run(RtsTask.java:52) ~[pgx-engine-20.2.2.jar:20.2.2]

    at com.oracle.rts.Job$1.run(Job.java:146) ~[callisto-rts-2.7.jar:?]

    Caused by: java.util.NoSuchElementException: Numeric Overflow

    at oracle.pgx.loaders.db.pg.rdbms.RdbmsPgIterator.next(RdbmsPgIterator.java:58) ~[opg-pg_rdbms_loader-20.4.0.jar:20.4.0]

    at oracle.pgx.loaders.db.pg.rdbms.RdbmsPgIterator.next(RdbmsPgIterator.java:18) ~[opg-pg_rdbms_loader-20.4.0.jar:20.4.0]

    at oracle.pgx.loaders.db.pg.AbstractPgParser.getNextVertex(AbstractPgParser.java:80) ~[pgx-pg_common-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.VertexReaderTask.loadElements(VertexReaderTask.java:66) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ElementReaderTask.call(ElementReaderTask.java:338) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ElementReaderTask.call(ElementReaderTask.java:41) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.lambda$null$7(RtsStrategy.java:164) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at com.oracle.rts.ParallelFor.lambda$parallelFor$4(ParallelFor.java:208) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.LongPairConsumer.doSegment(LongPairConsumer.java:22) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.UpcallHandler.run(UpcallHandler.java:30) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.RTS.parallelLoopJNI(Native Method) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.ParallelFor.lambda$parallelFor$5(ParallelFor.java:213) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.TagContext.run(TagContext.java:301) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.ParallelFor.parallelFor(ParallelFor.java:212) ~[callisto-rts-2.7.jar:?]

    at com.oracle.rts.TagContext.parallelFor(TagContext.java:269) ~[callisto-rts-2.7.jar:?]

    at oracle.pgx.runtime.parallel.RtsStrategy.lambda$executeParallel$8(RtsStrategy.java:162) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeAndCatchParallelError(RtsStrategy.java:173) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.parallel.RtsStrategy.executeParallel(RtsStrategy.java:161) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.ThreadPool.executeParallel(ThreadPool.java:164) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.runtime.Parallel.executeParallel(Parallel.java:89) ~[pgx-runtime-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.LoaderUtils.batchInvoke(LoaderUtils.java:71) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ReaderTaskContext$1.batchInvoke(ReaderTaskContext.java:80) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:402) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.ParallelElementReader.readVertexData(ParallelElementReader.java:333) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.processSeparatedData(PgxLoader.java:188) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.PgxLoader.loadGraphAndProperties(PgxLoader.java:146) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.loaders.api.AbstractLoader.loadGraphAndProperties(AbstractLoader.java:102) ~[pgx-loader_api-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.persistence.PersistenceManager.readGraph(PersistenceManager.java:139) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:604) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersistenceImpl.java:597) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.call(Task.java:358) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.Task.run(Task.java:278) ~[pgx-engine-20.2.2.jar:20.2.2]

    at oracle.pgx.engine.exec.RtsTask.run(RtsTask.java:52) ~[pgx-engine-20.2.2.jar:20.2.2]

    at com.oracle.rts.Job$1.run(Job.java:146) ~[callisto-rts-2.7.jar:?]

    11:05:00,072 [connection-pool-cleanup] INFO ConnectionPoolManager - destroying connection pool for NTDC02

Sign In or Register to comment.