...
- It is possible that an external component like a table lock by the database blocks the transformation. This is explained in detail in Database Locks When Reading and Updating from a Single Table.
- The "Block this step until steps finish" step might run into a deadlock when there are more rows to process than the number of Rows in Rowset. Please see the step documentation for more details.
- Within transformations there are situations when streams get split and joined again, so that the transformation blocks by design. In general this design can be very critical because a transformation can work with a limited number of rows (e.g. in development and testing environments) and will run into a deadlock state in production. This is explained in more detail here:
...