You are viewing limited content. For full access, please sign in.

Question

Question

Forms / Workflow routing failure

asked on October 16, 2014

I've got a support ticket in, but wanted to see if anyone else out there has had issues with forms and workflows and SQL (specifically SQL 2012)

 

When a Form is completed and submitted, the manager logs in and either approves or rejects the submission and may or may not enter a comment. The submission drops into the folder as it is supposed to, but may or may not begin routing via workflow. When investigating this issue it was discovered that the Forms Routing Service is showing errors, as is Laserfiche Forms.

We also noted that there is no reference to the Entry ID's associated with the submission in Workflow. Additionally Workflow itself threw an error.

DBCC integrity checks came back clean.

There have been issues with this environment for a while now and many of them keep coming back to what appears to be an SQL issue, but before we update SQL 2012 RTM to the SP2 I want to be sure there is not some other issue that is likely causing this.

1 0

Replies

replied on October 16, 2014

It's best to work through things in the support case, but upon initial glance at what's been provided, the Forms submissions may be having intermittent issues because of this

Bad field value ('Comment'): The parameter is out of range or too long. [9020]

It seems you are taking the comment entered in by the approver and sticking that into a field. However, the comment length is too long. So that's one thing that will need to be addressed. Forms 9.2 handles this situation better though.

 

As for Workflow itself, the log is reporting SQL timeout errors. Is SQL on a separate server and is it dedicated to Workflow?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.