Qlik Compose task stuck to instruction "Adding admissible rows" in Hub-Satellite entity

[michelabarsottini]

Hi all,

we are experiencing an unexpected behaviour. Yesterday one of our DWH tasks ran under 10 minutes, but suddenly the process got stuck in a Hub-Satellite etl sets which has "Adding admissible rows to temporary table <temp table name>" as title.

Nothing has been changed in the mapping, the table is loaded in few minutes but now the task simply does not end and we have to manually abort it.

Compose version is May 2022 (2022.5.0.140).

On database side everything is normal.

Thank you

Michela

[shashi_holla]

@michelabarsottini 

Please check if there is any Java PID running on the Compose server other than the \jre\bin\java.exe process:

If yes, then manually kill the PID which should help to fix the issue.

If we still have the issue, then can try restarting the Compose Service which should release all the blocking threads.

Thank you,

[michelabarsottini]

Hi Shasi,

I only have the two java.exe processes (one for Replicate and one for Compose), I tried to restart the systems, but the query is stuck again.

Thank you ,

Michela