Hello Dave, I checked the file and all I can see are selects, updates and inserts and OK and commit transaction statements. I greped for ERROR, ARERROR, FAIL, WARN and can't see any of these in my log file. Anything else to look for? Thanks frex
--- En date de : Mar 26.5.09, David Sanders <[email protected]> a écrit : De: David Sanders <[email protected]> Objet: Re: Fw : Log Analyser for ARS 7.1 À: [email protected] Date: Mardi 26 Mai 2009, 13h19 ** Hi Frex This is not a corruption of the log files – this is content from your log files. This is saying that your production remedy server logged SQL errors – you need to look at the content of these log lines to see what the offending errors were and what your server was trying to do. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== tel +44 1494 468980 mobile +44 7710 377761 email [email protected] web http://www.westoverconsulting.co.uk From: Action Request System discussion list(ARSList) [mailto: [email protected] ] On Behalf Of Frex Popo Sent: Tuesday, May 26, 2009 12:04 PM To: [email protected] Subject: Re : Fw : Log Analyser for ARS 7.1 ** Hello all, Has anyone using arwklga.exe, came across this error while analysing log files. I have tested logs generated by dev server and all seem to work fine, I get a decent report with all the stats. I try to do the same with log files from production and get the following errors! Was thinking the log file got corrupted while copying it across but this wasn't the case. Any ideas as what it could be? Kind Regards frex SQL EXCEPTION REPORT Line No. Command Message -------- --------- ------------------------------------------------------------ 94 /* WARNING: Unexpected SQL command 95 /* WARNING: Unexpected SQL command 267 /* WARNING: Unexpected SQL command 270 /* WARNING: Unexpected SQL command 276 /* WARNING: Unexpected SQL command 277 /* WARNING: Unexpected SQL command 278 /* WARNING: Unexpected SQL command 279 /* WARNING: Unexpected SQL command 280 /* WARNING: Unexpected SQL command 281 /* WARNING: Unexpected SQL command 282 /* WARNING: Unexpected SQL command 283 /* WARNING: Unexpected SQL command --- En date de : Lun 25.5.09, Frex Popo <[email protected]> a écrit : De: Frex Popo <[email protected]> Objet: Fw : Log Analyser for ARS 7.1 À: [email protected] Date: Lundi 25 Mai 2009, 13h15 somone kindly sent me the link :) Thanks --- En date de : Lun 25.5.09, Frex Popo <[email protected]> a écrit : De: Frex Popo <[email protected]> Objet: Log Analyser for ARS 7.1 À: [email protected] Date: Lundi 25 Mai 2009, 11h46 Dear all, I have some performance issues with our Remedy server (ARS 7.1) and as a starting point I have enabled the SQL/API logs. I need to analyse these, but doing it manually is quite time consuming. so... does anyone have a link to the arwklga.exe utility for download. I checked the Dev Community but could not find it. Many thanks in advance frex _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
