Discussion
HCLTech
IN
Last activity: 10 Apr 2015 11:01 EDT
SQLSyntaxErrorException: ORA-04080: trigger 'TRPR4_BASE"
Hi to all,
could you please anyone help me out this error occured while installing PEGA 7.
[java] Apr 10, 2015 12:46:06 PM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Statement: alter trigger PEGARULE_TB1.trpr4_base disable
[java] java.sql.SQLSyntaxErrorException: ORA-04080: trigger 'TRPR4_BASE' does not exist
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1882)
[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1847)
[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:298)
[java] Apr 10, 2015 12:46:06 PM com.pega.pegarules.install.SQLLoader writeMessage
[java] INFO:
[java] ********************************************************************************
[java]
[java] Encountered a SQL Exception, clean schema before running again.
[java]
[java] ********************************************************************************
Pegasystems Inc.
US
Hi,
Before PRPC can successfully start on the application server you are using, the Database Repository you are running against must first be populated with Pega Rules and Data. This is known as the “Installing the Rulebase” and can be completed by running the “Installation and Upgrade Assistant” and is described in detail in the Deployment Guide for your Application Server and Database combination. Please carefully review the Installation Guide for your particular Application Server, Database Server, and PRPC version (https://collaborate.pega.com/question/deployment-guides) and ensure that you have successfully completed all the installation steps before starting the Application Server you are using to run PRPC.
If after carefully following all the installation guide instructions the problem persists, please submit a Service Request (SR). You can do so by accessing the new My Support Portal (https://collaborate.pega.com/question/how-raise-sr-my-support-portal-how-question).
Regards,
Henry
Pega Academy