Question:
I have tried to use the K2 Archiving function in K2 workspace many times, but it just doesn't work that well. I end up with a lot of SQL blocking and the process fails. Is there a way to manually archive or delete K2 Log data using SQL? Surely there is some stored proc that is executed that we could also execute manually. I do not particularly care about keeping the data but we do have a K2 Archive database set up we could move the records to.
Answer:
Yes there is a Stored Procedure that can be used instead of using the Archiving feature in K2 Workspace.
Resolution:
Please log a Support Ticket and request the latest version of the 'mArchive' Stored Procedure.