Centralized Administration of the Logging Database and Logging Configuration

You can manage the logging database and the configuration of the Process Monitor centrally in dedicated technical workflows.

Centralized Administration of Logging Database

The Technical workflow BPC_PM_LogDB_Administration in the BPC_Monitor_hook diagram group creates the initial table structure of the logging database, and it can be used to generate test data. In addition, when changes are made to the table structure (refer to Centralized Administration of XML Logging Configuration), the database table can be deleted, emptied or re-created. Furthermore, the workflow BPC_PM_LogDB_Administration is used for creating and deleting the necessary data archiving tables.

Creating Database Tables

Database tables must be created prior to logging any data as well as after changes to the column definition in the XML configuration.

Proceed as follows

Display the technical workflow BPC_PM_LogDB_Administration in the BPC_Monitor_hook diagram group.
Select the BPC_PM_startWFHere Empty module in the top left create log table frame.
Open the context menu and click Set start point. A green start point appears.
Select the start point, open the context menu, and click Start test without file.

→ The workflow starts and creates the database tables and views.

Emptying Database Tables

You can delete old data from the database.

Proceed as follows

Display the technical workflow BPC_PM_LogDB_Administration in the BPC_Monitor_hook diagram group.
Select the BPC_PM_startWFHere Empty module in the clear log table frame.
Open the context menu and click Set start point. A green start point appears.
Select the start point, open the context menu, and click Start test without file.

→ The workflow starts and empties the database tables.

Deleting Database Tables

If you have changed the XML configuration and thus the column definition of the logging database, you must delete the existing database table before you can accept the changes by creating a new database table.

Proceed as follows

Display the technical workflow BPC_PM_LogDB_Administration in the BPC_Monitor_hook diagram group.
Select the BPC_PM_startWFHere Empty module in the delete log table frame.
Open the context menu and click Set start point. A green start point appears.
Select the start point, open the context menu, and click Start test without file.

→ The workflow starts and deletes the database tables.

Creating Test Data

To demonstrate the data logging process, you can generate example database entries.

Proceed as follows

Display the technical workflow BPC_PM_LogDB_Administration in the BPC_Monitor_hook diagram group.
Select the BPC_PM_startWFHere Empty module in the create test data frame.
Open the context menu and click Set start point. A green start point appears.
Select the start point, open the context menu, and click Start test without file.

→ The workflow starts and creates the test data.

Configuring Grid initially

Proceed as follows

Open the technical workflow BPC_299_PM_Configuration in the BPC__configuration diagram group for editing.
Open the variable mapping of the BPC_Assign_hook module.
Select the XSLT Source variable.
In the Source section, click the Edit button next to the Style sheet label to open the XSLT editor.
Adjust the following Grid elements if needed: title, id, prefix

Adjusting the Assignment of Column Types to Data/Database Types

For all supported database types (e.g. Oracle, MySQL), the BPC_PM_Create_LogDB_Tables_FromInitLoad module contains a definition of which column types (e.g. serial, boolean, reffile) are converted into which data types (e.g.SERIAL, CHAR(1), or LONGBLOB) for each database type. You can change the assignment.

Proceed as follows

Display the Designer > Server tab in the Workbench.
In the diagram tree, navigate to the technical workflow BPC_PM_LogDB_Administration.
Open the XSLT Converter BPC_PM_Create_LogDB_Tables_FromInitLoad for editing.
In the XSLT stylesheet, search for dbColTypes.

The values of this variable define which data types are used for the individual column types on a database-specific basis.
In the section for your database, change the data types for the individual column types as desired.
Save your changes and publish the module.
To adopt these changes to the logging database, execute the following workflows.
1. In the BPC_PM_LogDB_Administration workflow, start the BPC_PM_startWFHere module in the d`elete log` tables frame.
2. In the BPC_PM_LogDB_Administration workflow, start the BPC_PM_startWFHere module in the c`reate log` tables frame.

Refer to

Deleting Database Tables
Creating Database Tables

Centralized Administration of XML Logging Configuration

With the BPC_Assign_hook module in the BPC_299_PM_Configuration workflow, you can configure the entire Process Monitor as well as the type and display of log entries.

The entire configuration for the logged data is stored as an XML structure in the variables mapping. Here you can adjust the XML elements to increase the quantity of logged data through additional columns and change settings for display of logged data in the Process Monitor of the BPC Portal.

Proceed as follows

Open the technical workflow BPC_299_PM_Configuration for editing.
Open the variables mapping of the BPC_Assign_hook module.
Select the XSLT Source variable.
In the Source section, click the Edit button next to the Style sheet label to open the XSLT editor.
Perform the desired changes in the XML structure of xsl:template in the XML target area.

Refer to XML Elements for Functional Logging
Close the variable mapping by clicking OK.
Publish the workflow.