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

  • 7730030
  • 02-Feb-2007
  • 08-Sep-2008

Resolution

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.



Additional Information

Formerly known as NETIQKB30030

Feedback service temporarily unavailable. For content questions or problems, please contact Support.