MIGRATION_FRONT view: Business Process Choreographer database view

IBM BPM, V8.0.1, All platforms > Reference > Database views for Business Process Choreographer
MIGRATION_FRONT view

Use this predefined Business Process Choreographer database view to query where the process instance was in its navigation when it was migrated to the new version of the process template. The migration front represents the activities that were either active or just completed when the migration occurred.

process instance ID.
Columns in the MIGRATION_FRONT view
Column name Type Comments
SOURCE_PTID ID The ID of the process template that is associated with the process instance before migration.
TARGET_PTID ID The ID of the process template that is associated with the process instance after migration.
AIID ID The ID of an activity that was part of the process navigation front when the process was migrated. The migration front consists of the last activity reached by the process navigation on each parallel branch when the process was migrated.
SOURCE_ATID ID The ID of the activity template before migration.
TARGET_ATID ID The ID of the activity template after migration.
If the activity was completed before the process instance was migrated, the activity template ID does not change.
MIGRATION_TIME Timestamp The time that the process instance was migrated.
STATE Integer The state of the activity when the process instance was migrated. Possible values are:
STATE_READY (2)
STATE_RUNNING (3)
STATE_SKIPPED (4)
STATE_FINISHED (5)
STATE_FAILED (6)
STATE_TERMINATED (7)
STATE_CLAIMED (8)
STATE_TERMINATING (9)
STATE_FAILING (10)
STATE_WAITING (11)
STATE_EXPIRED (12)
STATE_STOPPED (13)
SUBSTATE Integer
The substate of the activity when the process instance was migrated. Possible values are:
SUB_STATE_NONE (0)
SUB_STATE_EXPIRING (1)
SUB_STATE_SKIPPING (2)
SUB_STATE_RESTARTING (3)
SUB_STATE_FINISHING (4)
SUB_STATE_FAILING (5)
STOP_REASON Integer
The reason why the activity stopped. Possible values are:
STOP_REASON_UNSPECIFIED (1)
STOP_REASON_ACTIVATION_FAILED (2)
STOP_REASON_IMPLEMENTATION_FAILED (3)
STOP_REASON_FOLLOW_ON_NAVIGATION_FAILED (4)
STOP_REASON_EXIT_CONDITION_FALSE (5)

Database views for Business Process Choreographer

Column name	Type	Comments
SOURCE_PTID	ID	The ID of the process template that is associated with the process instance before migration.
TARGET_PTID	ID	The ID of the process template that is associated with the process instance after migration.
AIID	ID	The ID of an activity that was part of the process navigation front when the process was migrated. The migration front consists of the last activity reached by the process navigation on each parallel branch when the process was migrated.
SOURCE_ATID	ID	The ID of the activity template before migration.
TARGET_ATID	ID	The ID of the activity template after migration. If the activity was completed before the process instance was migrated, the activity template ID does not change.
MIGRATION_TIME	Timestamp	The time that the process instance was migrated.
STATE	Integer	The state of the activity when the process instance was migrated. Possible values are: STATE_READY (2) STATE_RUNNING (3) STATE_SKIPPED (4) STATE_FINISHED (5) STATE_FAILED (6) STATE_TERMINATED (7) STATE_CLAIMED (8) STATE_TERMINATING (9) STATE_FAILING (10) STATE_WAITING (11) STATE_EXPIRED (12) STATE_STOPPED (13)
SUBSTATE	Integer	The substate of the activity when the process instance was migrated. Possible values are: SUB_STATE_NONE (0) SUB_STATE_EXPIRING (1) SUB_STATE_SKIPPING (2) SUB_STATE_RESTARTING (3) SUB_STATE_FINISHING (4) SUB_STATE_FAILING (5)
STOP_REASON	Integer	The reason why the activity stopped. Possible values are: STOP_REASON_UNSPECIFIED (1) STOP_REASON_ACTIVATION_FAILED (2) STOP_REASON_IMPLEMENTATION_FAILED (3) STOP_REASON_FOLLOW_ON_NAVIGATION_FAILED (4) STOP_REASON_EXIT_CONDITION_FALSE (5)