Delete Completed/Cancelled Forms from SQL (Forms 10.2)

asked on March 12, 2018 • Show version history

Hi,

We had a looping issues with Laserfiche Forms and Workflow a while back which filled up our SQL database (problem has now been resolved).

Using the following SQL query on our Forms database we found that there were A LOT of errors produced by these loops:

SELECT COUNT(*) FROM [Laserfiche_Forms].[dbo].[bp_instance_errors]

Using the below query we found the problem Forms instances:

SELECT [bp_instance_id], [bp_id], COUNT(bp_instance_id) AS ErrorCount
FROM [Laserfiche_Forms].[dbo].[bp_instance_errors]
GROUP BY [bp_instance_id], [bp_id]
ORDER BY ErrorCount DESC

After deleting the instances with the high error count from Forms using the web page we found that these instances were the cause to why our Instance Monitoring was so slow to load.

On one of our servers with a lot of errors, when trying to delete the instances from the Forms web page we receive the following error:

Message: An unexpected error has occurred. [LFF502-UnexpectedError]

Inner exception: System.ArgumentException
Message: The SqlParameter is already contained by another SqlParameterCollection.

Is there an updated script to remove Completed or Cancelled Forms from SQL instead? There used to be one for 10.1.

Thanks,

Dom

0 0

Question

Question

Delete Completed/Cancelled Forms from SQL (Forms 10.2)

Replies

Sign in to reply to this post.