www.skelta.com
Home      Members   Calendar   Who's On

Welcome Guest ( Login | Register )
      

Home » BPM.NET 2007/Sharepoint Accelerator 2007 » BPM.NET 2007/Sharepoint Accelerator 2007 » Database » Workflow Acivities Details


Workflow Acivities DetailsExpand / Collapse
Author
Message
Posted Wednesday, March 19, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
Hello

In wich table stored Workflow Acivities Details such as Timeout for Activity, Actors and other?

Thanks

Post #693
Posted Wednesday, March 19, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hi Jimmilee,

You will be able to get the details of Skelta Tables from the Skelta Help File. Please search for Database quick reference in help file, you will get the details.

Skelta BPM.Net 2007 help files are available for download from the Skelta Website, you can access the link at the product download page.

Regards

RSimon

Post #694
Posted Monday, March 24, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
I read help but didn't find this information
Post #711
Posted Tuesday, March 25, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hi

These details can be obtained from a combination of tables and the main tables involved are,

SWExecute

This table stores information about the workflows that are executed. From this table, the total number of workflows that are instantiated can be determined. It also gives the execution status of the workflow like Finished (FN), Sleep Mode (SL), Execution Finished with Error (FE) etc.

SWExecutionDetails

This table stores information about the activities, their links, status etc. that are involved in a particular execution. It may have resource dependant activities like Approval, Information, Checklist etc. or resource independent actions like Email, Script etc. This table has a collection of instances of activities that are triggered.

SKWorkItem

This table stores details about the Tasks assigned to an actor

SKHWSActivity

This table stores the Activity instance details

Regards,

RS

Post #716
Posted Tuesday, March 25, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
This details I already see

But I need to obtain information about timeouts in workflow template

I found it only in "swstaginglong" table and only in xml format

- <property name="Timeout for Acknowledgement">
<![CDATA[ 0 ]]>
  </property>
- <property name="Timeout warning for Action">
<![CDATA[ 0 ]]>
  </property>
- <property name="Timeout for Action">
<![CDATA[ 0.00:01:00  ]]>
 
Can I obtain it with another methods?
Post #717
Posted Tuesday, March 25, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hi,

The column 'TimeOutData' in table SKHWSActivity stores the timeout data whose details can be obtained from table SWTaskList

Regards,

RS

Post #718
Posted Tuesday, March 25, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
Activity "Approve1" with TimeOut exists in table "SKHWSActivity"

"TimeOutData" Field:

<timeoutdata><timeout taskid="22" timeouttype="MULTIPLEACTIVITYWARNINGTIMEOUT" /></timeoutdata>

But "SWTaskList" Table has no rows

Post #719
Posted Tuesday, March 25, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hi,

Mutiple Time Out warning is stored in a combination of two tables, SKMultipleTimeoutWarning and SWTaskList.

Regards,

RS

Post #725
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
-
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.

All times are GMT -5:00, Time now is 7:31am

 
Execution: 0.188.12 queries.Compression Enabled.

Copyright © 2002 - 2007 Skelta Software. All rights reserved. Tel: 1 (703) 229-6732 | Email:sales@skelta.com
Skelta - A BPM Workflow Software Company