Getting RSOD while exporting any policy from enforce console

Products

• Data Loss Prevention Enforce

Issue/Introduction

Getting RSOD while exporting any policy from enforce console

Environment

DLP 16.X

Cause

1. Checked the tomcat localhost logs and can see below error while the policy export is in progress:
 
File: Enforce\logs\tomcat\XXXXXX-date.log
Thread: 131
Level: SEVERE
Source: com.vontu.manager.spring.web.ManagerHandlerExceptionResolver
Message: Unexpected exception while processing request:
Cause:
org.springframework.orm.jpa.JpaSystemException: could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batchorg.springframework.orm.jpa.JpaSystemException: could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch
 at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:331)
 at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233)
 at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
 at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743)
 at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711)
 at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:654)
 at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:407)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)
 at com.vontu.manager.ui.policyexportimport.PolicyExportAuditLogger$$EnhancerBySpringCGLIB$$293f4449.auditLog(<generated>)
 at com.vontu.manager.ui.policyexportimport.PolicyExportManagerService.exportSinglePolicy(PolicyExportManagerService.java:125)
 at com.vontu.manager.ui.policyexportimport.PolicyExportManagerService.exportSelectedPolicies(PolicyExportManagerService.java:100)
 at com.vontu.manager.ui.policyexportimport.PolicyExportManagerService$$FastClassBySpringCGLIB$$933ec1fd.invoke(<generated>)
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
 
Caused by: java.sql.BatchUpdateException: ORA-01691: unable to extend lob segment PROTECT.SYS_LOB0000078280C00008$$ by 1024 in tablespace USERS
 
 at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9741)
 at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1447)
 at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9517)
 at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:237)
 at oracle.ucp.jdbc.proxy.oracle$1ucp$1jdbc$1proxy$1oracle$1StatementProxy$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeBatch(Unknown Source)
 at com.vontu.util.jdbc.LoggingStatement.doExecuteBatch(LoggingStatement.java:274)
 at com.vontu.util.jdbc.LoggingPreparedStatement.executeBatch(LoggingPreparedStatement.java:183)
 at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:121)
 ... 406 more
 
2. As per above error, looks like your USERS tablespace is full. Checked the logs further and found below error for USERS tablespace full.
 
File: Enforce\logs\tomcat\XXXXXX-date.log
Thread: 113
Level: SEVERE
Source: com.vontu.manager
Message: Tablespace is almost full. Oracle tablespace USERS is over 99.98868% full.

Resolution

1. You need to extend the USERS tablespace to resolve this.
 
2. To add tablespace, log in to the database using sys as sysdba and enter the following:
 
ALTER TABLESPACE USERS
ADD 
DATAFILE '<directory and datafile name>' SIZE 138240K
REUSE AUTOEXTEND 
ON NEXT 10240K MAXSIZE 32767M;

Additional Information

Refer below article for more information regarding extending tablespace:
https://knowledge.broadcom.com/external/article?legacyId=tech220104