SaaS CMS has officially launched! Learn more now.

Change Log Auto Truncate not clearing logs

Vote:
 

Hi all,

I recently noticed quite strange thing happening with the "Change Log Auto Truncate" Episerver job. I doesn't seem to be deleting any logs. Looking at job's history log, it runs regurally but the "tblActivityLog" table in the databse is still growing record-wise. I don't recall changing any setting in the web.config which might have altered this job execution. Moreover when I run the "netActivityLogTruncate" stored procedure manually - it does clear right data.

Do you have any idea/knowledge what needs to be set in order to get this job do its "job" again?

BTW: I'm running Episerver version 9.5.0

Thanks,

Frank

#157783
Edited, Sep 21, 2016 17:46
Vote:
 

There was a bugfix released in EPiServer.CMS.Core 9.8.1 that might solve your issue

http://world.episerver.com/documentation/Release-Notes/ReleaseNote/?releaseNoteId=CMS-3218

#157785
Edited, Sep 21, 2016 22:13
Vote:
 

Hi Johan,

 

Thank you for your reply,

 

Unfortunately we are not in position to upgrade your Episerver application to that version yet. In the meantime, would you consider running the "netActivityLogTruncate" stored procedure as SqlServer job safe?

(I presume that's what the "Change Log Auto Truncate" Episerver job does under the hood.)

Thanks,

Frank

#157792
Sep 22, 2016 10:21
Vote:
 

It is possible to run the sproc manually, it is though not officially supported, with that said:

Currently there are a few functions that are dependent on the change/activity log. First there are the two jobs BlobCleanupJob and CleanUnusedAssetFolderJo, so I would suggest that you execute them before running the procedure. 

Then there is mirroring, same applies there if you are using mirroring, execute that job before truncation.

The last thing that has a dependency (at least in CMS, I am not aware if any other addon/module are dependent on the activity log) is projects (which might be the thing that prevents the truncation job from truncating anything). What will happen if you run the truncation script is that things that are dsiplayed in project overview will disseapear. So the suggestion is to execute the procedure with a Date set for parameter @CreatedDate where you can select the date from how old project entries that should be shown.

#157794
Sep 22, 2016 10:32
Vote:
 

Thanks for the explanation Johan!

I intend to leave at least 2-3 worth of latest log entries anyway.

Thanks,

Frank

#157798
Sep 22, 2016 12:52
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.