Question
Citigroup technology inc
US
Last activity: 5 Sep 2016 7:01 EDT
DB Previleges required to run Pega 7.2.0 update
Hello
We are doing pega update from 7.1.8 to 7.2.0. using command line. Wanted to know what db previleges we require to run the update script from our app servers.
Please clarify with the error we are getting below
Hello
We are doing pega update from 7.1.8 to 7.2.0. using command line. Wanted to know what db previleges we require to run the update script from our app servers.
Please clarify with the error we are getting below
WARNING: Failed to execute SQL in file oracledate00080.sql
[java] Throwable occurred: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)
[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)
[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:266)
[java] Aug 29, 2016 5:10:08 PM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Statement: CREATE TABLE RSM_WORKER.pr_log_reportstats
[java] (
[java] PXCOMMITDATETIME DATE NULL,
[java] PXSAVEDATETIME 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] Exception in thread "main" com.pega.pegarules.install.SQLLoader$SQLLoaderException:
[java] ********************************************************************************
[java]
[java] Encountered a SQL Exception, clean schema before running again.
[java]
[java] ********************************************************************************
[java] at com.pega.pegarules.install.SQLLoader.fail(SQLLoader.java:359)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:316)
BUILD FAILED
/home/tk92768/RSM/Pega7.2.1/scripts/setupDatabase.xml:380: The following error occurred while executing this line:
/home/tk92768/RSM/Pega7.2.1/scripts/setupDatabase.xml:1991: Java returned: 1
**Updated by Moderator: Vidyaranjan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***
Pegasystems Inc.
US
check the upgrade guide: https://docs-previous.pega.com/pega-72-platform-upgrade-guide, in particular Oracle user permissions section.
Citigroup technology inc
US
Oracle systems require SELECT_CATALOG_ROLE user permissions in addition to the standard user
permissions. This is what given in pega update document. what is the select catalog role? how do we ensure we have the oracle user having such permission
PEG
GB
You should be able to check this with a dba user.
For privileges :-
select * from dba_sys_privs where grantee='YOURDATAUSER'
For roles: -
select * from dba_role_privs where grantee='YOURDATAUSER'