Getting error while resuming the task efter adding more tables SAP ODP

toni_lajsner — Tue, 28 May 2024 11:21:03 GMT

Hi

We are getting following error when we add more tables to our current task that is connected to SAP ODP and Destination is Delta Bricks deltalakehouse .

following info is copied from rependsrv:

[sourcecapture ] [ERROR ] [] An error occurred during capture changes java.lang.StringIndexOutOfBoundsException: begin 250, end 256, length 250

at java.lang.String.substring(Unknown Source) ~[?:?]

at com.qlik.sap.endpoints.odp.SapOdpSourceEndpointActual.parseRowData(SapOdpSourceEndpointActual.java:1231) ~[sap-odp-source-endpoint.jar:1.2.3]

at com.qlik.sap.endpoints.odp.SapOdpSourceEndpointActual.loadData(SapOdpSourceEndpointActual.java:784) ~[sap-odp-source-endpoint.jar:1.2.3]

at com.qlik.sap.endpoints.odp.SapOdpSourceEndpointActual.captureChanges(SapOdpSourceEndpointActual.java:734) ~[sap-odp-source-endpoint.jar:1.2.3]

at com.qlik.sap.endpoints.odp.SapOdpSourceEndpoint.captureChanges(SapOdpSourceEndpoint.java:74) ~[sap-odp-source-endpoint.jar:1.2.3]

at com.attunity.replicate.rependsrv.sdk.internal.CustomEndpointSDK$1.write(CustomEndpointSDK.java:273) ~[attunity-custom-endpoint-1.5.21.jar:1.5.21]

at org.glassfish.jersey.message.internal.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:78) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.message.internal.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:60) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.invokeWriteTo(WriterInterceptorExecutor.java:265) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.aroundWriteTo(WriterInterceptorExecutor.java:250) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.server.internal.JsonWithPaddingInterceptor.aroundWriteTo(JsonWithPaddingInterceptor.java:106) ~[jersey-server-2.25.1.jar:?]

at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.server.internal.MappableExceptionWrapperInterceptor.aroundWriteTo(MappableExceptionWrapperInterceptor.java:86) ~[jersey-server-2.25.1.jar:?]

at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.message.internal.MessageBodyFactory.writeTo(MessageBodyFactory.java:1130) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.server.ServerRuntime$Responder.writeResponse(ServerRuntime.java:711) ~[jersey-server-2.25.1.jar:?]

at org.glassfish.jersey.server.ServerRuntime$Responder.processResponse(ServerRuntime.java:444) ~[jersey-server-2.25.1.jar:?]

at org.glassfish.jersey.server.ServerRuntime$Responder.process(ServerRuntime.java:434) ~[jersey-server-2.25.1.jar:?]

at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:329) ~[jersey-server-2.25.1.jar:?]

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

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

at org.glassfish.jersey.internal.Errors.process(Errors.java:315) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.internal.Errors.process(Errors.java:297) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.internal.Errors.process(Errors.java:267) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) ~[jersey-common-2.25.1.jar:?]

at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) ~[jersey-server-2.25.1.jar:?]

at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) ~[jersey-server-2.25.1.jar:?]

at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) ~[jersey-container-servlet-core-2.25.1.jar:?]

at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) ~[jersey-container-servlet-core-2.25.1.jar:?]

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) ~[jersey-container-servlet-core-2.25.1.jar:?]

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) ~[jersey-container-servlet-core-2.25.1.jar:?]

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) ~[jersey-container-servlet-core-2.25.1.jar:?]

at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[jetty-servlet-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550) ~[jetty-servlet-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[jetty-servlet-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:713) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487) ~[jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732) [jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479) [jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) [jetty-server-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [jetty-io-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [jetty-io-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [jetty-util-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [jetty-util-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [jetty-util-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [jetty-util-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) [jetty-util-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [jetty-util-9.4.46.v20220331.jar:9.4.46.v20220331]

at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [jetty-util-9.4.46.v20220331.jar:9.4.46.v20220331]

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

Only thing that we can do efter , is to remove the added tables and RELOAD Task again !

Following error is when we are trying to only resume the task after we add new tables to it :

: Line 77: 00016516: 2024-05-28T09:03:41 [SOURCE_CAPTURE ]E: An error occurred during capture changes (custom_endpoint_util.c:1155)
Line 78: 00016516: 2024-05-28T09:03:41 [SOURCE_CAPTURE ]E: begin 250, end 256, length 250 [1024719] (custom_endpoint_capture.c:800)
Line 79: 00016516: 2024-05-28T09:03:41 [SOURCE_CAPTURE ]E: Capture loop failed [1024719] (custom_endpoint_capture.c:240)
Line 83: 00016516: 2024-05-28T09:03:41 [SOURCE_CAPTURE ]E: Error executing source loop [1024719] (streamcomponent.c:1942)
Line 84: 00016516: 2024-05-28T09:03:41 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_QS1 [1024719] (subtask.c:1433)
Line 85: 00016516: 2024-05-28T09:03:41 [SOURCE_CAPTURE ]E: Stream component 'st_0_QS1' terminated [1024719] (subtask.c:1602)

Re: Getting error while resuming the task efter adding more tables SAP ODP

RajyaLakshmi — Tue, 28 May 2024 11:50:02 GMT

Hi @toni_lajsner ,

Good day and Thank you for contacting Qlik community.

Please provide below information:

1. What is your Qlik replicate version?

2. Is this issue with one task or with all the tasks connected to SAP ODP?

3. Have you tried reloading the task to resolve the issue?

Best Regards,

Rajya Lakshmi

Re: Getting error while resuming the task efter adding more tables SAP ODP

toni_lajsner — Tue, 28 May 2024 12:00:30 GMT

Hi,

Qlik Replicate version is 2023.5.0.322.

The issue is manifesting itself often, especially for tasks that have over 15 tables.

For the moment, we have not reloaded the task, but we will do so shortly without the two tables that were added additionally.

Re: Getting error while resuming the task efter adding more tables SAP ODP

SushilKumar — Wed, 29 May 2024 03:32:09 GMT

Hello @toni_lajsner

Thanks for reaching out to Qlik via Qlik Community Support page. Such issue require through analysis of Settings, hence request you to reach out to technical Support via a case and provide Diagnostics package .

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/1815056

Regards,

Sushil Kumar

Re: Getting error while resuming the task efter adding more tables SAP ODP

sureshkumar — Fri, 31 May 2024 07:18:55 GMT

Hello @toni_lajsner

I would suggest capturing the information with SOURCE_CAPTURE set to VERBOSE and check the logs why its failing. If no useful information from the log, then kindly create a support ticket with us to analyze further.

Regards,

Suresh

Re: Getting error while resuming the task efter adding more tables SAP ODP

Kent_Feng — Mon, 03 Jun 2024 00:40:50 GMT

Hi @toni_lajsner

I agreed with Suresh, as the error occurred during source_capture, you need to increase it to verbose to collect more information, also the task got errors after adding the tables, so the root cause should be related to those tables.

topic Re: Getting error while resuming the task efter adding more tables SAP ODP in Qlik Replicate

Getting error while resuming the task efter adding more tables SAP ODP

Re: Getting error while resuming the task efter adding more tables SAP ODP

Re: Getting error while resuming the task efter adding more tables SAP ODP

Re: Getting error while resuming the task efter adding more tables SAP ODP

Re: Getting error while resuming the task efter adding more tables SAP ODP

Re: Getting error while resuming the task efter adding more tables SAP ODP