SAP B1 Task Executions Test

A task is a support or maintenance solution with the following characteristics:

  • Tasks are provided by SAP or SAP partners.

  • Tasks are run on a database or other entities of an SAP Business One environment by the agent of the remote support platform for SAP Business One.

  • Tasks return results in XML format. These results can be opened in a Web browser.

Tasks can be run automatically, based on a schedule, or can be executed manually. Tasks that do not contain schedule information can only be executed manually.

The remote support platform for SAP Business One includes the following types of tasks:

  • Health checks

  • System tasks

  • PowerShell

  • Database maintenance

  • Corrective tasks

  • Simple tasks

In a SAP Business One environment, the tasks of each task type are executed periodically to figure out inconsistencies that are noticed upon evaluating the status of the SAP Business One landscape, backup and restore of the databases, issues in remote administrative tasks etc. Sometimes, the execution of the tasks may fail frequently which may frustrate the administrators. Timely intervention of such execution failures is a necessity to ensure smooth functioning of the target SAP Business One. The SAP B1 Task Executions test aids administrators in this regard!

This test auto-discovers the task types that are executing on the target SAP Business One and for each task type, reports the total number of times the tasks were executed. This test also reveals the number of times the tasks of each task type were executed successfully and the number of times the tasks of each task type failed execution. Using this test, administrators can figure out the tasks of the task type that encountered frequent execution failures and trouble shoot such failures well before the users connecting to SAP Business One start complaining!

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 Task type 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

Successful tasks

Indicates the number of times the task of this type was executed successfully during the last measurement period.

Number

Compare the value of this measure across task types to figure out the task type that had the maximum number of successful task executions.

The detailed diagnosis of this measure lists the name of the task, description, version, category and Task GUID.

Rate of successful tasks

Indicates the rate at which the tasks of this type were executed successfully during the last measurement period.

Tasks/sec

A high value is desired for this measure.

Failed tasks

Indicates the number of times the task of this type failed execution during the last measurement period.

Number

Compare the value of this measure across task types to figure out the task type that encountered maximum number of failed executions.

The detailed diagnosis of this measure lists the name of the task, description, version, category and Task GUID.

Rate of failed tasks

Indicates the rate at which tasks of this type failed execution during the last measurement period.

Tasks/sec

A low value is desired for this mesaure.

Total tasks

Indicates the total number of times the task of this type was executed during the last measurement period.

Number

Is this successful+failed tasks - ask dev

Rate of total tasks

Indicates the total number of tasks of this type that were executed per second during the last measurement period.

Tasks/sec