B&R 11 SQLITE events.db3: differentiate error and warning
Hello,
I'm trying to read data from your events.db3 database and programmatically generate reports on backup jobs. I'm having trouble differentiating between errors and warnings and I can't find any documentation explaining what do code and severity columns represent. Also, I found that the message column holds some xml with the FullError tag that has some encrypted value such as
ATwANQHwlByK3CiHSkNvbW1hbmQgJ0JhY2tpbmcgdXAnIGhhcyBjb21wbGV0ZWQgd2l0aCB3YXJuaW5ncy4AJG1vZHVsZQBBc2VydmljZV9wcm9jZXNzX3ZzAAAyADUBY5WB+4ZeFo1UaGUgYWN0aXZpdHkgaGFzIGJlZW4gY2FuY2VsZWQuACRtb2R1bGUAQXNlcnZpY2VfcHJvY2Vzc192cwAAFgA1AeKVgfuGXhaNVE9MOiBGYWlsZWQgdG8gZXhlY3V0ZSB0aGUgY29tbWFuZC4gVGhlICdCYWNraW5nIHVwJyBjb21tYW5kIGJhY2tzIHVwIHRoZSBzcGVjaWZpZWQgZGF0YSB0byB0aGUgc3BlY2lmaWVkIGxvY2F0aW9uLgBUcmFjZUxldmVsAE4BAAAAAAAAACRtb2R1bGUAQWd0b2JfYmFja3VwX2NvbW1hbmRfYWRkb25fdnMAABUAoQCVKhxROe7Dn0Nhbm5vdCBmaW5kIGxvY2F0aW9uLgAkbW9kdWxlAEFkaXNrX2J1bmRsZV92cwAAAwCPAD/Li4Ign6cJVGhlIHJ1bm5pbmcgdGFzayBoYXMgYmVlbiBjYW5jZWxlZC4ASXNSZXR1cm5Db2RlAE4BAAAAAAAAACRtb2R1bGUAQWRpc2tfYnVuZGxlX3ZzAAA=
This value is different with errors and warnings and I think it could prove helpful if I could make sense of it.
I would appreciate any help to understand the best way to determine if a job ended in error, warning or success.
Best regards,
Darko Majkic
Hello elenal,
thank you for your response. I tried what you suggested but "acrocmd list plans" command lists backup jobs that have warning state in B&R GUI, with the error status. This is not consistent. I would like to programmatically retrieve statuses for backup jobs that correspond to statuses in the B&R GUI.
Unfortunately I don't use the advanced edition, so i don't have MSSQL database to use, only SQLITE like i mentioned in the first post. If you could provide me with documentation that explains the meaning of different "severity" and "code" columns values that would be most helpful. Alternatively, it would also be helpful to understand what do the values in the "message" column mean under the FULLERROR XML tag.
Hello Darko Majkic
We've checked the latest ABR11.5 build (37608) and found that statuses are displayed consistently in GUI and command line (see the attached screenshot). As regards to events.db3, our developers do not advise to rely on its structure as it may be changed without notification. In addition, disclosure of this information has to be officially approved. If you strongly need it, please create a support case.
Hello elenal,
I'm using ABR11 and "acrocmd list plans" command does not show warning statuses (see the attached screenshot).
Thank you for your help and I'll see about creating a support case to resolve my issue.
