Re: how to get "full" SQL logs?

[laurent matheo]

**

Hi :)

Thanks a lot, both of you :)

Yep indeed it's a query from overview console on hpd:help desk.

Laurent ;)

On 21 Feb, 2013,at 06:25 AM, vaibhav wadekar <wadekar.vaib...@gmail.com> wrote:

** Yes it's looks like non admin user performing some operation as it looking for groups to which user belong to. If it is admin user, you might see short version of SQL. 

To get complete SQL statement, you can set the parameter Rahul suggested in ar.cfg

Regards/Vaibhav

On Wednesday, February 20, 2013, laurent matheo wrote:

**

Hi List ^_^

I have a little question, when I log "SQL" with ARS it happens that some very long SQL queries (like nearly 4k) are "truncated" and finish by "...", for example (I just post the begin and the end of it):

///////////////

SELECT COUNT(*) FROM T2120 WHERE ((((T2120.C230000009 = 'ACTIVITY') AND (T2120.C1000000427 = 'SGP000000000211') AND (T2120.C7 >= 20) AND (T2120.C7 <= 40)) OR ((T2120.C230000009 = 'MAINCHANGE') AND ((T2120.C1000000427 = 'SGP000000000211') OR (T2120.C1000000079 = 'SGP000000000211') OR (T2120.C1000000079 = 'SGP000000000211'))

(...)

 OR (T2120.C60900 LIKE '%;20031;%') OR (T2120.C60900 LIKE '%;1000000007;%') OR (T2120.C60900 LIKE '%;1000000107;%') OR (T2120.C60900 LIKE '%;20000;%') OR (T2120.C60900 L...

///////////////

Is there a way to get / log the full SQL query? I mean, apart asking the DBA since when we have those logs it's too late to ask them for it.

Best regards.

Laurent.

_ARSlist: "Where the Answers Are" and have been for 20 years_

--
Sent from Gmail Mobile
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_