During an install get ORA-04098: trigger 'DEMANTRA.TRIG_POST_UPDATE_SYS_PARAMS' is invalid and failed re-validation (Doc ID 2147880.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2 and later
Information in this document applies to any platform.

Goal

Customer is trying to do an install with a new Demantra schema
However every time they run the installer, it fails with the following error message

016-05-04 16:46:20,555 ERROR - Failed to update System Parameters on user 'demantra'.
java.sql.SQLSyntaxErrorException: ORA-04098: trigger 'DEMANTRA.TRIG_POST_UPDATE_SYS_PARAMS' is invalid and failed re-validation

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)

1. Customer gave all the grants to the Demantra schema and re ran the installer but despite that the issue occurs

2. They have even dropped the Demantra schema and tried again but the same error keeps coming
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms