| 24/2007 10:53:41 AM |
9/24/2007 10:53:44 AM |
False |
Import Started. Failed SpyIISLog service. Exception: System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_Stat_RequestInfo_Stat_Visitors". The conflict occurred in database "BBFBECF", table "dbo.Stat_RequestInfo", column 'VisitorId'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Mediachase.Web.Statistics.DBHelper.RunSP(String strSP, Object[] paramList) at Mediachase.Web.Statistics.Data.FillRequestInfo() at Mediachase.Web.Statistics.Data.StatProcessing() at Mediachase.eCF.Plugins.Services.Statistics.SpyIISLogService.ProcessData() in C:\Projects\BBFB\eCFImportLog\ProcessIISLog.cs:line 114 at Mediachase.eCF.Plugins.Services.Statistics.SpyIISLogService.Execute() in C:\Projects\BBFB\eCFImportLog\ProcessIISLog.cs:line 138 |
it gives this error can anybody tell me wat would be the correcy reason for it?
after giving this error it again working fine.and before everything was ok
in history page i m getting this error and also new visitor is created after it.
Regards,
manish