E-Mail Message:

Text

Picture

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

Applies to

Summary

The distributedagent need to Run 20m 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)