topic Re: Task not Applying Incoming Changes in Qlik Replicate

Task not Applying Incoming Changes

Husseyn — Sat, 25 Apr 2020 16:16:33 GMT

I have set up tasks reading from a logstream staging task however i have noticed two tasks have incoming changes that are not being released. These are stuck on Applying changes on Disk and others are in memory but they're not being released to allow new changes.

I have another task that's updating normally and it's also reading from the same logstream task. What could be the issue with the other two.

The logstream task picking from source to logstream target is working fine.

source Endpoint point is Oracle and Target is SQL server

Re: Task not Applying Incoming Changes

boatswainshy — Tue, 26 Apr 2022 02:29:32 GMT

Hi team,

Thanks for writing!
I notice your queries are unanswered. I hope you've already fixed it. If not, please confirm the following.

Did you restart the Qlik Enterprise Manager service after updating the Log On As user credentials?
Are you using a Fully Qualified Domain Name in the Server Connection properties?
Have you added the new user account in Qlik Replicate in addition to the Qlik Enterprise Manager?

https://community.qlik.com/Task-not-Applying-Incoming-Changes/td-p/1696709-penalty kick online

Thank you!

Kind regards,

boatswainshy

Re: Task not Applying Incoming Changes

Heinvandenheuvel — Tue, 26 Apr 2022 14:16:33 GMT

>> These are stuck on Applying changes on Disk and others

So really the problem is more 'Task not Applying Outgoing Changes' 🙂

Do you have connectivity to the target

Use 'test' on the target end-point in the UI
Check for (intermediate) flashing red marks on the target endpoint in the task monitor screen
Anything recent under 'Messages' in the task monitor UI?

Did you check the (tail) reptask-log for errors or warnings?

Increase the logging level for TARGET_APPLY to TRACE or even VERBOSE to see what it it trying

Finally, check the target DB with SP_WHO2 or similar for active connections/active SQL for the PID of the Task from the Replicate server. It is a reasonable query, is it blocked?

Hein.