topic Re: Task failed automatically in Qlik Replicate

Task failed automatically

chandraprakash_j_volvo — Tue, 30 Jan 2024 11:46:48 GMT

There are 38 tables running in Qlik Replicate. We use Full load and change tables.
suddenly we face task stops and could'nt able to resume or restart either.

When we try to re run , we face this error.

SYS-E-HTTPFAIL, Task ORC_TO_DELTA is already running.
SYS,GENERAL_EXCEPTION,Task ORC_TO_DELTA is already running

Re: Task failed automatically

anat — Tue, 30 Jan 2024 12:20:41 GMT

may be this error due to out of memory...

https://ss64.com/nt/syntax-desktopheap.html

Re: Task failed automatically

john_wang — Tue, 30 Jan 2024 13:27:59 GMT

Hello @chandraprakash_j_volvo ,

Looks like the task crashed. Please check the task log file 1st line and find out the PID:

2024-01-30T12:56:08:224612 [AT_GLOBAL ]I: Task Server Log - DB400-to-TD17 (V2023.5.0.516 ..., PID: 2572) started at Tue Jan 30 12:56:08 2024

If the log file rollovered in minutes and the PID is changed each time, it indicates the task crashed, Qlik Replicate will try to recovery from the failure, so the task is trying to startup automatically; if you want to restart the task manually, then you may got:

SYS-E-HTTPFAIL, Task ORC_TO_DELTA is already running.
SYS,GENERAL_EXCEPTION,Task ORC_TO_DELTA is already running

You may stop the task manually (press the STOP button in GUI), and wait for minutes until the task stopped completely (check "repsrv.log" to make sure the task stopped), then try to RESUME it again. Check the task log file, or even enable some components to Trace/Verbose, to get further information about the failure.

Hope this helps.

John.

Re: Task failed automatically

chandraprakash_j_volvo — Wed, 31 Jan 2024 06:48:31 GMT

Hello

Can you clarify about GUI ?

Thanks

Re: Task failed automatically

Dana_Baldwin — Wed, 31 Jan 2024 23:24:23 GMT

Hi @chandraprakash_j_volvo

GUI = graphical user interface

Basically the application itself, or, the "presentation layer" of the software, the part you see & interact with.

Re: Task failed automatically

Kaushik — Thu, 01 Feb 2024 06:28:34 GMT

Hi @chandraprakash_j_volvo

Can you please check the below setting are enabled or disabled

Re: Task failed automatically

chandraprakash_j_volvo — Thu, 01 Feb 2024 08:39:16 GMT

From GUI we tried to stop the task, but couldn't. Is there a way to stop the task from Server directly either through command or by any means?

Re: Task failed automatically

john_wang — Thu, 01 Feb 2024 08:46:02 GMT

Hello @chandraprakash_j_volvo ,

You may try to press the STOP button whenever it's visible in the GUI. Certainly you may try stop it by command. for example: repctl connect; stoptask task=ORA_2_SQL;

Hope this helps.

John.

Re: Task failed automatically

chandraprakash_j_volvo — Thu, 01 Feb 2024 08:51:09 GMT

In GUI, stop task is disabled. When we try to resume it says task already running. Is there any document which we can use how to run the command lines in server

Re: Task failed automatically

SushilKumar — Thu, 01 Feb 2024 08:57:02 GMT

Hello Team,

Thanks for reaching out to Qlik via Qlik Community Support page. Such issue require through analysis of Task 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/1815056

Regards,

Sushil Kumar

Re: Task failed automatically

john_wang — Thu, 01 Feb 2024 09:29:28 GMT

Hello @chandraprakash_j_volvo ,

You may find the start task command in the previous link. However I donot think it's worth to try command line if the GUI cannot RESUME a task. I'd like suggest you :

1- please check the "repsrv.log" to see what's the current status of the task;

2- do you have more than cases which name exceeds 32-chars and the task name are similar (eg the first 32-chars are duplicate).

3- If you still cannot manage it to work, please open a support ticket with "repsrv.log" and the task Diagnostics Packages, support team will help you further. (BTW, support team may need the Replicate data folder for analysis).

Regards,

John.

Re: Task failed automatically

deepaksahirwar — Fri, 02 Feb 2024 02:13:04 GMT

Dear @chandraprakash_j_volvo ,

Thank you for reaching out to us in the Qlik Community.

Based on the error message, it seems that the task ORC_TO_DELTA is still running in the background, even though it appears to be stopped in the UI. This could be due to a network or system issue that prevented the task from terminating properly.

There are a few possible solutions that you can try to resolve this issue:
Check the logs
Check if the user that Replicate runs as have access to /opt/attunity/replicate/data. This is the directory where Replicate stores the task files and logs. If the user does not have the proper permissions, it could cause the task to fail or hang.
Try to reload the task or run the task by timestamp from the Advanced setting. This will force Replicate to restart the task from the last checkpoint or a specified point in time. This may help to clear any corrupted or incomplete files that are causing the task to fail.

Finally if nothing works , go to the server task manager and kill the job and try resuming the job from beginning.
OR
Also check if the Target version is properly upgraded & consistent with your qlik replicate version.
I hope this helps you to resolve the issue.

Please let me know if you have any other questions or concerns. 😊

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer

Regards,
Deepak