Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shane_spencer
Valued Contributor

Parsing or Processing Application logs

I've got these error log files, which are pretty aweful imo. Each time an error occurs a new entry is written to the log with a data stamp

Exception Time is 08:13:27.4162777

Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

<br><b>A connection-level error occurred while opening the connection.</b><br>Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

What I'm trying to do is to process these to perhaps get the time when a particular error occured i.e. Deadlock and count these occurances. Does anyone know if it would be possible to do this in QlikView?

I've been using 'Log Parser 2.2' to play around with this and I can search for a text string and get a count of how often in occurs but it's a bit limitted.

1 Solution

Accepted Solutions

Re: Parsing or Processing Application logs

This kind of log processing is possible with QV and a lot of fun. Attached is an example to get you started.

-Rob

3 Replies

Re: Parsing or Processing Application logs

This kind of log processing is possible with QV and a lot of fun. Attached is an example to get you started.

-Rob

shane_spencer
Valued Contributor

Re: Parsing or Processing Application logs

Thanx Rob! I wouldn't have begun to know where to start. :]

Highlighted
shane_spencer
Valued Contributor

Re: Parsing or Processing Application logs

I've now got a working solution that I've automated to reload the current months data everynight. I've identified different errors and modified the "wildmatch" command accordingly, and also filtered out the extra log text that I don't want. Thought I'd upload the result in case it's of help to anyone else.

Once again thanx!

Community Browser