Share:

PREVIOUS  |  NEXT

Script Execution Log


Workflow provides statistics on the use of scripts in your tenant. When you open the Script Statistics page, we display a list of all scripts that you can use for troubleshooting, enabling you to identify:

  • Scripts that frequently fail

  • Scripts that process the slowest

  • Scripts that call other scripts

  • Scripts that time out

  • How long external database queries last

  • How many different entities have been created during the script execution

Both Script Statistics and the System Log enable you to see what isn't working as expected.


To access script statistics, go to:

  • Setup > Development > Logs > Script Execution Log, or

  • Admin Tools > Case Information, and then click the Script Execution Logs link, or

  • The Case Tools menu on a case action panel and select the Case Script Statistics link.


Note: Workflow only displays the Case Information menu item in the Admin Tools menu when the case is open.


Workflow displays the Script Statistics workspace:


We enable you to view additional parameter details in the log. Click the Show More/Less link to display more or less details.

Workflow displays the usage statistics for each executed script, with these parameters details:

Parameter

Displays

SCRIPT_SYSTEM_ID

System ID of the script

CASE_ID

ID of the case that the script was executed with

PID

Process ID: This is a unique id for the process thread.Clicking the id displays a map of all parent and child processes that executed with the script.

The id is generated in this format, with the time in milliseconds: system id:execution time  

PARENT_PID

Parent process ID: When a script calls another script, the other scripts are considered child processes. This parameter displays the parent process id of this child process. Clicking the id displays a map of all parent and child processes that executed with the script.

The id is generated in this format, with the time in milliseconds: system id:execution time 

VALIDATION

Defines whether the process initiated a script validation. We display thesymbol if the script validated, or asymbol if the script was not validated and it was initiated by a user's activity or scheduled task. 

EXECUTION_TIME

Amount of time it took to execute the script.

EXECUTED_AT

Start time that the script was executed

FINISHED_AT

End time that the script finished executing

TIMED_OUT

Defines whether the script timed out during execution. We display thesymbol if the script timed out, and thesymbol if the script didn't time out

SCRIPT_TYPE

Script type.

NUMBER_OF_INSTRUCTIONS

Number of instructions in the script. Workflow limits the maximum number of instructions that a script can execute. Please contact SAP Sales Cloud Support if you are reaching the maximum with the script execution. 

ROOT_PID

Root process ID of the script.

METHOD_INVOCATIONS

Methods that were invoked when the script was executed.

CREATED_CASES

Number of cases that were created when the script was completed.

LOADED_CASES

Number of cases loaded when the script was executed.

CREATED_USERS

Number of users that were created when the script was completed.

LOADED_USERS

Number of users loaded when the script was executed.

CT_QUERY_EXECUTION_TIME

Amount of time it took to execute the custom table query.

EXT_QUERY_EXECUTION_TIME

Custom table queries that were executed when the script was run.

FTP_EXECUTION_TIME

Amount of time it took to execute the FTP call.

CUSTOM_TABLES_QUERIES

Number of custom table queries that were generated when the script was executed.

FTP_METHODS

FTP methods that were invoked when the script was executed.

LOG_OUTPUT

Log output that was generated when the script was executed.

SERVER

Server that was called during the script execution.



You can get the statistics on a specific script by providing a WHERE condition in the search box, such as: script_system_id = 'my_script'. Workflow will update the results with all logs where the system ID of the script matches the script name.


Note: When you validate the script using the Validate button, Workflow does not execute the script. For example, we do not create users or update tables per the script.