Internal deletion schedule no longer running after upgrading to Oracle 19c
search cancel

Internal deletion schedule no longer running after upgrading to Oracle 19c


Article ID: 230502


Updated On:


Data Loss Prevention Enforce Data Loss Prevention


You have upgraded the DLP database to Oracle 19c. Since then you have noticed that no incidents are being deleted as viewed in the System | Incident Deleter | Delete Incidents history .



Release : 15.x, Oracle 19c


Error in Tomcat log:

Default Location:
Windows - C:\ProgramData\Symantec\DataLossPrevention\EnforceServer\<version>\tomcat
Linux - /var/log/Symantec/DataLossPrevention/EnforceServer/<version>/tomcat

File: localhost.2021-11-15.log
Date: 15/11/2021 23:59:00
Thread: 82
Source: com.vontu.manager
Message: Incident Deletion Failed
java.sql.SQLRecoverableException: IO Error: Checksum failjava.sql.SQLRecoverableException: IO Error: Checksum fail
{{ at oracle.jdbc.driver.T4CCallableStatement.executeForRows(}}
{{ at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(}}
{{ at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(}}
{{ at oracle.jdbc.driver.OraclePreparedStatement.execute(}}
{{ at oracle.jdbc.driver.OracleCallableStatement.execute(}}
{{ at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(}}
{{ at com.vontu.util.jdbc.LoggingPreparedStatement.execute(}}
{{ at com.vontu.manager.system.incident.deletion.IncidentDeletorStartQueryImpl.startIncidentDeletor(}}
{{ at com.vontu.manager.system.incident.deletion.IncidentDeletionService.startIncidentDeletionJob(}}
{{ at com.vontu.manager.system.incident.deletion.scheduler.IncidentDeletorJob.execute(}}
{{ at}}
{{ at org.quartz.simpl.SimpleThreadPool$}}
Caused by: Checksum fail


The correct permissions have not been granted to the Oracle 19c DB.

There is an additional permission that need to granted to the DLP database user.


Granting the CREATE JOB permission to the DLP database account (protect) on the DB resolves the issue.

Check the article Verify or Grant Oracle Database Permissions to Protect User for all permissions needed for DLP database user (protect).

This is noted in the DLP Upgrade Guide (15.7 - Lin / Win or 15.8 Lin / Win ) under the section, 'Confirming the Oracle database user permissions'.