My Oracle Support Banner

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 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" 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 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

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