My Oracle Support Banner

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.


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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CStatement.doOall8(

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


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.