Re: [rt-users] chart and number out of sync
On 03/02/2012 11:54 AM, Thomas Lau wrote: > 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. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] chart and number out of sync
Mind to explain what does it do? -- BlackBerry solution provided by www.principleone.com - Original Message - From: rt-users-boun...@lists.bestpractical.com To: 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) * Boston March 5 & 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
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) * Boston March 5 & 6, 2012
Re: [rt-users] chart and number out of sync
I have seen the complex and simple queue happen same problem as well, simple as create equal today -- BlackBerry solution provided by www.principleone.com - Original Message - From: rt-users-boun...@lists.bestpractical.com To: rt-users@lists.bestpractical.com Sent: Fri Mar 02 23:37:03 2012 Subject: Re: [rt-users] chart and number out of sync On 03/02/2012 10:31 AM, Thomas Lau wrote: > 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) * Boston March 5 & 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] chart and number out of sync
On 03/02/2012 10:31 AM, Thomas Lau wrote: > 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) * Boston March 5 & 6, 2012
Re: [rt-users] chart and number out of sync
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-boun...@lists.bestpractical.com To: 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) * Boston March 5 & 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
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) * Boston March 5 & 6, 2012
Re: [rt-users] chart and number out of sync
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 M +852 9880 1217 Hong Kong . Singapore . Tokyo From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@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 On 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? [cid:image001.png@01CCF8A7.3FD62F10] Thomas Lau Technology Analyst Principle One Limited 27/F Kinwick Centre, 32 Hollywood Road, Central, Hong Kong T +852 3555 2217 F +852 3555 M +852 9880 1217 Hong Kong . Singapore . Tokyo <> RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
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 On 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 Principle One Limited 27/F Kinwick Centre, 32 Hollywood Road, Central, Hong Kong T +852 3555 2217 F +852 3555 M +852 9880 1217 Hong Kong . Singapore . Tokyo RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] chart and number out of sync
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 M +852 9880 1217 Hong Kong . Singapore . Tokyo <> RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012