Question

4
Replies
302
Views
ChennaReddyM Member since 2013 20 posts
Accenture
Posted: 4 years ago
Last activity: 4 years 10 months ago
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
Share this page LinkedIn