AWI times out when creating Agent Group (HOSTG)

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to add a new agent to an agent group. The user is unable to save. AWI times out.

Expected:
- Create Agent Group.
- Load Agent List.
- Select agent and assign selected.
- Click save.
- Save is greyed out.

Actual:
- Create Agent Group.
- Load Agent List.
- Select agent and assign selected.
- Click save.
- AWI loads.
- AWI times out as if the save button was not pressed.

Looking at the WP logs, there's a lot of this:
03 - 20210603/101148.743 - U00015006 System forced memory trace dump.
03 - 20210603/101148.743 - U00003631 Dump caused by:
03 - 20210603/101148.743 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-02291: integrity constraint (UC4.FK_HACL_HOST$RREORG0) violated - parent key not found'
03 - 20210603/101148.743 - U00011801 Error in Server routine 'UCDS_R  ', Server: 'UC4#WP005' AE system: 'UC4'.
07 - 20210603/101148.744 - U00015006 System forced memory trace dump.
07 - 20210603/101148.744 - U00003631 Dump caused by:
07 - 20210603/101148.744 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-02291: integrity constraint (UC4.FK_HACL_HOST$RREORG0) violated - parent key not found'
07 - 20210603/101148.744 - U00011801 Error in Server routine 'UCDS_R  ', Server: 'UC4#WP005' AE system: 'UC4'.
06 - 20210603/101148.745 - U00015006 System forced memory trace dump.
06 - 20210603/101148.745 - U00003631 Dump caused by:
06 - 20210603/101148.745 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-02291: integrity constraint (UC4.FK_HACL_HOST$RREORG0) violated - parent key not found'
06 - 20210603/101148.745 - U00011801 Error in Server routine 'UCDS_R  ', Server: 'UC4#WP005' AE system: 'UC4'.

HACL is the table that holds the agent authorizations. 

 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

HACL is the table that holds the agent authorizations.  Looking at the most recent schema, this FK does not exist: https://docs.automic.com/documentation/webhelp/english/AA/12.3/AE/12.3/DB%20Schema/db/_structure/HTML/HACL.html

 

Looking at the 6.00A image shows that the last time that FK_HACL_HOST foreign key existed was in 5.00A.  Having the DBA drop this FK resolved the issue. 

 

There is very low risk in removing or disabling the FK_HACL_HOST foreign key as it is no longer used and should not be in the database at all.  The statement that is used when loading the 6.00A data is:

 

ALTER TABLE HACL DROP CONSTRAINT FK_HACL_HOST

 

This should have been done during the upgrade from 5.00A to anything newer.