SAP B1 Events Test

When data is added, changed, or deleted in SAP Business One company databases, SAP Business One creates events in the SEVT table of the SBO-COMMON database. The events contain the company identifier, the object ID and information whether data is new, changed, or deleted. The event sender regularly picks up events, forwards them to the integration framework and deletes them from the SEVT table.

Events are notifications that the integration framework is interested in. Active scenario steps with the SAP Business One inbound channel subscribe to events. SAP Business One inbound retrieves the data matching the event from the company database. For data retrieval, the framework uses the interface that is defined in the inbound channel, either the DI API, the service layer or JDBC. Then, the framework processes the message based on definitions in the scenario step.

Events can have the following status:

Success - The integration framework can process the information.
Filtered - There is no scenario step subscribed to the incoming event.
Failure - Scenario steps that subscribe to the event are not active. You can edit and resend such events.

If the events are completed / forwarded to the integration framework with the Success status, then, message processing will be performed at a faster pace. If too many events are forwarded with the Failure / Filtered status, then, message processing will be delayed leading to unexpected slowdowns in the target SAP Business One. To proactively detect the count of those events with the Filtered and Failure status and prevent slowdowns, eG Enterprise offers the SAP B1 Events test.

This test reports the count of events that were completed with Success, Filtered and Failure status. This test also reveals the rate at which events were completed with Success, Filtered and Failure status. Using this test, administrators can periodically monitor a sudden surge in the count of events that failed, analyze the reason behind such failure events and proactively prevent such failures.

Target of the test : A SAP Business One

Agent deploying the test : An internal agent

Outputs of the test : One set of results for 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 events	Indicates the number of events completed with Success status during the last measurement period.	Number
Failed Events	Indicates the number of events completed with Failure status during the last measurement period.	Number	Ideally, the value of this measure should be 0. A sudden/gradual increase in the value of this measure is a cause of concern and requires further investigation. The detailed diagnosis of this measure reports the UserID, Source DB, Timestamp, Object type, Trans type, Field names and Field value generated for the failed events.
Failed event rate	Indicates the rate at which events were retrieved with Failure status during the last measurement period.	Events/sec
Filtered events	Indicates the number of events completed with Filtered status during the last measurement period.	Number	By default, most of the events that are triggered on the target SAP Business One may not be useful in a large SAP environment and hence handling all of them would degrade the performance of the environment. Filtering unnecessary events saves a lot of processing time and ensures that the required events alone are handled and the rest are ignored.
Filtered event rate	Indicates the rate at which events were completed with Filtered status during the last measurement period.	Events/sec
Total events	Indicates the total number of events completed during the last measurement period.	Number
Total event rate	Indicates the rate at which events were completed during the last measurement period.	Events/sec