Execution
Workflow Execution.
|
Name |
Type (MS SQL) |
Type (Oracle) |
Type (PostgreSQL) |
Nullable |
Description |
|---|---|---|---|---|---|
|
Id |
BIGINT |
NUMBER(20,0) |
int8 |
not null unique |
Reference to RlmObject |
|
DplPkgId |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to Package |
|
WfId |
BIGINT |
NUMBER(20,0) |
int8 |
not null |
Reference to Workflow |
|
DplProfileId |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to DeplProfile |
|
LoginId |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to LoginObject |
|
Status |
INT |
NUMBER(10,0) |
int4 |
not null |
Status of Execution. 0: WaitingApproval, 1: WaitingStartTime, 2: WaitingManualConfirm, 3: Active, 4: Blocked, 5: Rejected, 6: Revoked, 7: Canceled, 8: Finished, 9: Failed |
|
PlannedFrom |
DATETIME |
TIMESTAMP(4) |
timestamp |
|
Planned start time |
|
InstallationMode |
INT |
NUMBER(10,0) |
int4 |
not null |
Installation Mode: 0: Undefined, 1: OverwriteExistingComponents, 2: SkipExistingComponents |
|
OwnerId |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to Owner (User or Usergroup) |
|
ConfirmationById |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to Member confirming execution |
|
StartedById |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to Usr who started execution |
|
OwnerPassword |
NVARCHAR(512) |
NVARCHAR2(512) |
varchar(512) |
|
Password of user |
|
StartMode |
INT |
NUMBER(10,0) |
int4 |
not null |
Start Mode: 0: Immidiately, 1: ImmidiatelyWithConfirmation, 2: AtPlannedTime, 3: AtPlannedTimeWithConfirmation, 4: InQueue, 5: InQueueWithConfirmation |
|
RunId |
INT |
NUMBER(10,0) |
int4 |
|
RunId of related AE process |
|
DeploymentInfoId |
BIGINT |
NUMBER(20,0) |
int8 |
not null |
Reference to DeploymentInfo |
|
ActualFrom |
DATETIME |
TIMESTAMP(4) |
timestamp |
|
Actual start time |
|
ActualTo |
DATETIME |
TIMESTAMP(4) |
timestamp |
|
Actual end time |
|
FailedReason |
INT |
NUMBER(10,0) |
int4 |
not null |
Reason for fail: 0: NotFailed, 1: Unknown, 2: FailedInAutomationEngine, 3: NotApprovedInTime, 4: RelatedEntityChanged, 5: NotConfirmedInTime, 6: NotStartedInTime, 7: NoPermission, 8: AutomationEngineConnectionProblem, 9: WorkflowCannotBeFound, 10: QueueCannotBeFound |
|
RuntimeInSeconds |
INT |
NUMBER(10,0) |
int4 |
|
Duration in seconds |
|
QueueRunId |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to QueueRun |
|
RunOrder |
INT |
NUMBER(10,0) |
int4 |
|
RunOrder of Execution within a queue |
|
ProcessingTimeInQueue |
DATETIME |
TIMESTAMP(4) |
timestamp |
|
Start of processing of execution within a queue |
Indexes
|
Name |
Fields |
|---|---|
| IX_Exe_DplPkg | DplPkgId |
| IX_Exe_Wf | WfId |
| IX_Exe_DplProfile | DplProfileId |
| IX_Exe_Login | LoginId |
| IX_Exe_Owner | OwnerId |
| IX_Exe_ConfirmBy | ConfirmationById |
| IX_Exe_StartedBy | StartedById |
| IX_Execution_QueueRun | QueueRunId |
Foreign Keys
|
Name |
Local References |
Foreign References |
|---|---|---|
|
FK_Execution |
Id |
RlmObject |
|
FK_Exe_DplPkg |
DplPkgId |
Package |
|
FK_Exe_Wf |
WfId |
Workflow |
|
FK_Exe_DplProfile |
DplProfileIdDeplProfile |
DeplProfile |
|
FK_Exe_Login |
LoginId |
LoginObject |
|
FK_Exe_Owner |
OwnerId |
Usr |
|
FK_Exe_ConfirmBy |
ConfirmationById |
Member |
|
FK_Exe_StartedBy |
StartedById |
Usr |
|
FK_Exe_DeplInfo |
DeploymentInfoId |
DeploymentInfo |
|
FK_Execution_QueueRun |
QueueRunId |
QueueRun |