Question

4
Replies
307
Views
ChennaReddy Marreddy (ChennaReddyM)
Accenture

Accenture
IN
ChennaReddyM Member since 2013 20 posts
Accenture
Posted: December 14, 2015
Last activity: December 15, 2015
Posted: 14 Dec 2015 7:49 EST
Last activity: 15 Dec 2015 5:53 EST
Closed
Solved

While starting Pega 7.1.7 application getting "com.pega.pegarules.pub.database.DatabaseException: ORA-04098: trigger 'schema2.TRPR_DATAADM' is invalid and failed re-validation error"

Hi Team,

My Pega Application is down and it is test environment.

When I'm trying to bring it up getting error as com.pega.pegarules.pub.database.DatabaseException: ORA-04098: trigger 'schema2.TRPR_DATAADM' is invalid and failed re-validation error.

I observed that, server is trying to execute a trigger in another schema which not connected to our application.

For Ex: My application schema is schema1

            In the error i can see as it is trying to trigger in schema2 as schema2.TRPR_DATAADM.

        This schema2 is not belongs to our application but both schemas are lies in same Database.

please find the attached log file.

If I connect the same environment to different schema(schema2), application is working fine.

Could you let me know what's wrong with my application.

Data Integration System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.