Developer forum

Forum » CMS - Standard features » How do i clear statistics?

How do i clear statistics?

E-mail notifications
Hans Ravnsfjall
Reply
Posted on 25/04/2016 12:14:59

Hi

I have a solution that says "Solution session statistics exceeds 4 GB - Performance can be affected, purge is recommended"
 

I have tried purgin, but that doesn´t work.

I have tried this in the SQL firehose, but no luck. Get this message amongst others "The following message was returned by the server: Cannot truncate table 'dbo.Statv2Object' because it is being referenced by a FOREIGN KEY constraint"

truncate table statv2session
truncate table dbo.Statv2SessionBot
truncate table dbo.Statv2Page
truncate table dbo.Statv2Object

How can i fix the problem?


Replies

 
Nicolai Høeg Pedersen
Posted on 25/04/2016 12:53:20
Reply

Which version are you on?

 
Hans Ravnsfjall
Posted on 25/04/2016 14:03:27
Reply

It´s  version 8.6.1.25

 
Nicolai Høeg Pedersen
Posted on 25/04/2016 15:04:13
Reply
This post has been marked as an answer

There has been a number of improvements and fixes on the 8.7 branch, so I recommend that you upgrade to get these fixes.

BR Nicolai

Votes for this answer: 1
 
Hans Ravnsfjall
Posted on 25/04/2016 15:48:46
Reply

Ok, seems to work - tank you :)

 

You must be logged in to post in the forum