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

Question

Question

Form(s) terminated

asked on May 13, 2016 Show version history

I created a web application for this customer, it consists of an initial form on one server, once submitted, it starts a Workflow in a secondary server, which invokes a second forms process.
 (Client didn't want their web server associated with their domain)

 

The issue is that I get random instances that terminate once it gets to the second server, and goes into the first user task. Some instances go through fine, and some get terminated. Not sure as to why it does this. (When this happens, I have to go back and manually resubmit the job application, and push the application through again. Really wish Laserfiche had a resubmit button for things like this)

 

Event Viewer gives me this error (Same error for the instances that have been terminated):

An unexpected error has occurred. [LFF502-UnexpectedError] Details: URL: Error: UnexpectedError Date: 5/9/2016 10:02:30 PM (Pacific Standard Time) HTTP Status Code: 500 Business Process Name: Web Application Business Process ID: 3 Instance ID: 125 Stack Trace: Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException Message: An unexpected error has occurred. [LFF502-UnexpectedError] Inner exception: System.InvalidOperationException Message: Unexpected connection state. When using a wrapping provider ensure that the StateChange event is implemented on the wrapped DbConnection. at System.Data.Entity.Core.Objects.ObjectContext.EnsureContextIsEnlistedInCurrentTransaction[T](Transaction currentTransaction, Func`1 openConnection, T defaultValue) at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate) at Laserfiche.Forms.EntityModels.cf_timers.FindTrigger(IEntityContext appContext, String type, Int32 processId, Nullable`1 mainInstanceId, Nullable`1 stepId) at Laserfiche.Forms.EntityModels.cf_timers.AddTrigger(IEntityContext appContext) at Laserfiche.Forms.Routing.Activity.RegisterBoundaryEvents(cf_bp_worker_instances processInstance, IRoutingContext routingContext) at Laserfiche.Forms.Routing.UserTask.ExecuteForNewEntry(cf_bp_worker_instances processInstance, IRoutingContext routingContext) at Laserfiche.Forms.Routing.UserTask.Execute(Int32 instanceId, IRoutingContext routingContext) at Laserfiche.Forms.Routing.RoutingDispatcher.ExecuteSteps() 

 

 

Any help? Thanks!

0 0

Replies

replied on May 16, 2016 Show version history

What version of Forms are you using?Does the user task step show assign action in history when check instance history. There is a known issue for 10.0 that user task sometimes may get terminated and will be addressed in the Update which are going to be released in the coming two weeks.

0 0
replied on May 16, 2016

Our customer is using Forms 10.

 

Under the user task that it gets terminated at, it shows

"The task was assigned to...." with the six users and a time/date stamp.

 

I will let our client know about the update, thank you!

0 0
replied on May 16, 2016

I just got the same error on a form. I am schedule to upgrade to Forms 10.1. But, from what you said that there is another upgrade coming that addresses this issue?

BTW Is there anyway to restart the form?

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Error 5/16/2016 10:17:43 AM
An unexpected error has occurred. [LFF502-UnexpectedError]

Details:
URL: 
Error: UnexpectedError
Date: 5/16/2016 10:17:43 AM (Pacific Standard Time)
HTTP Status Code: 500
Business Process Name: Personnel Requisition
Business Process ID: 6
Instance ID: 260

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: An unexpected error has occurred. [LFF502-UnexpectedError]


Inner exception: System.Data.Entity.Core.EntityException
Message: The underlying provider failed on Open.
   at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
   at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Laserfiche.Forms.EntityModels.cf_bp_steps.GetBoundaryEventsByParentId(IEntityContext appContext, Int32 processId, Int32 parentId, BoundaryEvtType bevtType)
   at Laserfiche.Forms.Routing.Activity.RegisterBoundaryEvents(cf_bp_worker_instances processInstance, IRoutingContext routingContext)
   at Laserfiche.Forms.Routing.UserTask.ExecuteForNewEntry(cf_bp_worker_instances processInstance, IRoutingContext routingContext)
   at Laserfiche.Forms.Routing.UserTask.Execute(Int32 instanceId, IRoutingContext routingContext)
   at Laserfiche.Forms.Routing.RoutingDispatcher.ExecuteSteps()

Inner exception: System.InvalidOperationException
Message: The connection was not closed. The connection's current state is connecting.
   at System.Data.ProviderBase.DbConnectionClosedConnecting.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.EntityClient.EntityConnection.Open()

1 0
replied on May 16, 2016 Show version history

I agree with Martin on this. It would be nice to have a resubmit option instead of having to go back and having to manually re-enter all the information for Terminated workflows

1 0
replied on May 16, 2016

There is an update for 10.0 will coming soon in next two weeks which will address this error. 

I will bring back support retry terminated user task feature request back to the team.

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

Sign in to reply to this post.