Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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.
Suggest Edit

Published June 12, 2015 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us