3 Replies Latest reply: Aug 23, 2012 10:28 AM by Shane Spencer RSS

    Parsing or Processing Application logs

    Shane Spencer

      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.