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  <mailto:[email protected]>
[email protected]

 

web  <http://www.westoverconsulting.co.uk/>
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"_ 


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to