Discussion

386
Views
yapj1 Member since 2015 32 posts
PEGA
Posted: 5 years ago
Last activity: 5 years 1 month ago
Closed

Exception while defragmenting Table::pr_sys_locks associated with class::System-Locks [PEGA_DATA.SPPR_DEFRAGMENT_TABLE]

Hi,

I have completed fresh install of Pega 7.1.8 on Windows 2012 with Oracle DB 12 and WebSphere, installation completed successfully and I am able to login to the Designer Studio.

I noticed that there is an error log entry as follows. Anybody know the cause, impact and resolution?

 

Thanks and regards,

Jacky

######################################

2015-08-06 01:29:26,513 [_PRPCWorkManager : 1] [  STANDARD] [                    ] [     PegaRULES:07.10] (  internal.access.DatabaseImpl) ERROR   - Exception while defragmenting Table::pr_sys_locks associated with class::System-Locks 
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges 
ORA-06512: at "PEGA_DATA.SPPR_DEFRAGMENT_TABLE", line 57 
ORA-06512: at line 1 
 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) 
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) 
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) 
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) 
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) 
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:210) 
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:53) 
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) 
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075) 
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) 

####################################

 

Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn