Support Article
ORA-00604 error during installation of Pega 7.1.7 on Oracle
SA-10155
Summary
Script install.sh fails trying to create a table in the schema.
Error Messages
[java] INFO: File: oracledate00010.sql
[java] May 13, 2015 9:42:58 AM com.pega.pegarules.install.SQLLoader writeMessage
[java] INFO: CREATE TABLE SCHEMA_OWNER.PR_LOG_REPORTSTATS
[java] May 13, 2015 9:42:59 AM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Failed to execute SQL in file oracledate00010.sql
[java] May 13, 2015 9:42:59 AM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Statement: CREATE TABLE SCHEMA_OWNER.pr_log_reportstats
[java] (
[java] pxCommitDateTime DATE NULL,
[java] pxCreateDateTime DATE NULL,
[java] pxCreateSystemID VARCHAR2(32) NULL,
[java] pxInsName VARCHAR2(512) NULL,
[java] pxObjClass VARCHAR2(96) NULL,
[java] pxSessionId VARCHAR2(128) NULL,
[java] pyClassName VARCHAR2(96) NULL,
[java] pxErrorCount NUMBER(18) NULL,
[java] pxTotalElapsedTime NUMBER(18) NULL,
[java] pxModeOfExecution VARCHAR2(32) NULL,
[java] pxReportExecutionCount NUMBER(18) NULL,
[java] pxReportInsKey VARCHAR2(255) NULL,
[java] pxReportOperator VARCHAR2(128) NULL,
[java] pyStreamName VARCHAR2(64) NULL,
[java] pxRowsRetrieved NUMBER(18) NULL,
[java] pzInsKey VARCHAR2(512) NOT NULL
[java] )
[java] java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
[java] ORA-06550: line 1, column 93:
[java] PLS-00201: identifier 'SCHEMA_OWNER.GRANT_PRIVS' must be declared
[java] ORA-06550: line 1, column 93:
[java] PL/SQL: Statement ignored
[java] ORA-06512: at "SYS.DBMS_JOB", line 82
[java] ORA-06512: at "SYS.DBMS_JOB", line 140
[java] ORA-06512: at line 12
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718)
[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678)
[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:298)
[java] May 13, 2015 9:42:59 AM com.pega.pegarules.install.SQLLoader writeMessage
Steps to Reproduce
Run install.sh to observe the error.
Root Cause
The root cause of this problem is defect/misconfiguration in the operating environment. The schema does not have the correct privileges.
Resolution
Recreate the schema and grant privileges as outlined in the Pega 7.1.7 Installation Guide.
Published June 12, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.