Error: "Error number=4098 Error message: ORA-04098:Trigger ADMUSER.TABLE is invalid and failed re-validation" When Running Dbsetup Tool To Create A P6 Oracle Database.
Last updated on JANUARY 04, 2018
Applies to:Primavera P6 Professional Project Management - Version 6.2.1 and later
Primavera P6 Enterprise Project Portfolio Management - Version 6.2.1 and later
Information in this document applies to any platform.
When attempting to create a P6 database in Oracle the following error occurs:
Database error.Error number=4098.Error message:ORA-04098:Trigger ADMUSER.TABLE is invalid and failed re-validation
DatabaseToolException (ORA-04098: trigger "ADMUSER.RT_SETTINGS' is invalid and failed re-validation ORA-06512: at line 2
DatabaseToolException (ORA-04098: trigger 'ADMUSER.PRMAUD_PREFER' is invalid and failed re-validation)
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
- Run DBsetup.bat file, and provide db details and click on 'Next'
- Additional table spaces get created successfully, click 'Next'
- Provide passwords for all P6 related DB users(admuser,privuser,pubuser etc) and click next.
- The issue will occur during the creation of the additional objects
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