Error Code 4050 Agent data batch persist error

book

Article ID: 170861

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

Seeing Error code 4050 "Agent data batch persist error" in the Symantec Data Loss Prevention (DLP) Enforce console.

Code 4050
Summary Agent data batch persist error
Detail Unexpected error occurred while agent data being persisted: Could not get JDBC Connection; nested exception is java.swl.SWLRevoverableException: IO Error: THe Network Adapter could not establish the connection. Please look at the monitor controller logs for more information.

Monitor Controller Log from the Enforce Server:

Date/TimeStamp com.vontu.model.notification.NotificationModel downConnection
SEVERE: database.connection.down
com.vontu.model.DatabaseConnectionException: org.apache.ojb.odmg.TransactionAbortedExceptionOJB: Can't commit objects: Can't lookup a connection
at com.vontu.model.ojb.OJBSystem.checkConnectionStatus(OJBSystem.java:1056)
at com.vontu.model.ojb.OJBSystem.createDataAccessRuntimeException(OJBSystem.java:1131)
at com.vontu.model.ojb.OJBSystem.commitTransaction(OJBSystem.java:364)
at com.vontu.model.ModelProxy.commitTransaction(ModelProxy.java:55)
at com.vontu.model.notification.NotificationModel.commitTransaction(NotificationModel.java:166)
at com.vontu.model.ModelProxy.commitTransaction(ModelProxy.java:55)
at com.vontu.model.SafeTransaction.commit(SafeTransaction.java:86)
at com.vontu.model.data.util.executor.TxDatabaseCommand.execute(TxDatabaseCommand.java:46)
at com.vontu.model.data.util.executor.TxDatabaseCommand.execute(TxDatabaseCommand.java:35)
at com.vontu.model.data.util.executor.RunnableCommand.runAndHandleExceptions(RunnableCommand.java:76)
at com.vontu.model.data.util.executor.RunnableCommand.run(RunnableCommand.java:63)
at com.vontu.util.concurrent.QueueingTask.performWork(QueueingTask.java:63)
at com.vontu.util.concurrent.WorkerThread.run(WorkerThread.java:79)
Caused by: org.apache.ojb.odmg.TransactionAbortedExceptionOJB: Can't commit objects: Can't lookup a connection
at org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:719)
at com.vontu.model.ojb.OJBSystem.commitTransaction(OJBSystem.java:348)
... 10 more
Caused by: org.apache.ojb.broker.PersistenceBrokerException: Can't lookup a connection
at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(ConnectionManagerImpl.java:170)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.beginTransaction(PersistenceBrokerImpl.java:442)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.beginTransaction(DelegatingPersistenceBroker.java:184)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.beginTransaction(DelegatingPersistenceBroker.java:184)
at org.apache.ojb.odmg.TransactionImpl.doWriteObjects(TransactionImpl.java:396)
at org.apache.ojb.odmg.TransactionImpl.prepareCommit(TransactionImpl.java:762)
at org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:698)
... 11 more
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not get connection from DBCP DataSource
at org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl.checkOutJdbcConnection(ConnectionFactoryDBCPImpl.java:86)
at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:139)
at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:121)
at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(ConnectionManagerImpl.java:163)
... 17 more
Caused by: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:497)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:460)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:594)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)
at org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl$ConPoolFactory.createConnection(ConnectionFactoryDBCPImpl.java:414)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl.checkOutJdbcConnection(ConnectionFactoryDBCPImpl.java:82)
... 20 more

Cause

DLP Oracle database was down.

Or can be caused by doing warm backups. Symantec only supports Oracle cold backups, see our Maintenance Guide for your version.

Environment

Any DLP version can have this error.

Resolution

Fix issues with Oracle db. Or stop doing warm backups. We only support cold backups. See our Maintenance Guide.

Monitor contoller log now shows:
com.vontu.enforce.domainlayer.common.database.DatabaseConnectionStatusTask run
INFO: Database connection is up