Error: ' Audit_select_flag not found' when trying to save trigger in VigilEnt Audit Manager for Orac (NETIQKB30030)

fact
VigilEnt Audit Manager for Oracle 4.0

symptom
Error: ' Audit_select_flag not found' when trying to save trigger in VigilEnt Audit Manager for Oracle.

cause
The installation is missing the 'Select Auditing Components' from the 'SQLCQR_USRAUDIT_TABLE'. This can happen when a database is upgraded from v3.26 to v4.0.

fix
To correct this issue the 'Select Config Columns' need to be added to the 'SQLCQR_USRAUDIT_Config' that deal with select user defined audits.

To correct the issue follow the included steps:

Step One:

Remove/drop these objects from the database instance.

• PACKAGE - sqlcqr.SQLCQR_USRAUDIT_PKG
• PACKAGE BODY - sqlcqr.SQLCQR_USRAUDIT_PKG
• public synonym - SQLCQR_USRAUDIT_ACTIONS
• SEQUENCE - sqlcqr.SQLCQR_USRAUDIT_MASTERID
• TABLE - sqlcqr.sqlcqr_USRAUDIT_detail_export
• TABLE - sqlcqr.sqlcqr_USRAUDIT_master_export

Step Two:

Add these columns.

• ALTER TABLE "SQLCQR"."SQLCQR_USRAUDIT_DETAIL"
  ADD(CLIENT_INFO VARCHAR2(64) NULL);
• ALTER TABLE "SQLCQR"."SQLCQR_USRAUDIT_Config"
  ADD(SELECT_COLMN VARCHAR2(1000) NULL,
  AUDIT_SELECT_FLAG CHAR(1) NOT NULL,
  AUDIT_SELECT_CONDITION VARCHAR2(1000) NULL,
  ALERT_SELECT_FLAG CHAR(1) NOT NULL,
  ALERT_SELECT_CONDITION VARCHAR2(1000) NULL,
  ALERT_EMAIL VARCHAR2(255) NULL);

Step Three:

Run the SchemaInstaller to re-install VigilEnt Audit Manager.

Formerly known as NETIQKB30030