Hi,
Got a bit of a problem with 6.2.1 instance. We have(had) an agent registered. The server was decommissioned without first removing it from TIDAL so I now have an agent connection that won't delete.
If I try to delete the agent via the Java Client I get the error
Delete node record with ID [84] failed. delete from nodmst where nodmst_id=?.
If I try to delete it directly from the database I get a constraint error.
*
ERROR at line 1:
ORA-02292: integrity constraint (TIDAL.SYS_C0030961) violated - child record
found
This is usually expected if there is a job or event definition or some such hanging around. I can't find anything in job,event,queue, action definitions but I do see references to an orphan job in the logs.
03/06 06:17:23:735[39:MD-26]: (mem=6329344160/19351470080) AgentNodeMessageHandler: orphanJob (Node: 84 (mybadhost)): Total JobRuns 8697
On top of this, having this phantom agent connection around seems to be mucking up my licensing. I have another agent connection down and it won't recover because TIDAL seems to be confused about license status.
Anyone got any suggestions on how I might clear this connection?
TIA
