My Oracle Support Banner

Some of the Triggers Are Missing Even after Recreating and Reimporting the Agile Database Schema (Doc ID 2759937.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Running agile9_check.sql, below errors are reported:

Error

ERROR: Missing or INVALID TRIGGER ATTACHMENT_MAP_INS_UPD_TRIGGER.
ERROR: Missing or INVALID TRIGGER ATTACHMENT_UPD_TRIGGER.
ERROR: Missing or INVALID TRIGGER CACHE_FILE_MAP1_T.
ERROR: Missing or INVALID TRIGGER EVENT_HISTORY_T.
ERROR: Missing or INVALID TRIGGER FILES_DEL_TRIGGER.
ERROR: Missing or INVALID TRIGGER INSUPDFIELD.
ERROR: Missing or INVALID TRIGGER INSUPDFIELD_LNG.
ERROR: Missing or INVALID TRIGGER INSUPDFIELD_UNQ1.
ERROR: Missing or INVALID TRIGGER INSUPDFIELD_UNQ2.
ERROR: Missing or INVALID TRIGGER INSUPDFIELD_UNQ3.
ERROR: Missing or INVALID TRIGGER OBJECT_MAP_T.
ERROR: Missing or INVALID TRIGGER PRODUCT_LINE_MAP_T.
ERROR: Missing or INVALID TRIGGER REDLINE_ATTRIBUTE_T.
ERROR: Missing or INVALID TRIGGER REDLINE_MSATTRIBUTE_T.
ERROR: Missing or INVALID TRIGGER RENDITION_FILE_MAP_T.
ERROR: Missing or INVALID TRIGGER THUMBNAIL_FILE_MAP_T.
ERROR: Missing or INVALID TRIGGER THUMBNAIL_OBJECT_MAP_T.
ERROR: Missing or INVALID TRIGGER T_GROUP_DAT_INS.
ERROR: Missing or INVALID TRIGGER T_GROUP_DAT_UPD.




Steps

The issue can be reproduced at will with the following steps:

  1. Log into sqlplus as agile database user
  2. Run agile9_check.sql. See the error
  3. Export Agile database schema using agile9expdp utility
  4. Recreate Agile database schema by run recreateagile utility
  5. Import Agile database schema exported in step 3 using agile9impdp utility
  6. agile9_check.sql. Still see the error
    Note: All the sql files and utility mentioned here is under $ORACLE_BASE/admin/[SID]/create/agile

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.