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.
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.