The AdminWFEventLogs table

Applies to version 2019.1; author: Dawid Golonka

Introduction

While working on WEBCON BPS Portal, you can see the error messages displayed by the system in the upper right corner – they are displayed when the system encounters a problem and the execution of any action fails. From version 2020.1.3.277 there is the ability of previewing error logs from the administration tools panel. But there is also the option to access to error logs from the level of the AdminWFEventLogs table in the configuration database (for users use the older versions).

Description

The most important columns from the AdminWFEventLogs table are:

• WEL_ID – the error ID
• WEL_CreatedBy – information on which user the error occurred
• WEL_Source – a source from which the error message comes from (which component); it is a reference to the DicLogSources table from the content database. For the individual IDs the following table values are returned:

• 1 – BpsStudio
• 2 – BpsSharePointSolution
• 3 – BPSService
• 4 – BPSCloudPortal

• WEL_Category – the category message ID from the log. To read the category name, use the DicLogCategories table from the content database (there are 39 message categories)
• WEL_Name – the message name
• WEL_Details – the message content
• WEL_DateAndTime – date and time when the error occurs
• WEL_ErrorGuid – the message GUID

For more information see Downloading error content from WEBCON BPS Designer Studio.

As the presentation workflow has already been configured in the above-mentioned article and an error has been "generated", in this article we will use the same example.

By querying to the table and narrowing it down to the message with GUID =  5dae0f48-5d70-4dd3-b5b3-f134f28c2342 (as in the above article), you get access to the same data:

Fig. 1. The result from the query

Below there is a window that contains more information about this GUID:

Fig. 2. Information about the error

Summary

The administration tool from Designer Studio allows you to search for information about the error. This information is downloaded from the database and displays data from the WEL_Name and WEL_Details columns of the AdminWEEventLogs table.