topic Re: Qlik Replicate - 10054 in Qlik Replicate

Qlik Replicate - 10054

lqthinguyen — Sun, 11 Aug 2024 04:02:44 GMT

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

Re: Qlik Replicate - 10054

john_wang — Sun, 11 Aug 2024 04:09:54 GMT

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.

Re: Qlik Replicate - 10054

lqthinguyen — Sun, 11 Aug 2024 06:07:41 GMT

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

Re: Qlik Replicate - 10054

john_wang — Sun, 11 Aug 2024 09:24:24 GMT

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.

Re: Qlik Replicate - 10054

lqthinguyen — Sun, 11 Aug 2024 14:43:58 GMT

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)

Re: Qlik Replicate - 10054

john_wang — Sun, 11 Aug 2024 15:52:55 GMT

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.