After Roll Back of Oracle Product Lifecycle Analytics(OPLA) Patch, Error ORA-04098: Trigger 'AGILE_ODIWORK.T$ODM_USER_GROUP' Is Invalid and Failed Re-Validation on Full Load
(Doc ID 2042652.1)
Last updated on JULY 14, 2021
Applies to:Oracle Product Lifecycle Analytics - Version 184.108.40.206 and later
Information in this document applies to any platform.
Unable to run Full Load with below error after rolling back the patch
ODI-1226: Step odi_int_ODM_USER_GROUP_9223_full fails after 1 attempt(s).
ODI-1240: Flow odi_int_ODM_USER_GROUP_9223_full fails while performing a Integration operation. This flow loads target table null.
ODI-1228: Task odi_int_ODM_USER_GROUP_9223_full (Integration) fails on the target ORACLE connection TRG_ODMCONN_PHYSICAL.
Caused By: java.sql.SQLSyntaxErrorException: ORA-04098: trigger 'AGILE_ODIWORK.T$ODM_USER_GROUP' is invalid and failed re-validation
Apply patch:1966531, and roll back the patch according to the instruction in "Oracle Product Lifecycle Analytics Patch Installation Readme Nov 2014 220.127.116.11.0" as below:
1. Restore the following schemas by importing the previously backed up database export dumps to schemas with the same username and password:
a. Oracle Data Integrator(ODI) Work Repository
b. Stage or Operational Data Mart (ODM) Schema
c. Primary Data Schema (MDS) Schema
2. Remove the temp tables (i$, j$ and C$) from all the schemas.
3. Restore the RPD file by importing it from its backup location.
4. Change the Extract Transform , Load(ETL) configuration to run Data Mart or Stage and MDS in FULL load mode.
Applied OPLA patch:1966531 to upgrade to OPLA 18.104.22.168 and uninstalled the patch
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