Hi Frederick This looks like a very nice tool. If I could get it to work....
When I load the logfile into the access table, I get a message of "No Current Record." And nothing was inserted into the SQL_Log. Does the import demand any specific dateformats or something like that?? // Niklas On 11/12/06, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:
** The format of the log file changed from ARS v5 to ARS v6 so the 5.1version will not work on a 6.3 file. I did an app in Access and it is available on Matt's site http://www.mattreinfeldt.com/site/component/option,com_docman/task,doc_download/gid,10/Itemid,28/ http://www.mattreinfeldt.com Downloads -> Utilities -> LogAnalysis.zip Fred ------------------------------ *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Niklas Asplund *Sent:* Monday, December 11, 2006 6:20 AM *To:* arslist@ARSLIST.ORG *Subject:* arlogtmr "Corruptted line" Hi I am trying to run the arlogtmr utility on a SQL Logfile. I'm running: arlogtmr.exe -i h:\ars\loggar\sql.log -d 5 The result I'm getting for each row is: ****** Corruptted line in log file ****** <SQL > <TID: 0000001008> <RPC ID: 0000375667> <Queue: Fast > <Client-RPC: 390620 > <USER: sda1 > /* mσ dec 11 2006 10:27:19.2550 */SELECT T506.C1,T506.C1 FROM T506 WHERE ('AG005056001A1AhDiIQgN_6LEwJQEA' = T506.C179) ORDER BY 1 ASC I'm running arlogtmr v5.1 against a logfile generated on a 6.3 ARserver. I know I've seen others with the same problem, but haven't seen any solution to it. Does anyone have a small SQL logfile that actually works with arlogtmr so I can compare a "Non corrupted" line with mine, so I can find the problem?? Or does anyone else have a free utility that finds long execution times?? Thanks for your help!! // Niklas Asplund Siemens Business Services Sweden __20060125_______________________This posting was submitted with HTML in it___