Question

4
Replies
117
Views
saravanank1808 Member since 2015 21 posts
Citigroup technology inc
Posted: 4 years ago
Last activity: 4 years 1 month ago
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***

 

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn