Dear All, we are suffering some strange issue where the chart and number is out of sync, anyone have idea why?
[cid:image001.png@01CCF864.75619810]
Thomas Lau
Technology Analyst
Principle One Limited
27/F Kinwick Centre, 32 Hollywood Road, Central, Hong Kong
T +852 3555 2217 F +852 3555 2222 M +852 9880 1217
Hong Kong . Singapore . Tokyo
Hi Thomas
I don’t have a clue about your problem, but I am pretty sure that the
first question will be : which version of RT are you using ?
GerardOn 2012-03-02 04:06, Thomas Lau wrote:
Dear All, we are suffering some strange issue where the chart and
number is out of sync, anyone have idea why?Thomas Lau
Technology Analyst
PrincipleOneLimited
27/F Kinwick Centre, 32 Hollywood Road, Central, Hong Kong
T +852 3555 2217 F +852 3555 2222 M +852 9880 1217Hong Kong . Singapore . Tokyo
RT 4.0.2
Thomas Lau
Technology Analyst
Principle One Limited
27/F Kinwick Centre, 32 Hollywood Road, Central, Hong Kong
T +852 3555 2217 F +852 3555 2222 M +852 9880 1217
Hong Kong . Singapore . TokyoFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Gerard FENELON
Sent: Friday, March 02, 2012 7:03 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] chart and number out of sync
Hi Thomas
I don’t have a clue about your problem, but I am pretty sure that the first question will be : which version of RT are you using ?
Gerard
Dear All, we are suffering some strange issue where the chart and number
is out of sync, anyone have idea why?
What’s the query you’re running when grouping by Owner Name in that chart?
Do you have $UseSQLForACLChecks turned on in your
/opt/rt4/etc/RT_SiteConfig.pm?
No, I don’t have that ACL line on config, should I use it?
BlackBerry solution provided by www.principleone.com----- Original Message -----
From: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Fri Mar 02 22:46:35 2012
Subject: Re: [rt-users] chart and number out of sync
On 03/01/2012 10:06 PM, Thomas Lau wrote:
Dear All, we are suffering some strange issue where the chart and number
is out of sync, anyone have idea why?
What’s the query you’re running when grouping by Owner Name in that chart?
Do you have $UseSQLForACLChecks turned on in your
/opt/rt4/etc/RT_SiteConfig.pm?
RT Training Sessions (http://bestpractical.com/services/training.html)
No, I don’t have that ACL line on config, should I use it?
Potentially. It’s just a guess; I didn’t dug into the charting code to
see if it would fix the root cause I’m betting on.
What’s the query you’re running when grouping by Owner Name in that chart?
Can you tell me this?
I have seen the complex and simple queue happen same problem as well, simple as create equal today
BlackBerry solution provided by www.principleone.comFrom: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Fri Mar 02 23:37:03 2012
Subject: Re: [rt-users] chart and number out of sync
No, I don’t have that ACL line on config, should I use it?
Potentially. It’s just a guess; I didn’t dug into the charting code to
see if it would fix the root cause I’m betting on.
What’s the query you’re running when grouping by Owner Name in that chart?
Can you tell me this?
RT Training Sessions (http://bestpractical.com/services/training.html)
I have seen the complex and simple queue happen same problem as well, simple as create equal today
Try this in your RT_SiteConfig.pm then:
Set($UseSQLForACLChecks, 1);
Mind to explain what does it do?
BlackBerry solution provided by www.principleone.com----- Original Message -----
From: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Sat Mar 03 00:00:02 2012
Subject: Re: [rt-users] chart and number out of sync
On 03/02/2012 10:49 AM, Thomas Lau wrote:
I have seen the complex and simple queue happen same problem as well, simple as create equal today
Try this in your RT_SiteConfig.pm then:
Set($UseSQLForACLChecks, 1);
RT Training Sessions (http://bestpractical.com/services/training.html)
Mind to explain what does it do?
All config options are documented in etc/RT_Config.pm. You copy lines
you want from there and add them to your RT_SiteConfig.pm
grep -A 10 UseSQLForACLChecks etc/RT_Config.pm
The second paragraph (“This option is relatively new…”) is slightly
dated. It’s not terribly new anymore and we generally recommend people
run with it on. It will be enabled by default in the next major RT version.