Sentinel: Error saving summary batch to the database for summary EventSevSummary - Error WITH CHECK option

  • 3389057
  • 17-Aug-2006
  • 26-Apr-2012

Environment

Sentinel
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server

Situation

Getting the error, "Error WITH CHECK option" when ADO strategy is turned on?

Resolution

This error is due to a .NET version incompatibility. This will occur if .Net2 SDK is installed instead of .Net2 beta 2.

Additional Information

Error Log:
========================
Error saving summary batch to the database for summary EventSevSummary - Error WITH CHECK option?

Received this Sev 4 Internal Event and the following was in my das_binary.log:

Sun Oct 09 21:43:18 EDT 2005|Thread-28|INFO|Aggregating events_20051009_101600.zip in directory eventfiles/done||||esecurity.ccs.comp.event.transformer.AggregateFile|aggregate|
Sun Oct 09 21:43:18 EDT 2005|Thread-28|INFO|Loaded 80 objects for ResourceDim||||esecurity.ccs.comp.transform.PersistentDataObjectMap|load|
Sun Oct 09 21:43:18 EDT 2005|Thread-28|INFO|Loaded 48 objects for EventNameDim||||esecurity.ccs.comp.transform.PersistentDataObjectMap|load|
Sun Oct 09 21:43:18 EDT 2005|Thread-28|INFO|Loaded 250 objects for UserDim||||esecurity.ccs.comp.transform.PersistentDataObjectMap|load|
Sun Oct 09 21:43:18 EDT 2005|Thread-28|INFO|Loaded 250 objects for UserDim||||esecurity.ccs.comp.transform.PersistentDataObjectMap|load|
Sun Oct 09 21:43:19 EDT 2005|Thread-28|INFO|File processing completed, processed 1,603 events in 1sec||||esecurity.ccs.comp.event.transformer.AggregateFile|aggregate|
Sun Oct 09 21:43:19 EDT 2005|Thread-28|INFO|Resources used: Event Normalization 31Kb, Event Transformer 196Kb, Summaries: 195Kb in 528 entries||||esecurity.ccs.comp.event.transformer.AggregateFile|aggregate|
Sun Oct 09 21:43:20 EDT 2005|Thread-28|SEVERE|; Exception [esecurity][SQLServer JDBC Driver][SQLServer]The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.; com.esecurity.jdbc.base.BaseBatchUpdateException; ||||esecurity.ccs.summary.ObjectSummary|writeToDb|
Sun Oct 09 21:43:20 EDT 2005|Thread-28|SEVERE|com.esecurity.jdbc.base.BaseBatchUpdateException: [esecurity][SQLServer JDBC Driver][SQLServer]The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.
at com.esecurity.jdbc.sqlserver.SQLServerImplStatement.getBatchRowsAffectedCount(Unknown Source)
at com.esecurity.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
at com.esecurity.jdbc.base.BaseCallableStatement.executeBatch(Unknown Source)
at esecurity.ccs.summary.ObjectSummary.writeToDb(ObjectSummary.java:292)
at esecurity.ccs.summary.ObjectSummary.close(ObjectSummary.java:553)
at esecurity.ccs.comp.event.transformer.AggregateFile$SummaryFile.save(AggregateFile.java:556)
at esecurity.ccs.comp.event.transformer.AggregateFile.save(AggregateFile.java:296)
at esecurity.ccs.comp.event.transformer.AggregateFile.close(AggregateFile.java:313)
at esecurity.ccs.comp.event.transformer.AggregateFile.aggregate(AggregateFile.java:106)
at esecurity.ccs.comp.event.transformer.EventAggregationService$AggregationTask.processFile(EventAggregationService.java:286)
at esecurity.ccs.comp.event.transformer.EventAggregationService$AggregationTask.run(EventAggregationService.java:241)
at java.lang.Thread.run(Thread.java:534)
||||esecurity.ccs.summary.ObjectSummary|writeToDb|
Sun Oct 09 21:43:20 EDT 2005|Thread-28|INFO|Closing Summary = EventDestSummary: Wrote 0 batch(es) of 0 entries with total count 0 event(s) in 0 sec, average 0 entries per second ||||esecurity.ccs.summary.ObjectSummary|close|
Sun Oct 09 21:43:20 EDT 2005|Thread-28|SEVERE|; Exception [esecurity][SQLServer JDBC Driver][SQLServer]The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.; com.esecurity.jdbc.base.BaseBatchUpdateException; ||||esecurity.ccs.summary.ObjectSummary|writeToDb|
Sun Oct 09 21:43:20 EDT 2005|Thread-28|SEVERE|com.esecurity.jdbc.base.BaseBatchUpdateException: [esecurity][SQLServer JDBC Driver][SQLServer]The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.
at com.esecurity.jdbc.sqlserver.SQLServerImplStatement.getBatchRowsAffectedCount(Unknown Source)
at com.esecurity.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
at com.esecurity.jdbc.base.BaseCallableStatement.executeBatch(Unknown Source)
at esecurity.ccs.summary.ObjectSummary.writeToDb(ObjectSummary.java:292)
at esecurity.ccs.summary.ObjectSummary.close(ObjectSummary.java:553)
at esecurity.ccs.comp.event.transformer.AggregateFile$SummaryFile.save(AggregateFile.java:556)
at esecurity.ccs.comp.event.transformer.AggregateFile.save(AggregateFile.java:296)
at esecurity.ccs.comp.event.transformer.AggregateFile.close(AggregateFile.java:313)
at esecurity.ccs.comp.event.transformer.AggregateFile.aggregate(AggregateFile.java:106)
at esecurity.ccs.comp.event.transformer.EventAggregationService$AggregationTask.processFile(EventAggregationService.java:286)
at esecurity.ccs.comp.event.transformer.EventAggregationService$AggregationTask.run(EventAggregationService.java:241)
at java.lang.Thread.run(Thread.java:534)
||||esecurity.ccs.summary.ObjectSummary|writeToDb|
Sun Oct 09 21:43:20 EDT 2005|Thread-28|INFO|Closing Summary = EventSevDestTxnmySummary: Wrote 0 batch(es) of 0 entries with total count 0 event(s) in 0 sec, average 0 entries per second ||||esecurity.ccs.summary.ObjectSummary|close|
Sun Oct 09 21:43:20 EDT 2005|Thread-28|SEVERE|; Exception [esecurity][SQLServer JDBC Driver][SQLServer]The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.; com.esecurity.jdbc.base.BaseBatchUpdateException; ||||esecurity.ccs.summary.ObjectSummary|writeToDb|
Sun Oct 09 21:43:20 EDT 2005|Thread-28|SEVERE|com.esecurity.jdbc.base.BaseBatchUpdateException: [esecurity][SQLServer JDBC Driver][SQLServer]The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.
at com.esecurity.jdbc.sqlserver.SQLServerImplStatement.getBatchRowsAffectedCount(Unknown Source)
at com.esecurity.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
at com.esecurity.jdbc.base.BaseCallableStatement.executeBatch(Unknown Source)
at esecurity.ccs.summary.ObjectSummary.writeToDb(ObjectSummary.java:292)
at esecurity.ccs.summary.ObjectSummary.close(ObjectSummary.java:553)
at esecurity.ccs.comp.event.transformer.AggregateFile$SummaryFile.save(AggregateFile.java:556)
at esecurity.ccs.comp.event.transformer.AggregateFile.save(AggregateFile.java:296)
at esecurity.ccs.comp.event.transformer.AggregateFile.close(AggregateFile.java:313)
at esecurity.ccs.comp.event.transformer.AggregateFile.aggregate(AggregateFile.java:106)
at esecurity.ccs.comp.event.transformer.EventAggregationService$AggregationTask.processFile(EventAggregationService.java:286)
at esecurity.ccs.comp.event.transformer.EventAggregationService$AggregationTask.run(EventAggregationService.java:241)
at java.lang.Thread.run(Thread.java:534)