...

The distributedagent need to Run 1.6h and Restart after that. if they Stuck we need to Restart the Services.

...

Sources of Errors

1. Database Locks of Tables

   1. Oracle Database

      1. Select for Database Lock

         Code Block
         select (select username from v$session where sid=a.sid) blocker, a.sid, ' is blocking ', (select username from v$session where sid=b.sid) blockee, b.sid from v$lock a, v$lock b where a.block = 1 and b.request > 0 and a.id1 = b.id1 and a.id2 = b.id2;

      2. Solution: → Contact your DB Admin he can Remove the Lock.

   2. SQL

      1. SQL Server Locks, Blocked Processes, and Two Easy Ways to Find Them | Diagram (wearediagram.com)

...