C.1 Table information about process instance execution log management
- Organization of this subsection
(1) Table information
The following tables are required for every HCSC cluster.
-
Basic information table
-
Variable information table
-
Message log related information table
(a) Basic information table
The basic information table stores the basic elements (instances) of business process execution.
- •CSCBP_<cluster name>_PROCESS table
-
The contents of CSCBP_<cluster name>_PROCESS table are as follows:
No.
Column name
Description
HiRDB type
ORACLE type
Existence of index
NULL value
Update
Default value
1
ProcessID
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
2
ProcessDefinitionName
BP definition name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
3
ProcessDefinitionVersion
BP definition version
SMALLINT
NUMBER(5)
No
Not possible
Not possible
Not possible
4
State
Process instance status
VARCHAR(20)
VARCHAR2(20)
Yes
Not possible
Yes
Not possible
5
ChangeCount#1
Number of data updates
INTEGER#2
NUMBER(10) #3
No
Not possible
Possible
Not possible
6
StartTime
Process instance Start time (GMT)
TIMESTAMP(0)
TIMESTAMP(0)
Yes
Possible
Possible
NULL
7
EndTime
Process instance end time (GMT)
TIMESTAMP(0)
TIMESTAMP(0)
Yes
Possible
Possible
NULL
8
CSCServerName
Last executed HCSC server name
VARCHAR(8)
VARCHAR2(8)
Yes
Possible
Possible
NULL
9
SplitKey#4
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
- •CSCBP_<cluster name>_ACTIVITY table
-
The contents of CSCBP_<cluster name>_ACTIVITY table are as follows:
No.
Column name
Description
HiRDB type
ORACLE Type
Index
NULL
Update
Default value
1
ProcessID
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
2
ActivityNumber
Number to identify activity instance. Unique in process instance.
INTEGER#2
NUMBER(10) #3
No
Not possible
Not possible
Not possible
3
ActivityDefinitionName
Activity definition name
MVARCHAR(64)
VARCHAR2(64)
No
Not possible
Not possible
Not possible
4
ActivityKind
Activity type
VARCHAR(16)
VARCHAR2(16)
No
Not possible
Not possible
Not possible
5
ParentNumber#1
New activity instance identifier
INTEGER#2
NUMBER(10) #3
No
Not possible
Not possible
Not possible
6
ScopeNumber
Identification number of the associated scope instance
INTEGER#2
NUMBER(10) #3
No
Not possible
Not possible
Not possible
7
RepeatNumber#1
Identification number of the associated repeat process
INTEGER#2
NUMBER(10) #3
No
Not possible
Not possible
Not possible
8
State
Activity instance status
VARCHAR(20)
VARCHAR2(20)
No
Not possible
Possible
Not possible
9
FirstChildNumber#1
Smallest identification number of child activity instance
INTEGER#2
NUMBER(10) #3
No
Not possible
Possible
Not possible
10
LastChildNumber#1
Largest identification number of child activity instance
INTEGER#2
NUMBER(10) #3
No
Not possible
Possible
Not possible
11
StartTime
Activity instance start time (GMT)
TIMESTAMP(0)
TIMESTAMP(0)
No
Possible
Possible
NULL
12
EndTime
Activity instance end time (GMT)
TIMESTAMP(0)
TIMESTAMP(0)
No
Possible
Possible
NULL
13
WaitTime
Wait cancellation time of Activity (GMT)
TIMESTAMP(0)
TIMESTAMP(0)
No
Possible
Possible
NULL
14
SplitKey#4
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
- •CSCBP_<cluster name>_LINK table
-
The contents of CSCBP_<cluster name>_LINK table are as follows:
No.
Column name
Description
HiRDB type
ORACLE type
Index
NULL
Update
Default value
1
ProcessID
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
2
LinkDefinitionName
Link definition name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
3
RepeatNumber#1
Identification number of the associated repeat process
INTEGER#2
NUMBER(10) #3
Yes
Not possible
Not possible
Not possible
4
State
Link status (true or false)
CHAR(1)
CHAR(1)
No
Not possible
Not possible
Not possible
5
SplitKey#4
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
- •CSCBP_<cluster name>_CORRELATIONSET table
-
The contents of CSCBP_<cluster name>_CORRELATIONSET table are as follows:
No.
Column name
Description
HiRDB type
ORACLE type
Index
NULL
Update
Default value
1
ProcessID
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
2
ProcessDefinitionName
BP definition name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
3
ProcessDefinitionVersion
BP definition version
SMALLINT
NUMBER(5)
No
Not possible
Not possible
Not possible
4
ScopeDefinitionName
Scope definition name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
5
ScopeNumber
Scope instance identification number
INTEGER#1
NUMBER(10) #2
Yes
Not possible
Not possible
Not possible
6
CorrelationSetName
Correlation set definition name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
7
CorrelationSetValue
Correlation set value. Stringizing and linking of this value is done and then it is stored.
MVARCHAR(512)
VARCHAR2(512)
Yes
Not possible
Not possible
Not possible
8
State
Validity of correlation set (true or false)
CHAR(1)
CHAR(1)
No
Not possible
Possible
Not possible
9
SplitKey#3
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
(b) Variable information table
The variable information table stores the values of user-defined variables while business processes are being executed.
- •CSCBP_<cluster name>_STR_VARIABLE table
-
The contents of the CSCBP_<cluster name>_STR_VARIABLE table are as follows:
No.
Column name
Description
HiRDB type
ORACLE type
Index
NULL
Update
Default value
1
ProcessID
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
2
ScopeNumber
Scope instance identification number
INTEGER#1
NUMBER(10) #2
Yes
Not possible
Not possible
Not possible
3
VariableName
Variable definition name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
4
VariableValue
Variable value
MVARCHAR(4000)
VARCHAR2(4000)
No
Possible#3
Possible
Not possible
5
SplitKey#4
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
-
The contents of the CSCBP_<cluster name>_NUM_VARIABLE table are as follows:
No.
Column name
Description
HiRDB type
ORACLE type
Index
NULL
Update
Default value
1
ProcessID
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
2
ScopeNumber
Scope instance identification number
INTEGER#1
NUMBER(10) #2
Yes
Not possible
Not possible
Not possible
3
VariableName
Variable definition name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
4
VariableValue
Variable value
DOUBLE PRECISION
NUMBER
No
Not possible
Possible
Not possible
5
SplitKey#3
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
- •CSCBP_<cluster name>_BOOL_VARIABLE table
-
The contents of the CSCBP_<cluster name>_BOOL_VARIABLE table are as follows:
No.
Column name
Description
HiRDB type
ORACLE type
Index
NULL
Update
Default value
1
ProcessID
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
2
ScopeNumber
Scope instance identification number
INTEGER#1
NUMBER(10) #2
Yes
Not possible
Not possible
Not possible
3
VariableName
Variable definition name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
4
VariableValue
Variable value
CHAR(1)
CHAR(1)
No
Not possible
Possible
Not possible
5
SplitKey#3
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
- •CSCBP_<cluster name>_MSG_VARIABLE table
-
The contents of the CSCBP_<cluster name>_MSG_VARIABLE table are as follows:
No.
Column name
Description
HiRDB type
ORACLE type
Index
NULL
Update
Default value
1
ProcessID
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
2
ScopeNumber
Identification number of a scope instance
INTEGER#1
NUMBER(10) #2
Yes
Not possible
Not possible
Not possible
3
VariableName
Variable definition Name
MVARCHAR(64)
VARCHAR2(64)
Yes
Not possible
Not possible
Not possible
4
VariableValue
Variable Value
BINARY(2147483639)
BLOB
No
Possible#3
Possible
Not possible
5
SplitKey#4
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
(c) Message log related information table
The message log related information table stores the message log related data.
- •CSCBP_<cluster name>_MSG_RELATION table
-
The contents of the CSCBP_<cluster name>_MSG_RELATION table are as follows:
No.
Column name
Description
HiRDB type
ORACLE type
Index
NULL
Update
Default value
1
MessageID#1
Message common ID
VARCHAR(75)
VARCHAR2(75)
Yes
Not possible
Not possible
Not possible
2
ProcessID#1
Process instance identifier
MVARCHAR(240)
VARCHAR2(240)
Yes
Not possible
Not possible
Not possible
3
ActivityNumber#1
Identification number of an activity instance
INTEGER#2
NUMBER(10) #3
Yes
Not possible
Not possible
Not possible
4
SendOrReceive#1
Send/receive flag for the message
CHAR(1)
CHAR(1)
Yes
Not possible
Not possible
Not possible
5
AsynchronousMessagingID#1
Asynchronous messaging ID that uses Reliable Messaging
VARCHAR(255)
VARCHAR2(255)
Yes
Possible
Not possible
NULL
6
SplitKey#4
Split key (GMT)
CHAR(2)
CHAR(2)
Yes
Not possible
Not possible
Not possible
(2) Status information
This subsection describes the values that are stored in the table and the actual values (character strings).
(a) HCSC cluster name
Specify a name consisting of a maximum of 8 alphanumeric characters.
(b) Process instance identifier
This is an identifier used to uniquely identify each process instance.
(c) Process instance status
No. |
Name |
Description |
Value in database |
---|---|---|---|
1 |
Unexecuted |
The process instance is not executed and might be executed in the future. |
Unexecution |
2 |
Executing |
The process instance is executing. |
Executing |
3 |
Error |
An exception occurred in the invoke service activity or scope activity, and the process instance was interrupted with an error. |
Error |
4 |
Completed |
The global scope of the process is completed and the process instance is completed. |
Completed |
5 |
Terminated with fault |
A fault occurred and could not be detected by the global scope, resulting in termination of the process instance with a fault. |
Faulted |
6 |
Forced termination |
The process instance was forcibly terminated in the end activity. |
Terminated |
(d) Activity type
No. |
Name |
Description |
Value in database |
---|---|---|---|
1 |
receive |
Indicates a receive activity. |
RECEIVE |
2 |
reply |
Indicates a reply activity. |
REPLY |
3 |
invoke |
Indicates an invoke service activity. |
INVOKE |
4 |
assign |
Indicates an assign activity. |
ASSIGN |
5 |
scope |
Indicates a scope activity. |
SCOPE |
6 |
sequence |
Indicates activities to be executed in the defined order. |
SEQUENCE |
7 |
flow |
Indicates a flow activity. |
FLOW |
8 |
switch |
Indicates a switch activity. |
SWITCH |
9 |
while |
Indicates a while activity. |
WHILE |
10 |
java |
Indicates an invoke Java activity. |
JAVA |
11 |
wait |
Indicates a standby activity. |
WAIT |
12 |
empty |
Indicates an empty activity. |
EMPTY |
13 |
throw |
Indicates a throw activity. |
THROW |
14 |
validate |
Indicates a validation activity. |
VALIDATE |
(e) Activity instance status
No. |
Name |
Description |
Value in database |
---|---|---|---|
1 |
Unexecuted |
The activity instance is not executed and might be executed in the future. |
Unexecution |
2 |
Unomitted |
The activity instance is not executed and its execution might be omitted in the future. |
Unomission |
3 |
Executing |
The activity instance is executing. |
Executing |
4 |
Executing (Wait) |
Roll back is executed and the scope activity instance might be re-executed in future. |
Executingwait |
5 |
Waiting |
The receive activity instance is ready to receive. |
Awaiting |
6 |
Faulting |
The scope activity instance is executing an activity that was detected during fault processing. |
Faulting |
7 |
Error |
An exception (error) occurred in the invoke service activity or the scope activity, and the activity instance was interrupted with an error. |
Error |
8 |
Completed |
The activity instance was executed normally and then terminated. |
Completed |
9 |
Completed (Wait) |
The scope activity or reply activity instance was executed normally and might be re-executed in future. |
Completedwait |
10 |
Cancelled |
A fault occurred and execution of the activity instance was cancelled. |
Canceled |
11 |
Terminated with fault |
A fault occurred during execution of the activity instance, and the activity instance was terminated. |
Faulted |
12 |
Execution omitted |
Execution of the activity instance was omitted and terminated. |
Omitted |
(f) Link status
No. |
Name |
Description |
Value in database |
---|---|---|---|
1 |
True |
Indicates true active status. |
1 |
2 |
False |
Indicates false active status. |
0 |
(g) Correlation set status
No. |
Name |
Description |
Value in database |
---|---|---|---|
1 |
Valid |
Indicates valid status. |
1 |
2 |
Invalid |
Indicates invalid status. |
0 |
(h) Value of Boolean variable
No. |
Name |
Description |
Value in database |
---|---|---|---|
1 |
True |
Indicates true. |
1 |
2 |
False |
Indicates false. |
0 |
(i) Send/receive flag for the message
No. |
Name |
Description |
Value in database |
---|---|---|---|
1 |
receive reception |
Flag indicating that the message was received by a receive activity. |
R |
2 |
invoke transmission |
Flag indicating that the message was sent by an invoke service activity. |
O |
(j) Identification number of the dependent repetition process (RepeatNumber)
-
Sets the local activity instance identification number, when parent activity definition is a repetition process.
-
Sets the parent activity instance repetition process identification number, when parent activity definition is not a repetition process.
(k) Smallest and largest identification numbers of child activity instances (FirstChildNumber/LastChildNumber)
-
Default value indicates local activity instance identification number.
-
When child activity instances are created, sets the smallest or largest identification number for them.
(3) Index information
The following table describes the information of index to be given in respective tables:
-
Index for the CSCBP_<cluster name>_PROCESS table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_<cluster name>_PROCESS_IDX1
Yes
1
ProcessID
2
SplitKey#
2
CSCBP_<cluster name >_PROCESS_IDX2
No
1
ProcessDefinitionName
2
State
3
StartTime
3
CSCBP_<cluster name >_PROCESS_IDX3
No
1
ProcessDefinitionName
2
State
3
EndTime
4
CSCBP_<cluster name >_PROCESS_IDX4
No
1
CSCServerName
2
ProcessDefinitionName
3
State
-
Index for the CSCBP_<cluster name>_ACTIVITY table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_<cluster name>_ACTIVITY_IDX
Yes
1
ProcessID
2
ActivityNumber
3
SplitKey#
-
Index for the CSCBP_<cluster name>_LINK table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_< luster name >_LINK_IDX
Yes
1
ProcessID
2
LinkDefinitionName
3
RepeatNumber
4
SplitKey#
-
Index for the SCBP_<cluster name>_CORRELATIONSET table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_<cluster name >_CORREL_IDX1
Yes
1
ProcessID
2
ScopeNumber
3
CorrelationSetName
4
SplitKey#2
2
CSCBP_<cluster name >_CORREL_IDX2
Yes
1
ProcessDefinitionName
2
ScopeDefinitionName
3
CorrelationSetName
4
CorrelationSetValue
5
ProcessID#1
6
SplitKey#2
-
Index for the CSCBP_<cluster name>_STR_VARIABLE table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_<cluster name>_STR_VAR_IDX
Yes
1
ProcessID
2
ScopeNumber
3
VariableName
4
SplitKey#
-
Index for the CSCBP_<cluster name>_NUM_VARIABLE table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_<cluster name>_NUM_VAR_IDX
Yes
1
ProcessID
2
ScopeNumber
3
VariableName
4
SplitKey#
-
Index for the CSCBP_<cluster name>_BOOL_VARIABLE table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_<cluster name>_BOOL_VAR_IDX
Yes
1
ProcessID
2
ScopeNumber
3
VariableName
4
SplitKey#
-
Index for the CSCBP_<cluster name>_MSG_VARIABLE table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_<cluster name>_MSG_VAR_IDX
Yes
1
ProcessID
2
ScopeNumber
3
VariableName
4
SplitKey#
-
Index for the CSCBP_<cluster name>_MSG_RELATION table
No.
Index name
UNIQUE attribute
Order in index
Column name
1
CSCBP_<cluster name>_MSG_REL_IDX1
None
1
MessageID
2
CSCBP_<cluster name >_MSG_REL_IDX2
Yes
1
ProcessID
2
ActivityNumber
3
SendOrReceive
4
SplitKey#
3
CSCBP_<cluster name >_MSG_REL_IDX3
None
1
AsynchronousMessagingID
(4) View table information
The following table describes information of the View table:
-
CSCBP_<cluster name>_V_ACTIVITY view table
No.
Column name
Reference table
Reference column
1
ProcessID
ACTIVITY
ProcessID
2
ActivityNumber
ACTIVITY
ActivityNumber
3
ProcessDefinitionName
PROCESS
ProcessDefinitionName
4
ProcessDefinitionVersion
PROCESS
ProcessDefinitionVersion
5
ActivityDefinitionName
ACTIVITY
ActivityDefinitionName
6
ActivityKind
ACTIVITY
ActivityKind
7
ParentNumber#1
ACTIVITY
ParentNumber
8
ScopeNumber
ACTIVITY
ScopeNumber
9
RepeatNumber#1
ACTIVITY
RepeatNumber
10
State
ACTIVITY
State
11
FirstChildNumber#1
ACTIVITY
FirstChildNumber
12
LastChildNumber#1
ACTIVITY
LastChildNumber
13
StartTime
ACTIVITY
StartTime
14
EndTime
ACTIVITY
EndTime
15
WaitTime
ACTIVITY
WaitTime
16
CSCServerName
PROCESS
CSCServerName
17
SplitKey#2
PROCESS
SplitKey
-
CSCBP_<cluster name>_V_LINK view table
No.
Column name
Reference table
Reference column
1
ProcessID
LINK
ProcessID
2
ProcessDefinitionName
PROCESS
ProcessDefinitionName
3
ProcessDefinitionVersion
PROCESS
ProcessDefinitionVersion
4
LinkDefinitionName
LINK
LinkDefinitionName
5
RepeatNumber#1
LINK
RepeatNumber
6
State
LINK
State
7
SplitKey#2
PROCESS
SplitKey
-
CSCBP_<cluster name>_V_STR_VARIABLE view table
No.
Column name
Reference table
Reference column
1
ProcessID
STR_VARIABLE
ProcessID
2
ProcessDefinitionName
PROCESS
ProcessDefinitionName
3
ProcessDefinitionVersion
PROCESS
ProcessDefinitionVersion
4
ScopeDefinitionName
ACTIVITY
ActivityDefinitionName
5
ScopeNumber
STR_VARIABLE
ScopeNumber
6
VariableName
STR_VARIABLE
VariableName
7
VariableValue
STR_VARIABLE
VariableValue
8
SplitKey#
PROCESS
SplitKey
-
CSCBP_<cluster name>_V_NUM_VARIABLE view table
No.
Column name
Reference table
Reference column
1
ProcessID
NUM_VARIABLE
ProcessID
2
ProcessDefinitionName
PROCESS
ProcessDefinitionName
3
ProcessDefinitionVersion
PROCESS
ProcessDefinitionVersion
4
ScopeDefinitionName
ACTIVITY
ActivityDefinitionName
5
ScopeNumber
NUM_VARIABLE
ScopeNumber
6
VariableName
NUM_VARIABLE
VariableName
7
VariableValue
NUM_VARIABLE
VariableValue
8
SplitKey#
PROCESS
SplitKey
-
CSCBP_<cluster name>_V_BOOL_VARIABLE view table
No.
Column name
Reference table
Reference column
1
ProcessID
BOOL_VARIABLE
ProcessID
2
ProcessDefinitionName
PROCESS
ProcessDefinitionName
3
ProcessDefinitionVersion
PROCESS
ProcessDefinitionVersion
4
ScopeDefinitionName
ACTIVITY
ActivityDefinitionName
5
ScopeNumber
BOOL_VARIABLE
ScopeNumber
6
VariableName
BOOL_VARIABLE
VariableName
7
VariableValue
BOOL_VARIABLE
VariableValue
8
SplitKey#
PROCESS
SplitKey
-
CSCBP_<cluster name>_V_MSG_VARIABLE view table
No.
Column name
Reference table
Reference column
1
ProcessID
MSG_VARIABLE
ProcessID
2
ProcessDefinitionName
PROCESS
ProcessDefinitionName
3
ProcessDefinitionVersion
PROCESS
ProcessDefinitionVersion
4
ScopeDefinitionName
ACTIVITY
ActivityDefinitionName
5
ScopeNumber
MSG_VARIABLE
ScopeNumber
6
VariableName
MSG_VARIABLE
VariableName
7
VariableValue
MSG_VARIABLE
VariableValue
8
SplitKey#
PROCESS
SplitKey