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 laterInformation 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:
- Log into sqlplus as agile database user
- Run agile9_check.sql. See the error
- Export Agile database schema using agile9expdp utility
- Recreate Agile database schema by run recreateagile utility
- Import Agile database schema exported in step 3 using agile9impdp utility
- 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 |