Automic Workload Automation

 View Only

Orphaned Entries in HACL DB table after Client deletion

  • 1.  Orphaned Entries in HACL DB table after Client deletion

    Posted Sep 24, 2020 10:39 AM
    Hi

    we discovered per accident that some old entries are left in HACL table (Agent-Client Assignment) after we removed some clients in Test Env.

    The agents still exist but the related Clients were deleted. 

    SQL (ORA) to check:

    select oh_name as "Agent", hacl_client as "NONexistent Client"from hacl,oh
    where hacl_client not in (select oh_name from oh where oh_otype = 'CLNT' and oh_idnr > 100000 and oh_deleteflag = 0)
    and hacl_oh_idnr = oh_idnr

    In my opinion those entries should be removed as well...

    Any thoughts about this?

    THX Wolfgang

    ------------------------------
    Support Info:
    if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
    Otherwise update/upgrade your system and check if the problem still exists.
    ------------------------------