Qlik Replicate - 10054

[lqthinguyen]

Good evening

It seems like our Qlik Replicate tasks ran into "An existing connection was forcibly closed by the remote host" a few times

Please suggest how to troubleshoot 10054 error message

To troubleshoot this error, you can try these steps:

• Check the workload on the execution servers at the remote location
• Check the Windows event logs for errors or other activity around the time of the failures**
• Upgrade Qlik Data Gateway to a supported version***
• Rerun the reload**** 

** - Plan to request the event logs from our network/Windows admin

*** Should we upgrade our Qlik Data Gateway?

**** The task automatically resumed itself

Thank you 

Theresa

[john_wang]

Hello @lqthinguyen ,

Thanks for reaching out to Qlik Community!

Would you please share what's the product (Qlik Replicate, or QCDI ), what's the database types, and the databse role (source or target endpoint)? If you can paste a piece of error messages then it's helfp too.

Thanks,

John.

[lqthinguyen]

Good evening Mr. Wang

The error message is Failed to receive: An existing connection was forcibly closed by the remote host.
 (10054).

It's Qlik Replicate version 2022.11.0.394.   SOURCE Oracle 19c on Solaris TARGET AWS RDS Oracle 19c.

Thank you

Theresa

[john_wang]

Hello Theresa Nguyen, @lqthinguyen 

Thanks for the update. Regarding the error:

>> The error message is Failed to receive: An existing connection was forcibly closed by the remote host.
>>  (10054).

This error indicates that the Oracle database client/server connection was closed due to various possible reasons, such as firewall settings, resource limitations, or permission issues. You can find more detailed information on the Microsoft site., An existing connection was forcibly closed by the remote host (OS error 10054).

Typically, Oracle will provide additional details, often in the form of an error or warning message with an "ORA-<nnnnn>" prefix. Please check the task log for any such messages to help identify the root cause. If you need further assistance, kindly open a support ticket and include the diagnostic packages. Our support team will be happy to assist you.

Regards,

John.

[lqthinguyen]

Good morning Mr. Wang,

Please expand "resource limitations" 

eg memory, CPU, size of packet going through Data Gateway ?

The task log and should I also turn on more verbose logging

00014304: 2024-08-11T14:19:36 [SOURCE_CAPTURE  ]I:  Start processing archived Redo log sequence 639070 thread 1 name /archive_qlik/mseroo/mseroo1_639070_950576151.arc  (oradcdc_redo.c:914)
00014644: 2024-08-11T14:23:20 [SORTER          ]I:  Task is running  (sorter.c:716)
00014304: 2024-08-11T14:24:26 [SOURCE_CAPTURE  ]W:  Timezone Region id 4162 is not found in Oracle V$TIMEZONE_NAMES view  (oradcdc_data.c:351)

00013244: 2024-08-11T13:07:32 [SOURCE_CAPTURE  ]I:  Start processing archived Redo log sequence 639070 thread 1 name /archive_qlik/mseroo/mseroo1_639070_950576151.arc  (oradcdc_redo.c:914)
00007688: 2024-08-11T13:10:01 [SORTER          ]I:  Task is running  (sorter.c:716)
00013244: 2024-08-11T13:11:22 [SOURCE_CAPTURE  ]W:  Timezone Region id 4162 is not found in Oracle V$TIMEZONE_NAMES view  (oradcdc_data.c:351)

[john_wang]

Hello Theresa Nguyen, @lqthinguyen 

Looks like you mixed up the 2 different issues. To make things clear, would you please remove your previous comment and put it to the correct article thread?

thanks,
John.