Labels
alertname = OTCS_AGENTs_Distributetagent_not working
HID = OTCS1001
Help = OTCS1001 distributedagent not working
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)

opentext Content Server

16.x

Yes

opentext Content Server

20.x

Yes

opentext Content Server

21.x

Pending

Database

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)