Azure Data Factory - Pipeline times out when sink is succeeded

Question

In azure data factory I get random timeouts on pipelines. My adf pipelines usually complete in around 3 minutes. They either complete in 3min or throw timeout after an hour. The timeout always looks the same. There is only 1 sink and its completed and marked with success but the source shows as in progress. After these 3mins no more rows are calculated, the pipeline looks llike it idles until timeout.

This is how the sink looks when inspected:

This is how the source looks when inspected:

This seems completely random sometimes pipeline passes without any problems and sometimes gets stuck in this state. The source is azure sql database and I use stored procedure. I've tried with different isolation levels but the result is still the same. What else could be the issue?