ORA-18730 Interrupted IO error when starting DLP services on Enforce
search cancel

ORA-18730 Interrupted IO error when starting DLP services on Enforce

book

Article ID: 410145

calendar_today

Updated On:

Products

Data Loss Prevention

Issue/Introduction

When restarting DLP services on the Enforce Server, services start successfully but the the following errors are logged in the MonitorController0.log:

File: Enforce/logs/debug/MonitorController0.log
Date: #######
Class: com.vontu.model.notification.NotificationModel
Method: downConnection
Level: SEVERE
Message: database.connection.down
com.vontu.model.DatabaseConnectionException: org.apache.ojb.odmg.TransactionAbortedExceptionOJB: Can't commit objects:

SQLException during execution of sql-statement:
sql statement was 'UPDATE IndexedInfoSourceStatus SET indexedInfoSourceID=?,informationMonitorID=?,version=?,status=?,startDate=?,updatedDate=?,endDate=? WHERE indexedInfoSourceStatusID = ? '
Exception message is [ORA-18730: Interrupted IO error.: Socket write interrupted
https://docs.oracle.com/error-help/db/ora-18730/]
Vendor error code [18730]
SQL state code [08006]
Target class is 'com.vontu.model.data.ojb.IndexedInfoSourceStatusImpl'
PK of the target object is [indexedInfoSourceStatusIDRef=#####]


File: Enforce/logs/debug/MonitorController0.log
Date: ######
Class: oracle.jdbc.driver.PhysicalConnection
Method: connect
Level: INFO
Message: throwing
java.sql.SQLRecoverableException: ORA-17002: I/O error: , Authentication lapse 0 ms.
https://docs.oracle.com/error-help/db/ora-17002/

Environment

Symantec Data Loss Prevention
Two-tier environment (Enforce and Oracle installed on the same server)
RHEL 8.10

Cause

The error is thrown because DLP is failing to update an index delivery status for a detection server that no longer exists.

Resolution

The index delivery status needs to be corrected within the database.
Contact support for further assistance.