Home > Forum > Rules, JS, SQL > Webcon LogCleaner spams sql server

Webcon LogCleaner spams sql server
0

Does someone know how to fix this problem? The cleaner fills our sql server with error messages that took 20gb of space after few days.
This Error occours even when using a different version and virtual server.

MVP

Hi Almin,

I have no idea what the LogCleaner actually does and which table it cleans.

If you know how to trigger it, you could run the SQL Profiler and take a look at the executed SQL statements to get the one which is failing.

I have only one idea, but I doubt, that it would be related to the error.
While date time fields are stored in columns of type date time, the item list date time fields are stored as nvarchar.
In theory you could have deleted a column in the past and a now a new date time column was added. When the system is converting the values of this column to datetime it fails for all the old instances because of some invalid data.

But I don't see how this could be related to the issue.

Best regards,
Daniel

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings