E-Mail Message:

Text

Picture

Labels alertname = OTCS_AGENTs_Distributetagent_not working HID = OTCS1001 Help = https://handel.atlassian.net/wiki/spaces/HITID/pages/837713921 env = PRD instance = localhost:10102 instanceIndex = 4 job = OTCS_PROD llagentsDisplayName = OTCS0801BE01 llagentsInfoIndex = 22 llagentsJobName = distributedagent llagentsStatus = OK severity = critical team = otcs Annotations description = They dont change the State since 15min summary = Content Server Distributet Agents not Working(instance localhost:10102)

Applies to

Summary

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

         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)