Developer forum

Forum » CMS - Standard features » Error in statistics table?

Error in statistics table?

Nuno Aguiar
Reply
Hi,

Looking at PageView Log, we always get this error in statistcs in all our solutions (running Dw7.2)

ERROR: System.Data.SqlClient.SqlException: The record can't be added or changed. Referential integrity rules require a related record in table 'Statv2Object'. The transaction ended in the trigger. The batch has been aborted. 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.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Dynamicweb.Frontend.Statistics.SessionStatistics()

Anyone knows why or how to fix the issue? We do get statisctics on the website

Best Regards,
Nuno


Replies

 
Nuno Aguiar
Reply
 Hi,

Did anyone see this post? It would be nice to have some answers so we know what the problem is and/or go around it.

Is it a problem? Are there any performance downsides? What can we do to avoid this?

Nuno

 

You must be logged in to post in the forum