Logging MsSQL - OperationExecutionLog

Question

Hi,

How do I extract and read the column of Operation Execution Log from our SQL database?

It seems to be a hexadecimal-encoded string that contains XML data?

Answer 1

Hello,

The Operation Execution Log column contains byte arrays. Each of them is a string in UTF-8 encoding. The string contains an XML representation of the execution log. Unfortunately, we do not have a script that extracts and formats the data.

Comments

Hi,

I was able to convert the data into XML format.

Can you tell me, which values are possible for hresult and type and what they mean?

Right now I see mostly hresult=0 and type=2.

Example of converted data

<?xml version="1.0" encoding="utf-8"?>
<executionLog p1:type="ExecutionLogEntryCollection" ver="1.0" xmlns:p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://softerra.com/adaxes">
    <entries>
        <entry id="3051b16e-73ee-4696-bdc1-d27a7cc941b1" hresult="0" type="2">
            <message>startDateString = 2016-02-22</message>
        </entry>
        <entry id="ccc515c5-87f7-4751-a9fe-5de8fa65fee3" hresult="0" type="2">
            <message>startDate = 02/22/2016 00:00:00</message>
        </entry>
        <entry id="4731adca-772a-4914-b2c6-0850f453034c" hresult="0" type="2">
            <message>check = 2/22/2016 12:00:00 AM</message>
        </entry>
        <entry id="92b70a47-0104-4883-8a0e-27c067830a02" hresult="0" type="2">
            <message>check2 = 2016-02-22</message>
        </entry>
    </entries>
</executionLog>

---

Hello,

Items you are looking at are execution log entries. Hresult is a coded numerical value representing the COM error code of the operation. For the list of possible values, see https://adaxes.com/sdk/ADM_OPERATIONRESULT_ENUM. Possible entry types are present in the following article: https://adaxes.com/sdk/MessageType.