Error when replicating from sap extractor

[mhernandez]

hi
currently qlik replicate is presenting a problem with SAP extractors and it gives me the following log

00003848: 2023-09-05T15:36:50:772408 [SOURCE_UNLOAD ]T: Exception thrown, Details: ~{AwAAAEHupwwCWowWSzGM9KB3XVAU7InCpyTIY0X21WZo/UOERNLUJBnN/qQw4byz0FXjPWEWhTnYmcMkQ21pazrcFcqcQRAlJaJ5bYDzuKbXVFI8F2vmFSoNLAEAFUXcoUSM/GK32jAAM7xfe+GFOljisxz2ZDsgEOFlFIMWWb03a3LJifaMygYwzbBWQKS8QXhZ8A==}~ [1024719] (custom_endpoint_unload.c:258)
00003848: 2023-09-05T15:36:50:772408 [SOURCE_UNLOAD ]T: Failed during unload [1024719] (custom_endpoint_unload.c:442)
00003848: 2023-09-05T15:36:50:772408 [SOURCE_UNLOAD ]E: Exception thrown, Details: ~{AwAAAEHupwwCWowWSzGM9KB3XVAU7InCpyTIY0X21WZo/UOERNLUJBnN/qQw4byz0FXjPWEWhTnYmcMkQ21pazrcFcqcQRAlJaJ5bYDzuKbXVFI8F2vmFSoNLAEAFUXcoUSM/GK32jAAM7xfe+GFOljisxz2ZDsgEOFlFIMWWb03a3LJifaMygYwzbBWQKS8QXhZ8A==}~ [1024719] (custom_endpoint_unload.c:258)
00003848: 2023-09-05T15:36:50:772408 [SOURCE_UNLOAD ]E: Failed during unload [1024719] (custom_endpoint_unload.c:442)
00003848: 2023-09-05T15:36:50:785394 [SOURCE_UNLOAD ]T: Error executing source loop [1024719] (streamcomponent.c:1942)
00003848: 2023-09-05T15:36:50:785394 [TASK_MANAGER ]T: Stream component failed at subtask 1, component st_1_SAP_Extractor [1024719] (subtask.c:1433)
00003848: 2023-09-05T15:36:50:785394 [TASK_MANAGER ]T: Thread stopped for component st_1_SAP_Extractor (subtask.c:1440)
00003848: 2023-09-05T15:36:50:785394 [SOURCE_UNLOAD ]T: Stream component 'st_1_SAP_Extractor' terminated [1024719] (subtask.c:1602)
00007568: 2023-09-05T15:36:50:797413 [TASK_MANAGER ]I: Task error notification received from subtask 1, thread 0, status 1024719 (replicationtask.c:3520)
00007568: 2023-09-05T15:36:50:797413 [TASK_MANAGER ]T: Subtask #1 is going down (replicationtask_util.c:559)
00007568: 2023-09-05T15:36:50:797413 [TASK_MANAGER ]T: Sending control record to component st_1_Null. Command is 'STOP', First table id is '0' (subtask.c:1989)
00007568: 2023-09-05T15:36:50:797413 [TASK_MANAGER ]T: Stop command for component st_1_Null (subtask.c:1995)
00007876: 2023-09-05T15:36:50:798410 [TASK_MANAGER ]T: Thread stopped for component st_1_Null (subtask.c:1440)
00007568: 2023-09-05T15:36:50:798410 [TASK_MANAGER ]T: Going to free subtask #1 (subtask.c:582)
00003848: 2023-09-05T15:36:50:785394 [SOURCE_UNLOAD ]E: Error executing source loop [1024719] (streamcomponent.c:1942)
00003848: 2023-09-05T15:36:50:785394 [TASK_MANAGER ]E: Stream component failed at subtask 1, component st_1_SAP_Extractor [1024719] (subtask.c:1433)
00003848: 2023-09-05T15:36:50:785394 [SOURCE_UNLOAD ]E: Stream component 'st_1_SAP_Extractor' terminated [1024719] (subtask.c:1602)
00007568: 2023-09-05T15:36:50:900386 [TASK_MANAGER ]I: Subtask #1 ended (replicationtask_util.c:591)
00007568: 2023-09-05T15:36:50:900386 [TASK_MANAGER ]I: Reloading table 7 because subtask #1 finished with error (replicationtask.c:2694)
00007568: 2023-09-05T15:36:50:906386 [TASK_MANAGER ]T: Create thread for component st_1_SAP_Extractor (subtask.c:977)
00007568: 2023-09-05T15:36:50:906386 [TASK_MANAGER ]T: Create thread for component st_1_Null (subtask.c:977)
00006940: 2023-09-05T15:36:51:157392 [TASK_MANAGER ]T: Prepare component st_1_SAP_Extractor (subtask.c:895)
00007704: 2023-09-05T15:36:51:160419 [TARGET_LOAD ]I: Feature flag test_flag at index 0 = test flag value (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag test_flag at index 1 = test flag value 2 (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag test_flag_deprecated at index 0 = deprecated 1 (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag test_flag_deprecated at index 1 = deprecated 2 (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag env_flag_test at index 0 = environment flag (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag env_flag_test_deprecated at index 0 = 1 (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag env_flag_test_deprecated at index 1 = 2 (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag task_settings_flag_test at index 0 = task flag (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag task_settings_flag_test_deprecated at index 0 = x (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TARGET_LOAD ]I: Feature flag task_settings_flag_test_deprecated at index 1 = y (nulltarget_imp.c:39)
00007704: 2023-09-05T15:36:51:161420 [TASK_MANAGER ]T: Prepare component st_1_Null (subtask.c:895)
00007704: 2023-09-05T15:36:51:417393 [TASK_MANAGER ]T: Starting component st_1_Null (subtask.c:1423)
00006940: 2023-09-05T15:36:51:459072 [TASK_MANAGER ]T: Starting component st_1_SAP_Extractor (subtask.c:1423)
00007568: 2023-09-05T15:36:51:459072 [TASK_MANAGER ]T: Full load subtask #1 initialized (replicationtask.c:2950)
00007568: 2023-09-05T15:36:51:459072 [TASK_MANAGER ]T: Sending control record to component st_1_Null. Command is 'LOAD_TABLE', First table id is '0' (subtask.c:1989)
00007568: 2023-09-05T15:36:51:484090 [TASK_MANAGER ]T: Sending control record to component st_1_SAP_Extractor. Command is 'UNLOAD_TABLE', First table id is '7' (subtask.c:1989)
00007568: 2023-09-05T15:36:51:484090 [TASK_MANAGER ]I: Start loading table ''.'0MATERIAL_ATTR' (Id = 7) by subtask 1. Start load timestamp 000604A36CC7A341 (replicationtask_util.c:755)
00006940: 2023-09-05T15:36:51:484090 [SOURCE_UNLOAD ]T: Command 'UNLOAD_TABLE' received in component 'st_1_SAP_Extractor' (streamcomponent.c:2358)
00006940: 2023-09-05T15:36:51:484090 [SOURCE_UNLOAD ]T: Going to retrieve metadata of the table id 7 (endpointshell.c:3889)
00006940: 2023-09-05T15:36:51:484090 [SOURCE_UNLOAD ]T: Getting dataset for .0MATERIAL_ATTR (custom_endpoint_metadata.c:118)
00006940: 2023-09-05T15:36:51:613082 [SOURCE_UNLOAD ]T: Order by '', Resume Where '', Transformation Where '' (endpointshell.c:8945)
00006940: 2023-09-05T15:36:51:613082 [SOURCE_UNLOAD ]T: Sending load start for table 7 table owner and name 0MATERIAL_ATTR at st_1_SAP_Extractor (endpointshell.c:961)
00006940: 2023-09-05T15:36:56:627412 [SOURCE_UNLOAD ]W: Existing extraction job found for 0MATERIAL_ATTR. Will not send second request to delete table entries and start extraction job. (custom_endpoint_util.c:1152)
00006940: 2023-09-05T15:38:21:213460 [SOURCE_UNLOAD ]E: Failed to convert value for column 'HOEHE' at row 23348 (custom_endpoint_util.c:1155)
00006940: 2023-09-05T15:38:21:221451 [SOURCE_UNLOAD ]E: An error occurred unloading dataset: .0MATERIAL_ATTR
java.lang.Exception: Exception thrown, Details: ~{AwAAAEHupwwCWowWSzGM9KB3XVAU7InCpyTIY0X21WZo/UOERNLUJBnN/qQw4byz0FXjPWEWhTnYmcMkQ21pazrcFcqcQRAlJaJ5bYDzuKbXVFI8F2vmFSoNLAEAFUXcoUSM/GK32jAAM7xfe+GFOljisxz2ZDsgEOFlFIMWWb03a3LJifaMygYwzbBWQKS8QXhZ8A==}~
at com.qlik.attunity.endpoints.sapextractor.SapExtractorSourceEndpointActual.loadData_(SapExtractorSourceEndpointActual.java:492)
at com.qlik.attunity.endpoints.sapextractor.SapExtractorSourceEndpointActual.unloadDataset(SapExtractorSourceEndpointActual.java:295)
at com.qlik.attunity.endpoints.sapextractor.SapExtractorSourceEndpoint.unloadDataset(SapExtractorSourceEndpoint.java:53)
at com.attunity.replicate.rependsrv.sdk.internal.CustomEndpointSDK$2.write(CustomEndpointSDK.java:327)
at org.glassfish.jersey.message.internal.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:78)
at org.glassfish.jersey.message.internal.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:60)
at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.invokeWriteTo(WriterInterceptorExecutor.java:265)
at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.aroundWriteTo(WriterInterceptorExecutor.java:250)
at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162)
at org.glassfish.jersey.server.internal.JsonWithPaddingInterceptor.aroundWriteTo(JsonWithPaddingInterceptor.java:106)
at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162)
at org.glassfish.jersey.server.internal.MappableExceptionWrapperInterceptor.aroundWriteTo(MappableExceptionWrapperInterceptor.java:86)
at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162)
at org.glassfish.jersey.message.internal.MessageBodyFactory.writeTo(MessageBodyFactory.java:1130)

[Dana_Baldwin]

Hi @mhernandez 

The details of the error message are encrypted in the task log. I suggest please opening a support case and attaching a diagnostics package and the log.key file so we can decrypt the log files. You can find the log.key file here:

• For decrypting a task's log file: <REPLICATE_INSTALL_DIR>\data\tasks\<task-name>

Thanks,

Dana

[john_wang]

Hello @mhernandez ,

Besides @Dana_Baldwin comment I'd like to share more detailed information about the task log file decryption:

How to Decrypt Qlik Replicate Verbose Task Log Files

Hope this helps.

Regards,

John.

[Bill_Steinagle]

@mhernandez 

Hello, wanted to share along with the QDI Team as posted for the SAP Extractor and errors shown from the log messages posted. For this type of condition with the Table can you have the SAP Admin check to confirm the Data Type from the SE16 TCODE in SAP for this Column and ensure its mapped properly to the Extractor Table definition? I would also ensure the datatype is a Support datatype for the Extractor as well. The below link shares the 2023.5 datatype types support for SAP Extractor. If needed this is website can change the version you are using. 

Note: For the SAP Extractor if you are running 2022.11 or 2023.5 please ensure you have the latest Service Release installed. 2022.11 Build 746 and 2023.5 Build 413 as shown in upper right corner of Replicate Console.

Link to Support Datatypes

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/SAPExtractor/extractor_AP_sourc...

Thanks,

Bill Steinagle