Question

4
Replies
117
Views
Close popover
saravanan kvkandasamy (saravanank1808)
Citigroup technology inc

Citigroup technology inc
US
saravanank1808 Member since 2015 21 posts
Citigroup technology inc
Posted: August 29, 2016
Last activity: September 5, 2016
Closed

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

 

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***

 

System Administration Upgrades
Moderation Team has archived post