Sentinel: DAS_Binary unable to insert when using ADOLoadStrategy

  • 3766384
  • 25-Jan-2007
  • 26-Apr-2012

Environment

Sentinel 5.1.x
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server
RedHat Linux
Solaris 9

Situation

Getting errors when implementing ADOLoadStrategy.
ADOEventStoreError.log with the following entry:
Length cannot be less than zero.
Parameter name: length
at System.String.Substring(Int32 startIndex, Int32 length)
at System.Data.SqlClient.TdsParser.ProcessSNIError(TdsParserStateObject stateObj)...
The following errors are logged into das_binary.log:
JMS Session Delivery Thread|WARNING|Marking all checked out connections as invalid - size : 1||||esecurity.base.db.connection.DBConnectionPool|invalidateAllConnections|
JMS Session Delivery Thread|SEVERE|Error writing Event File status; Exception Select SELECT MD_EVT_FILE_STS.MIN_EVT_TIME,MD_EVT_FILE_STS.DATE_CREATED,MD_EVT_FILE_STS.FILE_NAME,MD_EVT_FILE_STS.FILE_MD5,MD_EVT_FILE_STS.MAX_EVT_TIME,MD_EVT_FILE_STS.MSG_CNT,MD_EVT_FILE_STS.FILE_ID,MD_EVT_FILE_STS.MODIFIED_BY,MD_EVT_FILE_STS.END_TIME,MD_EVT_FILE_STS.START_TIME,MD_EVT_FILE_STS.DATE_MODIFIED,MD_EVT_FILE_STS.EVT_CNT,MD_EVT_FILE_STS.CREATED_BY,MD_EVT_FILE_STS.FILE_STS FROM MD_EVT_FILE_STS ...
SQLState : 08S01; esecurity.base.exceptions.PersistenceException
[SQLServer JDBC Driver]Connection reset by peer: socket write error

Resolution

Make sure .net2 beta2 runtime is installed. .net2 sdk will cause the failure.

Additional Information

The following errors are logged into das_binary.log

