Question

Suspended Forms

Forms

Updated January 15, 2016

asked on March 27, 2015

Hi There

I wanted to know which table and field stores the status of a form i.e. active,cancelled,complete or suspended.

Currently there is no global retry for suspended forms and we have to manually find these and re-run them. Not sure why they go into a suspended state as when I retry them they run correctly without making any additional changes, guess its something to do with subscriber not loading correctly after a system reboot.

If I can find the table and field that stores this information(status suspended) I can compile an automated daily report of all suspended forms and then go and re-run them proactively.

Thanks

Farren

0 0

Answer

SELECTED ANSWER

replied on March 31, 2015

The table is [cf_bp_worker_instances].

Check the [status] column for step status:

User task waiting for approval is 2;

Running service is 3;

Completed is 8;

Terminated is 9;

Suspended is 11.

You can use [bp_instance_id] and [current_process_id] in this table to find corresponding instance and process.

2 0

replied on April 2, 2015

Thanks For this!

0 0

replied on April 9, 2015

Can you provide a complete list of statuses? I have 4,6,7,8, and 10.

0 0

replied on April 14, 2015

6,7 are for gateway split/merge;

10 is interrupted (used when user task is interrupted by boundary timer);

as for 4 and others, they are kinds of intermediate state.

2 0

Replies

replied on April 30, 2015

What do you mean by re-run them? if you change the status from terminated to 3, the forms continue?

Thanks

0 0

replied on January 15, 2016

Hi there,

Instance Monitoring that show instances status for all Business Processes is supported in Laserfiche Forms 10.

0 0

You are not allowed to follow up in this post.

Question

Question

Suspended Forms

Answer

Replies

Sign in to reply to this post.