_deletedentitylog spaming

[anderseriksson]

Have a testserver for Qlik Sense.
On that the Repository DB table _deletedentitylog is going crazy and spaming GBs of data filling up the C-drive.
This happens in short amount of time and causes problems to the server even though it is a test server (with test licens) and very few occasional  users.
I've followed this article in order to limit was is logged and have Qlik clean the table more frequently but does not help.
https://community.qlik.com/t5/Official-Support-Articles/deletedentitylogs-take-up-disk-space-on-C/ta...

Did see a comment of someone deleting this table and running without it, is that safe?
I have truncated the table on several occasions last month to free up many GBs of space.
Today that recovered 30 GBs even though the configuration says to clean the table after three days!

What can cause this amount of data being logged to this table in short time?
Entity Type = StaticContentReference looks to be very frequently logged.

[Alan_Slaughter]

Hi Anderseriksson, I would suggest the following articles:

1. https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Steps-to-reduce-Excessive-HDD-spa...

2. https://community.qlik.com/t5/Official-Support-Articles/Deprecation-of-Centralized-Logging-in-Qlik-S...

3. https://community.qlik.com/t5/Official-Support-Articles/Failed-to-log-deleted-entities-Error-duplica...

[anderseriksson]

Thanks for the reply Alan, but;
1) article is about logging database, our problem is specifically with QSR table _deletedentitylog 
2) again article is about logging database
3) article is about not being able to add new rows to _deletedentitylog, the opposite of our problems

In less than 24 hours of running the test server with minimal usage the QSR _deletedentitylog table has accumulated more than 3 million rows!

[anderseriksson]

Production server where the QSR._deletedentitylog has not been cleaned for a long time only has 90 000 rows!

[anderseriksson]

Now implementing the sql-delete scheduled in Windows from this post;
https://community.qlik.com/t5/Official-Support-Articles/Failed-to-log-deleted-entities-Error-duplica...

[Chip_Matejowsky]

Hi @anderseriksson,

Have a look at Qlik knowledgebase article _deletedentitylogs take up disk space on C:\ to see if that is what you need.

Best Regards

 

[anderseriksson]

I already mentioned that article in my initial posting!
That is not what I need and it did not help.

[Filippo_Nicolussi_P]

@anderseriksson  based on that article you could add  to : 

<add key="DeletedEntityLog.ExcludedEntities" value="TempContent;ExecutionResult;ExecutionResult.Detail;ExecutionSession;StaticContentReference" />

Based on your request I suppose you used on the DB a query like "select count("entityid"),"entitytype" from "_deletedentitylog" group by "entitytype" order by count("entityid") desc;" 

to get  the most mutable/deleted entity types, that you could more or less add to the option  DeletedEntityLog.ExcludedEntities.

Unfortunately  <add key="DeletedEntityLog.ExcludedEntities" value="*" />  is not allowed.