Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Hello
Can you clarify about GUI ?
Thanks
GUI = graphical user interface
Basically the application itself, or, the "presentation layer" of the software, the part you see & interact with.
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?
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.
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
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/...
Regards,
Sushil Kumar