Stack
stackstack processstack statusstack resetstack process_limitstack count_waitstack count_runningstack count_closedstack count_errorstack flow_initstack flow_stepstack flow_json_getstack flow_json_setstack var_showstack delete_wait_idstack delete_wait_scriptstack delete_closed_idstack delete_closed_scriptstack delete_error_idstack delete_error_scriptstack reset_error_nbattempt_idstack reset_error_nbattempt_scriptstack replay_error_idstack replay_error_scriptstack getstack search
stack <exeDate> <scriptName> <varName1> <varlue1> <varNameN> <varlueN>
Description
To execute a script through the stack
To execute a script through the stack
Parameters
exeDate: The execution date - string - required
scriptName: The script name - string - required
varName1: The variable name 1 - string - not required
varlue1: The value 1 - string - not required
varNameN: The variable name N - string - not required
varlueN: The value N - string - not required
exeDate: The execution date - string - required
scriptName: The script name - string - required
varName1: The variable name 1 - string - not required
varlue1: The value 1 - string - not required
varNameN: The variable name N - string - not required
varlueN: The value N - string - not required
admin
stack (date now) "division.post" "[v1]" 10 "[v2]" 5;
mentdb
2a
stack process
Description
Process the stack
Process the stack
admin
stack process;
mentdb
1
stack status
Description
Get the status of the stack
Get the status of the stack
admin
stack status;
mentdb
STACK STATUS PROCESS_LIMIT=10 lock=false lock_count=false STACK SCRIPT STACK PID
stack reset
Description
Reset the locks of the stack
Reset the locks of the stack
admin
stack reset;
mentdb
1
stack process_limit
Description
Show the process limit of the stack.
Show the process limit of the stack.
admin
stack process_limit;
mentdb
4
stack count_wait
Description
Count all waiting executions in the stack.
Count all waiting executions in the stack.
admin
stack count_wait;
mentdb
2
stack count_running
Description
Count all running executions in the stack.
Count all running executions in the stack.
admin
stack count_running;
mentdb
4
stack count_closed
Description
Count all closed executions in the stack.
Count all closed executions in the stack.
admin
stack count_closed;
mentdb
406
stack count_error
Description
Count all executions in error in the stack.
Count all executions in error in the stack.
admin
stack count_error;
mentdb
122
stack flow_init <pid> <nameFlow> <json>
Description
Initialize the name of a flow process
Initialize the name of a flow process
Parameters
pid: The pid of the flow - string - required
nameFlow: The name of the flow - string - required
json: The JSON object to save - string - required
pid: The pid of the flow - string - required
nameFlow: The name of the flow - string - required
json: The JSON object to save - string - required
admin
stack flow_init [PID] "name_of_the_flow" "{}";
mentdb
1
stack flow_step <pid> <position> <posName>
Description
Mark a new step for the specified flow
Mark a new step for the specified flow
Parameters
pid: The pid of the flow - string - required
position: The step position - number - required
posName: The position name - string - required
pid: The pid of the flow - string - required
position: The step position - number - required
posName: The position name - string - required
admin
stack flow_step [PID] 1 "Begin_of_the_flow";
mentdb
1
stack flow_json_get <pid>
Description
Put a key/value pair into a specified flow (stack process)
Put a key/value pair into a specified flow (stack process)
Parameters
pid: The pid of the flow - string - required
pid: The pid of the flow - string - required
admin
json load "flow_json" (stack flow_json_get [PID]);
mentdb
1
stack flow_json_set <pid> <json>
Description
Put a key/value pair into a specified flow (stack process)
Put a key/value pair into a specified flow (stack process)
Parameters
pid: The pid of the flow - string - required
json: The JSON object to save - string - required
pid: The pid of the flow - string - required
json: The JSON object to save - string - required
admin
stack flow_json_set [PID] (json doc "flow_json");
mentdb
1
stack var_show <pid>
Description
Get variables for a specific process
Get variables for a specific process
Parameters
pid: The pid of the process - string - required
pid: The pid of the process - string - required
admin
stack var_show 1;
mentdb
[]
stack delete_wait_id <pid>
Description
Delete a specific execution (wait).
Delete a specific execution (wait).
Parameters
pid: The process id - number - required
pid: The process id - number - required
admin
stack delete_wait_id 4;
mentdb
1
stack delete_wait_script <scriptName>
Description
Delete all executions for a specific script (wait).
Delete all executions for a specific script (wait).
Parameters
scriptName: The script name - string - required
scriptName: The script name - string - required
admin
stack delete_wait_script "division.post";
mentdb
25
stack delete_closed_id <pid>
Description
Delete a specific execution (closed).
Delete a specific execution (closed).
Parameters
pid: The process id - number - required
pid: The process id - number - required
admin
stack delete_closed_id 4;
mentdb
1
stack delete_closed_script <scriptName>
Description
Delete all executions for a specific script (closed).
Delete all executions for a specific script (closed).
Parameters
scriptName: The script name - string - required
scriptName: The script name - string - required
admin
stack delete_closed_script "division.post";
mentdb
25
stack delete_error_id <pid>
Description
Delete a specific execution (error).
Delete a specific execution (error).
Parameters
pid: The process id - number - required
pid: The process id - number - required
admin
stack delete_error_id 4;
mentdb
1
stack delete_error_script <scriptName>
Description
Delete all executions for a specific script (error).
Delete all executions for a specific script (error).
Parameters
scriptName: The script name - string - required
scriptName: The script name - string - required
admin
stack delete_error_script "division.post";
mentdb
10
stack reset_error_nbattempt_id <pid>
Description
Reset the number of attempts (error).
Reset the number of attempts (error).
Parameters
pid: The process id - number - required
pid: The process id - number - required
admin
stack reset_error_nbattempt_id 4;
mentdb
1
stack reset_error_nbattempt_script <scriptName>
Description
Reset the number of attempts (error).
Reset the number of attempts (error).
Parameters
scriptName: The script name - string - required
scriptName: The script name - string - required
admin
stack reset_error_nbattempt_script "division.post";
mentdb
1
stack replay_error_id <pid>
Description
Replay a specific execution (error).
Replay a specific execution (error).
Parameters
pid: The process id - number - required
pid: The process id - number - required
admin
stack replay_error_id 4;
mentdb
1
stack replay_error_script <scriptName>
Description
Replay all executions for a specific script (error).
Replay all executions for a specific script (error).
Parameters
scriptName: The script name - string - required
scriptName: The script name - string - required
admin
stack replay_error_script "division.post";
mentdb
7
stack get <pid>
Description
To show a specific execution (with variables).
To show a specific execution (with variables).
Parameters
pid: The process id - number - required
pid: The process id - number - required
admin
stack get 4;
mentdb
{ "lastattempt": "2018-01-04 10:39:17.0", "dtcreate": "2018-01-04 10:32:07.0", "nbattempt": "1", "dtclosed": null, "dtexe": "2018-01-04 10:32:07.0", "pid": "17", "login": "admin", "script": "addition.post", "dterror": "2018-01-04 10:39:17.0", "nbmaxattempt": "1", "lasterrormsg": "\nline 1 \u003e\u003e\u003e addition.post [v1] 12 [v2] 19 \nline 2 \u003e\u003e\u003e exception 1; \"\\\"your message ...\\\";\" ; 1: your message ..." }
stack search <tableType> <script> <dtType> <dtMin> <dtMax> <dtOrder> <page> <nbByPage>
Description
To search for an execution process
To search for an execution process
Parameters
tableType: The table type (wait|running|closed|error) - string - required
script: The script (can be null) - string - required
dtType: The date type (exe|closed|error|create|lastattempt) - string - required
dtMin: The min date - string - required
dtMax: The max date - string - required
dtOrder: The order (ASC|DESC) - string - required
page: The page - number - required
nbByPage: The number of lines per page - number - required
tableType: The table type (wait|running|closed|error) - string - required
script: The script (can be null) - string - required
dtType: The date type (exe|closed|error|create|lastattempt) - string - required
dtMin: The min date - string - required
dtMax: The max date - string - required
dtOrder: The order (ASC|DESC) - string - required
page: The page - number - required
nbByPage: The number of lines per page - number - required
admin
stack search "error" null "exe" (date datedifft (concat (date sysdate) " 00:00:00") "DAY" 10) (concat (date sysdate) " 23:59:59") ASC 1 5;
mentdb
{"column_types":["STRING","STRING","STRING","STRING","LONG","LONG","STRING","STRING","STRING","STRING","STRING"],"data":[],"columns":["pid","script","dtcreate","lastattempt","nbattempt","nbmaxattempt","dtexe","login","lasterrormsg","dtclosed","dterror"],"title":"stack"}