SAP B1 Workflow Instances Test

Workflow in SAP Business One enables users to define, customize and execute workflows for key business processes, providing greater process flow transparency, standardization and control across Business One. The workflow service enables you to standardize your business operations to increase overall efficiency. With predefined conditions, the system automatically executes various tasks, liberating labor resources for more creative activities. Workflow instances contain multiple tasks and participants. To complete an instance, the participants should process their tasks correctly and in an ordered manner. The tracking function provides the participants with access to the process status for the whole instance, so that they can pick up and process their own tasks on time.

When the Workflow instances are error-prone or are cancelled frequently in the target environment, then, SAP administrators may find it hard to figure out how many times the Workflow instances were cancelled and turned out to be erroneous. To aid administrators identify how frequently the worflow instances were identified to be erroneous and were cancelled, eG Enterprise offers the SAP B1 Workflow Instances test.

This test auto-discovers the Workflow instances created on the target SAP Business One and for each workflow instance, reports the number of times each workflow instance was completed and cancelled. This test also reports the number of times the execution of workflow instances was in progress and the instances that encountered errors during execution. This test also reports the rate at which the workflow instances completed execution, the rate at which workflow instnaces encountered errors and were cancelled. Using this test, administrators are pin-pointed to the exact workflow instance that was erroneous and was cancelled more frequently.

Target of the test : A SAP Business One

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for each Workflow Instance executing on the target SAP Business One being monitored.

Configurable parameters for the test
Parameter	Description
Test Period	How often should the test be executed
Host	The host for which the test is to be configured.
Port	Enter the port to which the specified host listens.
Database Type	By default, SAP Business One runs either on SAP HANA or Microsoft SQL Database server i.e., the backend database of SAP Business One is either SAP HANA or Microsoft SQL Database server. If the target SAP Business One runs on SAP HANA, choose HANA from the Database Type list. By default, MsSQL option will be chosen from this list indicating that the target SAP Business One runs on Microsoft SQL Database server.
Database Host	Specify the IP address of the host on which the database (i.e., the SAP HANA or Microsoft SQL Database server) of the target SAP Business One is installed.
Database Port	Specify the port at which the specified Database Host listens to. The default Database Port is 1433, if the target Business One runs on Microsoft SQL Database server and 30015, if the target Business One runs on SAP HANA.
Database User	If the target SAP Business One runs on Microsoft SQL Server 2005 or above, provide the name of a SQL user with all of the privileges outlined in User Privileges Required for Monitoring Microsoft SQL server in this text box. If the target SAP Business One runs on SAP HANA database server, then, a special database user account with Monitoring privileges has to be created on the SAP HANA database server of the target SAP Business One that requires monitoring. The syntax of the script that is used for user creation is discussed in Pre-requisites for Monitoring the SAP HANA Database Server. Specify the name of this user against the Database User parameter.
Password	Here, specify the password of the specified Database User.
Confirm Password	Confirm the password by retyping it here.
Database Name	To collect metrics from the logs of the target SAP Business One, the eG agent should connect to the SAP Business One database and other common databases such as RSP, B1if, SBO-COMMON etc. For this, you need to specify the name of the SAP Business One database corresponding to the target SAP Business One being monitored against the Database Name parameter. To know how to figure out the database name, refer to How to Find the Name of the SAP Business One Database?
Instance	This is set to default by default. This implies that the eG agent automatically discovers the instance name at run time.
Domain	This parameter is applicable only if MsSQL option is chosen from the Database Type list. By default, none is displayed in the DOMAIN text box. If the ‘SQL server and Windows’ authentication has been enabled for the server being monitored, then the DOMAIN can continue to be none. On the other hand, if ‘Windows only’ authentication has been enabled, then, in the DOMAIN text box, specify the Windows domain in which the managed Microsoft SQL server exists. Also, in such a case, the USER name and PASSWORD that you provide should be that of a user authorized to access the Microsoft SQL database server of the target SAP Business One.
DD Frequency	Refers to the frequency with which detailed diagnosis measures are to be generated for this test. The default is 1:1. This indicates that, by default, detailed measures will be generated every time this test runs, and also every time the test detects a problem. You can modify this frequency, if you so desire. Also, if you intend to disable the detailed diagnosis capability for this test, you can do so by specifying none against DD frequency.
Detailed Diagnosis	To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option. The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled: The eG manager license should allow the detailed diagnosis capability Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
In-progress instances	Indicates the number of times this workflow instance is currently in- progress.	Number	Compare the value of this measure across workflow instances to figure out the workflow instance that is currently busy. The detailed diagnosis of this measure lists the version, creator, start time, end time, duration in minutes, whether/not the workflow instance was auto started and start type.
Cancelling instances	Indicates the number of times this workflow instance is currently in Cancelling state.	Number	The detailed diagnosis of this measure lists the version, creator, start time, end time, duration in minutes, whether/not the workflow instance was auto started and start type.
Cancelled instances	Indicates the number of times this workflow instance was cancelled during the last measurement period.	Number	The detailed diagnosis of this measure lists the version, creator, start time, end time, duration in minutes, whether/not the workflow instance was auto started and start type.
Cancelled instance rate	Indicates the rate at which this workflow instance was cancelled during the last measurement period.	Instance/sec
Error instances	Indicates the number of times this workflow instance encountered errors while execution during the last measurement period.	Number	Ideally, the value of this measure should be zero. Compare the value of this measure across workflow instances to figure out the workflow instances that encountered maximum errors. The detailed diagnosis of this measure lists the version, creator, start time, end time, duration in minutes, whether/not the workflow instance was auto started and start type.
Error instance rate	Indicates the rate at which this workflow instance encountered errors while execution during the last measurement period.	Instance/sec
Completed instances	Indicates the number of times this workflow instance completed execution during the last measurement period.	Number	This meaure is a good indicator of load on the workflow instance. Compare the value of this measure across workflow instances to figure out the workflow instance that is overloaded. The detailed diagnosis of this measure lists the version, creator, start time, end time, duration in minutes, whether/not the workflow instance was auto started and start type.
Completed instance rate	Indicates the rate at which this workflow instance completed execution during the last measurement period.	Instance/sec