Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us on Sept. 17 to hear how our new GenAI Assistant empowers data professionals: REGISTER
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
toni_lajsner
Contributor III
Contributor III
‎2024-05-28 07:21 AM

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

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)

 

 

Labels (2)
Labels
484 Views
5 Replies
RajyaLakshmi
Support
Support
‎2024-05-28 07:50 AM

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

 

465 Views
toni_lajsner
Contributor III
Contributor III
‎2024-05-28 08:00 AM
Author

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.

456 Views
0 Likes
SushilKumar
Support
Support
‎2024-05-28 11:32 PM

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/...

 

Regards,

Sushil Kumar

386 Views
sureshkumar
Support
Support
‎2024-05-31 03:18 AM

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

359 Views
Kent_Feng
Support
Support
‎2024-06-02 08:40 PM

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.

*** Greetings from Down Under ***
346 Views