Sun Oct 09 20:10:45 EDT 2005|JMS Session Delivery Thread|WARNING|Marking all checked out connections as invalid - size : 1||||esecurity.base.db.connection.DBConnectionPool|invalidateAllConnections|
Sun Oct 09 20:10:45 EDT 2005|JMS Session Delivery Thread|SEVERE|Error writing Event File status; Exception Select SELECT MD_EVT_FILE_STS.MIN_EVT_TIME,MD_EVT_FILE_STS.DATE_CREATED,MD_EVT_FILE_STS.FILE_NAME,MD_EVT_FILE_STS.FILE_MD5,MD_EVT_FILE_STS.MAX_EVT_TIME,MD_EVT_FILE_STS.MSG_CNT,MD_EVT_FILE_STS.FILE_ID,MD_EVT_FILE_STS.MODIFIED_BY,MD_EVT_FILE_STS.END_TIME,MD_EVT_FILE_STS.START_TIME,MD_EVT_FILE_STS.DATE_MODIFIED,MD_EVT_FILE_STS.EVT_CNT,MD_EVT_FILE_STS.CREATED_BY,MD_EVT_FILE_STS.FILE_STS FROM MD_EVT_FILE_STS WHERE ( MD_EVT_FILE_STS.FILE_ID = ? ) Params [ 1: '101400'] - SQLState : 08S01; esecurity.base.exceptions.PersistenceException; ; Caused by [esecurity][SQLServer JDBC Driver]Connection reset by peer: socket write error; java.sql.SQLException; ||||esecurity.ccs.comp.event.redirect.EventFileRedirectService|notifyFileComplete|
Sun Oct 09 20:10:45 EDT 2005|JMS Session Delivery Thread|SEVERE|esecurity.base.exceptions.PersistenceException: Select SELECT MD_EVT_FILE_STS.MIN_EVT_TIME,MD_EVT_FILE_STS.DATE_CREATED,MD_EVT_FILE_STS.FILE_NAME,MD_EVT_FILE_STS.FILE_MD5,MD_EVT_FILE_STS.MAX_EVT_TIME,MD_EVT_FILE_STS.MSG_CNT,MD_EVT_FILE_STS.FILE_ID,MD_EVT_FILE_STS.MODIFIED_BY,MD_EVT_FILE_STS.END_TIME,MD_EVT_FILE_STS.START_TIME,MD_EVT_FILE_STS.DATE_MODIFIED,MD_EVT_FILE_STS.EVT_CNT,MD_EVT_FILE_STS.CREATED_BY,MD_EVT_FILE_STS.FILE_STS FROM MD_EVT_FILE_STS WHERE ( MD_EVT_FILE_STS.FILE_ID = ? ) Params [ 1: '101400'] - SQLState : 08S01
at esecurity.base.query.db.BaseJDBCQuery.executeSelect(BaseJDBCQuery.java:245)
at esecurity.base.query.db.JDBCSelectQuery.execute(JDBCSelectQuery.java:271)
at esecurity.base.datamodel.LocalDataObjectManager.selectDataObjects(LocalDataObjectManager.java:337)
at esecurity.base.datamodel.LocalDataObjectManager.selectDataObject(LocalDataObjectManager.java:455)
at esecurity.base.datamodel.BaseDataObjectFactory.select(BaseDataObjectFactory.java:137)
at esecurity.base.datamodel.BaseDataObjectFactory.select(BaseDataObjectFactory.java:116)
at esecurity.db.object.EventFileStatusFactory.get(EventFileStatusFactory.java:48)
at esecurity.ccs.comp.event.redirect.EventFileRedirectService.updateFileStatus(EventFileRedirectService.java:278)
at esecurity.ccs.comp.event.redirect.EventFileRedirectService.notifyFileComplete(EventFileRedirectService.java:320)
at esecurity.ccs.comp.event.redirect.EventFileRedirectService.closeFile(EventFileRedirectService.java:232)
at esecurity.ccs.comp.event.redirect.EventFileRedirectService.writeMessage(EventFileRedirectService.java:134)
at esecurity.ccs.comp.event.EventStoreService.requestReceived(EventStoreService.java:187)
at esecurity.base.ccs.comp.BasicService.update(BasicService.java:134)
at java.util.Observable.notifyObservers(Observable.java:142)
at esecurity.base.ccs.dispatcher.DispatchHandler.onMessage(DispatchHandler.java:121)
at com.esecurity.common.communication.PreProcessorListenerBridge.onMessage(PreProcessorListenerBridge.java:53)
at com.esecurity.common.communication.strategy.sonicstrategy.SonicListener.onMessage(SonicListener.java:309)
at progress.message.jimpl.Session.nbB_(Unknown Source)
at progress.message.jimpl.TopicSession.run(Unknown Source)
at progress.message.jimpl.ep.run(Unknown Source)
Caused by: java.sql.SQLException: [esecurity][SQLServer JDBC Driver]Connection reset by peer: socket write error
at com.esecurity.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.esecurity.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.esecurity.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.esecurity.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown Source)
at com.esecurity.jdbc.sqlserver.tds.TDSRPCCursorExecuteRequest.submitPrepare(Unknown Source)
at com.esecurity.jdbc.sqlserver.tds.TDSRPCExecuteRequest.doPrepExec(Unknown Source)
at com.esecurity.jdbc.sqlserver.tds.TDSRPCExecuteRequest.execute(Unknown Source)
at com.esecurity.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)
at com.esecurity.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.esecurity.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.esecurity.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at esecurity.base.query.db.BaseJDBCQuery.executeSelect(BaseJDBCQuery.java:240)
... 19 more
||||esecurity.ccs.comp.event.redirect.EventFileRedirectService|notifyFileComplete|
Sun Oct 09 20:10:45 EDT 2005|JMS Session Delivery Thread|INFO|Opened file eventfiles\events_20051009_101401.dat in directory eventfiles||||esecurity.ccs.comp.event.redirect.EventFileRedirectService$OutputInfo|init|
Sun Oct 09 20:10:45 EDT 2005|JMS Session Delivery Thread|INFO|Created file events_20051009_101401.zip with archiveId 101,401||||esecurity.ccs.comp.event.redirect.EventFileRedirectService|openFile|
Sun Oct 09 20:10:48 EDT 2005|Thread-26|INFO|EventStore received 2 messages (.01/sec) with 2 events (.0eps) over last 170sec, waiting 0 running 0 size 34MB||||esecurity.ccs.comp.event.EventStoreService|batchFault|
Sun Oct 09 20:10:49 EDT 2005|Thread-59|SEVERE|Failed to insert 2 Events into table EVENTS_P_20051010030000 via ADO.net native connector ||||esecurity.ccs.comp.event.jdbc.ADOLoadStrategy|loadEvents|
Sun Oct 09 20:10:49 EDT 2005|Thread-59|SEVERE|; Exception Failed to insert events into table EVENTS_P_20051010030000 using ADO native connector; java.lang.RuntimeException; ||||esecurity.base.ccs.comp.BaseTask|run|
Sun Oct 09 20:10:49 EDT 2005|Thread-59|SEVERE|java.lang.RuntimeException: Failed to insert events into table EVENTS_P_20051010030000 using ADO native connector
at esecurity.ccs.comp.event.jdbc.ADOLoadStrategy.loadEvents(ADOLoadStrategy.java:137)
at esecurity.ccs.comp.event.jdbc.ADOLoadStrategy.load(ADOLoadStrategy.java:99)
at esecurity.ccs.comp.event.jdbc.BaseBulkLoaderImpl.bulkLoad(BaseBulkLoaderImpl.java:55)
at esecurity.ccs.comp.event.jdbc.JDBCEventStore.procAddEvents(JDBCEventStore.java:224)
at esecurity.ccs.comp.event.jdbc.JDBCEventStore.store(JDBCEventStore.java:181)
at esecurity.ccs.comp.event.EventStoreTask.doProcess(EventStoreTask.java:99)
at esecurity.ccs.comp.event.EventStoreTask.process(EventStoreTask.java:46)
at esecurity.base.ccs.comp.BaseTask.run(BaseTask.java:52)
at esecurity.base.ccs.comp.threadpool.TaskThreadPool$RunWrapper.run(TaskThreadPool.java:84)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)
at java.lang.Thread.run(Thread.java:534)
||||esecurity.base.ccs.comp.BaseTask|run|
Sun Oct 09 20:10:54 EDT 2005|Thread-45|INFO|Sending 1 system events on channel ewizard_binary_event||||esecurity.ccs.comp.dispatcher.BatchEventSender$Sender|run|


attached is the ADOEventStoreError.log with the following entry:


Log Entry : 10/9/2005 8:10:49 PM
Length cannot be less than zero.
Parameter name: length
at System.String.Substring(Int32 startIndex, Int32 length)
at System.Data.SqlClient.TdsParser.ProcessSNIError(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.CreateAndExecuteInitialQuery()
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
at EventInsert.ADOEventStore.addBatch(SByte[] dataToStore, String tableName, Boolean isEvent)