Problem with replication BLOB/CLOB from Mainframe DB2 to SQL-server

PerJansdal — Tue, 27 Feb 2024 09:46:40 GMT

I am having the following problem, can anyone tell me what to do. Soppy for the Danish txt

00010196: 2024-02-27T06:00:10 [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: 40003 NativeError: -30081 Message: [IBM][CLI Driver] SQL30081N Der er fundet en kommunikationsfejl. Den anvendte kommunikationsprotokol er "TCP/IP". Det anvendte kommunikations-API er "SOCKETS". Placering, hvor fejlen er opdaget: "192.168.0.254". Kommunikationsfunktionen, som har konstateret fejlen, er "send". Protokolspecifikke fejlkoder: "10053", "*", "*". SQLSTATE=08001 [1022502] (ar_odbc_stmt.c:4000)
00010196: 2024-02-27T06:00:10 [SOURCE_CAPTURE ]E: Failed to prepare statement 'SELECT "PDF" FROM "PROD"."TBVDS090COCPDFDOC" WHERE "VIN"=?' [1022511] (db2z_endpoint_imp.c:1206)
00010196: 2024-02-27T06:00:10 [SOURCE_CAPTURE ]E: Failed to Get select lob statement [1022511] (odbc_util.c:2407)
00010196: 2024-02-27T06:00:10 [TARGET_APPLY ]E: Failed to get blob columns values for table PROD.TBVDS090COCPDFDOC [1022511] (odbc_util.c:3645)
00010196: 2024-02-27T06:00:10 [TARGET_APPLY ]I: Error executing data handler [1022511] (streamcomponent.c:2001)
00010196: 2024-02-27T06:00:10 [TASK_MANAGER ]I: Stream component failed at subtask 0, component st_0_ANGSQLP03 [1022511] (subtask.c:1396)
00010196: 2024-02-27T06:00:10 [TARGET_APPLY ]I: Target component st_0_ANGSQLP03 was detached because of recoverable error. Will try to reattach (subtask.c:1511)
00010196: 2024-02-27T06:00:15 [STREAM_COMPONEN ]I: Target last committed record id from the previous run is '1052193' (streamcomponent.c:1664)
00010196: 2024-02-27T06:00:15 [TARGET_APPLY ]I: Bulk is set to ignore max row size warnings (sqlserver_endpoint_imp.c:1678)
00010196: 2024-02-27T06:00:15 [TARGET_APPLY ]I: Working with collated columns (sqlserver_endpoint_imp.c:1738)
00010196: 2024-02-27T06:00:15 [TARGET_APPLY ]I: Working with BCPKeepNull set to TRUE (sqlserver_endpoint_imp.c:1742)
00010196: 2024-02-27T06:00:15 [TARGET_APPLY ]I: Target endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:894)
00010196: 2024-02-27T06:00:15 [TARGET_APPLY ]I: Going to use provider syntax for datatype mapping (sqlserver_endpoint_imp.c:1769)
00010196: 2024-02-27T06:00:15 [TARGET_APPLY ]I: Going to connect to server 'ANGSQLP05.semlernet.dk' database 'NextGen' (sqlserver_endpoint_imp.c:1773)
00010196: 2024-02-27T06:00:15 [TARGET_APPLY ]I: Target endpoint 'SQL Server' is using provider syntax 'SQLServer' (provider_syntax_manager.c:894)
00010196: 2024-02-27T06:00:15 [TARGET_APPLY ]I: Working in transactional apply mode (endpointshell.c:2025)
00010196: 2024-02-27T06:00:15 [SOURCE_CAPTURE ]I: DB2z connection was established with correlation ID 'R4ZMWRP3BC9B' (db2z_endpoint_imp.c:190)
00010196: 2024-02-27T06:00:15 [SOURCE_CAPTURE ]I: ODBC driver version: '11.01.0000' (ar_odbc_conn.c:633)
00010196: 2024-02-27T06:00:15 [SOURCE_CAPTURE ]I: ODBC driver version: '11.01.0000' (ar_odbc_conn.c:633)
00010196: 2024-02-27T06:00:15 [SOURCE_CAPTURE ]I: Source endpoint 'IBM DB2 for z/OS' is using provider syntax '<default>' (provider_syntax_manager.c:888)
00010196: 2024-02-27T06:00:16 [TARGET_APPLY ]I: Target components st_0_ANGSQLP03 was reattached after 5 seconds. (subtask.c:1380)

Re: Problem with replication BLOB/CLOB from Mainframe DB2 to SQL-server

john_wang — Tue, 27 Feb 2024 10:14:44 GMT

Hello @PerJansdal ,

Thanks for reaching out to Qlik Community!

This is a regular TCP/IP communication error. I'd like suggest you install the certified ODBC Version first, in Qlik Replicate 2023.11 the Replicate supports driver versions 11.5.6 and 11.5.8 only. while you are running ODBC v11.1. Please upgrade the ODBC driver version and restart Qlik Replicate Services then try again.

If you face the problem still in newer version ODBC Driver, please check the IBM Site SQL30081N TCP/IP communication errors, and will help you check Qlik Replicate side also.

Good luck,

John.

topic Re: Problem with replication BLOB/CLOB from Mainframe DB2 to SQL-server in Qlik Replicate

Problem with replication BLOB/CLOB from Mainframe DB2 to SQL-server

Re: Problem with replication BLOB/CLOB from Mainframe DB2 to SQL-server