FX - Stack @ ESB - Enterprise Service Bus @ MentDB Weak
Stack
stackstack processstack statusstack resetstack process_limitstack count_waitstack count_runningstack count_closedstack count_errorstack 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 into the stack
To execute a script into 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 to execute the stack
Process to execute 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 lockers of the stack
Reset lockers of the stack
admin
stack reset;
mentdb
1
stack process_limit
Description
Show the stack config process limit.
Show the stack config process limit.
admin
stack process_limit;
mentdb
4
stack count_wait
Description
Count all waiting execution in the stack.
Count all waiting execution in the stack.
admin
stack count_wait;
mentdb
2
stack count_running
Description
Count all running execution in the stack.
Count all running execution in the stack.
admin
stack count_running;
mentdb
4
stack count_closed
Description
Count all closed execution in the stack.
Count all closed execution in the stack.
admin
stack count_closed;
mentdb
406
stack count_error
Description
Count all error execution in the stack.
Count all error execution in the stack.
admin
stack count_error;
mentdb
122
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 attempt (error).
Reset the number of attempt (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 attempt (error).
Reset the number of attempt (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 an execution process
To search 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 line by 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 line by 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"}