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

Question

Question

LF Forms Unexpected Error - Inclusive Gateway Fails Unless Activity Attached

Forms Version 10
Updated July 23, 2018
asked on April 16, 2018

We have a workflow that functions just fine when started and finished internally, but when external users use it it fails after following one particular branch:

No Missing Options will fail each time an external user submits the form. If it gets assigned to a user above, then it will be ok and continue as normal. As you can see, in order to stop failures, we threw in a user task just to click the approve on to avoid this issue for this branch.

We're at a loss as to why this may be - it's only external parties affected, and by routing it through somebody internal we avoid the issue altogether. If anyone has any ideas, we'd greatly appreciate it!

 

Thank you!

0 0

Replies

replied on April 16, 2018

Hi Phillip,

Can you give more information on the process?

1. What is the gateway setting on the first inclusive gateway?

2. What's the difference between "internal user" and "external user"? Did you use DMZ Forms or did you use public portals?

3. When you said "No Missing Options will fail each time an external user submits the form", how did it fail? Would the instance be terminated? If so, can you give us the instance error log?

0 0
replied on April 17, 2018

1. The gateway is configured as such:

2. We use public portals

3. It terminates as "Unexpected Error." Here is the error log in full:

Error4/16/2018 2:06:31 PM

An unexpected error has occurred. [LFF502-UnexpectedError] Details: URL: Error: UnexpectedError Date: 4/16/2018 2:06:31 PM (Mountain Standard Time) HTTP Status Code: 500 Business Process ID: 19 Instance ID: 16360 Business Process Name: Reisher Nomination Stack Trace: Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException Message: An unexpected error has occurred. [LFF502-UnexpectedError] Inner exception: System.Data.Entity.Core.EntityCommandExecutionException Message: An error occurred while executing the command definition. See the inner exception for details. at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Execute(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunctionCommand(EntityCommand entityCommand) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass4b.<ExecuteFunction>b__49() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction(String functionName, ObjectParameter[] parameters) at Laserfiche.Forms.EntityModels.FormsEntities.AddNewConvergingInfo(Nullable`1 bp_instance_id, Nullable`1 process_id, Nullable`1 step_id, Nullable`1 prev_step_id, Nullable`1 worker_instance_id, ObjectParameter return_value) at Laserfiche.Forms.Routing.InclusiveGateway._UpdateConvergingInfo(Int32 mainProcInstId, Int32 processId, Int32 stepId, Int32 prevStepId, Int32 workerInstanceId, IFormsEntities _db, Int32 retryCount) at Laserfiche.Forms.Routing.InclusiveGateway.MergeChecking(Int32 instanceId, IRoutingContext routingContext) at Laserfiche.Forms.Routing.Gateway.Merge(cf_bp_worker_instances processInstance, Int32 instanceId, IRoutingContext routingContext) at Laserfiche.Forms.Routing.Gateway.Execute(Int32 instanceId, IRoutingContext routingContext) at Laserfiche.Forms.Routing.RoutingDispatcher.ExecuteSteps() Inner exception: System.Data.SqlClient.SqlException Message: The EXECUTE permission was denied on the object 'cf_AddNewConvergingInfo', database 'LFforms', schema 'dbo'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

0 0
replied on April 17, 2018

Rui - turns out our forms portal is screwed up in configuration. We're working with our VAR to sort out. You can delete or mark this post as done if you'd like. Thank you for your help!

0 0
replied on July 23, 2018

Hi,

 

Could you update what was done to resolve this?

 

Thanks.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...