Topic

Instructions

The “dbo.WorkflowLog” table on Nintex databases stores the verbose logging that is set per Nintex workflow. Due to the amount of resources consumed, it is recommended that verbose Logging be turned off unless requested by Nintex Support  in order to diagnose an issue.

To clean up the dbo.WorkflowLog tables
Open SQL Server Management Studio, connect to the Nintex Workflow databases and truncate the databases by performing the following steps:

1. Ensure that verbose logging is OFF - Central Admin > Nintex Workflow Management > Global Settings and un-tick the “Enable Verbose Logging” option.
2. Perform an IISReset
3. Restart the SharePoint Timer Service
4. Execute the following SQL command on your Nintex Databases:
USE [YourNintexDatabase]

GO

DECLARE @return_value int

EXEC @return_value = [dbo].[PurgeVerboseLogs]
@DaysToKeep = 0

SELECT 'Return Value' = @return_value

GO

If for whatever reason the above script does not work, simply run TRUNCATE to clear the table.

TRUNCATE Table dbo.WorkflowLog