Re: [rt-users] AssetTracker Custom Field Select Date problem

[Gary McRae]

Thanks Don.
Problem solved with your help.

Kind regards,
Gary

On 29/05/2013, at 10:32 AM, Don Gourley  wrote:

> Gary,
> 
> There is also a google group called at-users that has been very
> helpful for us, but right now I can't get into it to point you to the
> solution. Did they kill google groups as I had heard threatened?
> 
> But we had the same problem and I nice guy named Rolf provided a
> solution. AFAIK he is the most active supporter of the AssetTracker
> module. He has his own fork on github but there was some talk on
> at-us...@googlegroups.com of folding his fixes into the main branch.
> 
> Anyway, here is the fix he provided:
> 
>> Rolf Grossmann Tue, Apr 2, 2013 at 2:29 PM
>> Reply-To: at-us...@googlegroups.com
>> To: at-us...@googlegroups.com
>> Hi Stewart,
>> 
>> On 29.03.2013 16:20, studo...@gmail.com wrote:
>> 
>>> We created an Asset Tracker custom field for a calendar showing an
>>> inventory date. When we create a date entry it works fine. But if we
>>> modify the asset, the date field gets cleared and the date is gone. We
>>> need to re-enter the original date (which is a pain) or we have to
>>> change the field to a standard text field. Changing to a standard field
>>> will cause problems with human error and searching.
>>> 
>>> Is there a way to ensure the date field doesn't get cleared?
>> 
>> I've found the cause (code duplicated from rt) and fixed this problem in
>> my fork of asset tracker. See
>> https://github.com/rg1/rt-extension-assettracker/commit/1b2cb79c43e8d21ea8b3fad18b25987c6391ac16
>> 
>> A proper fix should probably remove all that duplicated code entirely :/
>> 
>> Best regards, Rolf.
> ______
> 
>> Date: Tue, 28 May 2013 05:56:45 +
>> From: "Brumm, Torsten / Kuehne + Nagel / Ham GI-ID"
>>
>> To: "gar...@bitek.com.au" ,
>>"rt-users@lists.bestpractical.com" 
>> Subject: Re: [rt-users] AssetTracker Custom Field Select Date problem
>> Message-ID:
>><524815224ea2f649982d6a7bcd53bdfe2158f...@dceexmbx04.ger.win.int.kn>
>> Content-Type: text/plain; charset="us-ascii"
>> 
>> Hi Gary,
>> for issues with AT you should consult : 
>> https://github.com/chakatodd/rt-extension-assettracker and open an issue 
>> there.
>> 
>> Torsten
>> 
>> Von: rt-users-boun...@lists.bestpractical.com 
>> [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Gary McRae
>> Gesendet: Montag, 27. Mai 2013 01:35
>> An: rt-users@lists.bestpractical.com
>> Betreff: [rt-users] AssetTracker Custom Field Select Date problem
>> 
>> I am having a problem with a custom field using a 'Select Date' type. 
>> Creation is no problem nor is entering data.
>> If you open an asset and select 'Fields'  then all the values previously 
>> entered are correctly reloaded from the db.
>> The Date field though is empty and it shows the value in brackets beside the 
>> date field.
>> If you then update any other field ie. 'Change Comment' and then 'Save 
>> Changes' the value of the date field is removed as below.
>> Results
>>2013-05-27 is no longer a value for custom field Purchase Date
>> 
>> This can easily remove data from the database.
>> Can someone confirm this please?
>> 
>> K?hne + Nagel (AG & Co.) KG, Gesch?ftsleitung: Hans-Georg Brinkmann (Vors.), 
>> Dirk Blesius, Reiner Heiken, Holger Ketz (Stellv.), Jan-Hendrik K?stergarten 
>> (Stellv.), Bruno Mang, Christian Marnett?, Jens Wollesen, Sitz: Bremen, 
>> Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Pers?nlich 
>> haftende Gesellschaft: K?hne & Nagel A.G., Sitz: Contern/Luxemburg 
>> Gesch?ftsf?hrender Verwaltungsrat: Karl Gernandt
> 
> 
> -- 
> RT Training in Seattle, June 19-20: http://bestpractical.com/training



-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] AssetTracker Custom Field Select Date problem

[Don Gourley]

Gary,

There is also a google group called at-users that has been very
helpful for us, but right now I can't get into it to point you to the
solution. Did they kill google groups as I had heard threatened?

But we had the same problem and I nice guy named Rolf provided a
solution. AFAIK he is the most active supporter of the AssetTracker
module. He has his own fork on github but there was some talk on
at-us...@googlegroups.com of folding his fixes into the main branch.

Anyway, here is the fix he provided:

> Rolf Grossmann Tue, Apr 2, 2013 at 2:29 PM
> Reply-To: at-us...@googlegroups.com
> To: at-us...@googlegroups.com
> Hi Stewart,
>
> On 29.03.2013 16:20, studo...@gmail.com wrote:
>
> > We created an Asset Tracker custom field for a calendar showing an
> > inventory date. When we create a date entry it works fine. But if we
> > modify the asset, the date field gets cleared and the date is gone. We
> > need to re-enter the original date (which is a pain) or we have to
> > change the field to a standard text field. Changing to a standard field
> > will cause problems with human error and searching.
> >
> > Is there a way to ensure the date field doesn't get cleared?
>
> I've found the cause (code duplicated from rt) and fixed this problem in
> my fork of asset tracker. See
> https://github.com/rg1/rt-extension-assettracker/commit/1b2cb79c43e8d21ea8b3fad18b25987c6391ac16
>
> A proper fix should probably remove all that duplicated code entirely :/
>
> Best regards, Rolf.
__

> Date: Tue, 28 May 2013 05:56:45 +
> From: "Brumm, Torsten / Kuehne + Nagel / Ham GI-ID"
> 
> To: "gar...@bitek.com.au" ,
> "rt-users@lists.bestpractical.com" 
> Subject: Re: [rt-users] AssetTracker Custom Field Select Date problem
> Message-ID:
> <524815224ea2f649982d6a7bcd53bdfe2158f...@dceexmbx04.ger.win.int.kn>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Gary,
> for issues with AT you should consult : 
> https://github.com/chakatodd/rt-extension-assettracker and open an issue 
> there.
>
> Torsten
>
> Von: rt-users-boun...@lists.bestpractical.com 
> [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Gary McRae
> Gesendet: Montag, 27. Mai 2013 01:35
> An: rt-users@lists.bestpractical.com
> Betreff: [rt-users] AssetTracker Custom Field Select Date problem
>
> I am having a problem with a custom field using a 'Select Date' type. 
> Creation is no problem nor is entering data.
> If you open an asset and select 'Fields'  then all the values previously 
> entered are correctly reloaded from the db.
> The Date field though is empty and it shows the value in brackets beside the 
> date field.
> If you then update any other field ie. 'Change Comment' and then 'Save 
> Changes' the value of the date field is removed as below.
> Results
> 2013-05-27 is no longer a value for custom field Purchase Date
>
> This can easily remove data from the database.
> Can someone confirm this please?
>
> K?hne + Nagel (AG & Co.) KG, Gesch?ftsleitung: Hans-Georg Brinkmann (Vors.), 
> Dirk Blesius, Reiner Heiken, Holger Ketz (Stellv.), Jan-Hendrik K?stergarten 
> (Stellv.), Bruno Mang, Christian Marnett?, Jens Wollesen, Sitz: Bremen, 
> Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Pers?nlich 
> haftende Gesellschaft: K?hne & Nagel A.G., Sitz: Contern/Luxemburg 
> Gesch?ftsf?hrender Verwaltungsrat: Karl Gernandt


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] AssetTracker Custom Field Select Date problem

[Brumm, Torsten / Kuehne + Nagel / Ham GI-ID]

Hi Gary,
for issues with AT you should consult : 
https://github.com/chakatodd/rt-extension-assettracker and open an issue there.

Torsten

Von: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Gary McRae
Gesendet: Montag, 27. Mai 2013 01:35
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] AssetTracker Custom Field Select Date problem

I am having a problem with a custom field using a 'Select Date' type. Creation 
is no problem nor is entering data.
If you open an asset and select 'Fields'  then all the values previously 
entered are correctly reloaded from the db.
The Date field though is empty and it shows the value in brackets beside the 
date field.
If you then update any other field ie. 'Change Comment' and then 'Save Changes' 
the value of the date field is removed as below.
Results
2013-05-27 is no longer a value for custom field Purchase Date

This can easily remove data from the database.
Can someone confirm this please?

K?hne + Nagel (AG & Co.) KG, Gesch?ftsleitung: Hans-Georg Brinkmann (Vors.), 
Dirk Blesius, Reiner Heiken, Holger Ketz (Stellv.), Jan-Hendrik K?stergarten 
(Stellv.), Bruno Mang, Christian Marnett?, Jens Wollesen, Sitz: Bremen, 
Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Pers?nlich 
haftende Gesellschaft: K?hne & Nagel A.G., Sitz: Contern/Luxemburg 
Gesch?ftsf?hrender Verwaltungsrat: Karl Gernandt


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

[rt-users] AssetTracker Custom Field Select Date problem

[Gary McRae]

I am having a problem with a custom field using a 'Select Date' type.
Creation is no problem nor is entering data.

If you open an asset and select 'Fields'  then all the values previously
entered are correctly reloaded from the db.

The Date field though is empty and it shows the value in brackets beside the
date field.

If you then update any other field ie. 'Change Comment' and then 'Save
Changes' the value of the date field is removed as below.

Results

2013-05-27 is no longer a value for custom field Purchase Date

 

This can easily remove data from the database. 

Can someone confirm this please?



-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] AssetTracker and RT4.0.2 and css

[Darin Perusich]

Joop,

> No go in the logs but by accident I found it. I added the aileron
> folder
> maybe in the wrong place or you'll need to add it twice.
> Atleast it is needed here:
> /usr/local/share/request-tracker4/plugins/RTx-
> AssetTracker/html/Callbacks/AssetTracker/NoAuth/css/aileron
> Create the aileron folder and copy the files from the web2 folder to
> it.
> That consists of a folder Main.css and a file End contained in it.
That
> file includes webat.css.
> 
> Hope this will help some other people as well and I hope Todd will
> include it in the next release.
> 


You should open an issue at
https://github.com/chakatodd/rt-extension-assettracker/issues

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.


RT Training Sessions (http://bestpractical.com/services/training.html)
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Barcelona, Spain  November 28 & 29, 2011

Re: [rt-users] AssetTracker and RT4.0.2 and css

[Joop]

Joop wrote:

Hi Todd,

I have installed the debian package of RT-4.0.2 and I'm currently 
installing all extensions that I had in test, source install.
I have run into a small display problem. When displaying an asset it 
looks like it is not including the associated css. The headers of the 
AssetMetadata are not coloured.
That is possible since my theme is aileron and there is no folder 
named like that in AssetTracker/NoAuth. Made that folder and copied 
the web2 files into it. No go. If I switching to web2 then I'll get 
the coloured headers.
It looks like something is not correctly including the correct css 
files. Looking at in Firebug I can't see much since all css files are 
squished. Is it possible to disable this so that I can see what is 
being included and what not.
I'll see if I can figure it out by looking at the apache logs. RT.log 
doesn't give a clue (debug enabled)


No go in the logs but by accident I found it. I added the aileron folder 
maybe in the wrong place or you'll need to add it twice.

Atleast it is needed here:
/usr/local/share/request-tracker4/plugins/RTx-AssetTracker/html/Callbacks/AssetTracker/NoAuth/css/aileron
Create the aileron folder and copy the files from the web2 folder to it. 
That consists of a folder Main.css and a file End contained in it. That 
file includes webat.css.


Hope this will help some other people as well and I hope Todd will 
include it in the next release.


Regards,

Joop


RT Training Sessions (http://bestpractical.com/services/training.html)
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Barcelona, Spain  November 28 & 29, 2011

[rt-users] AssetTracker and RT4.0.2 and css

[Joop]

Hi Todd,

I have installed the debian package of RT-4.0.2 and I'm currently 
installing all extensions that I had in test, source install.
I have run into a small display problem. When displaying an asset it 
looks like it is not including the associated css. The headers of the 
AssetMetadata are not coloured.
That is possible since my theme is aileron and there is no folder named 
like that in AssetTracker/NoAuth. Made that folder and copied the web2 
files into it. No go. If I switching to web2 then I'll get the coloured 
headers.
It looks like something is not correctly including the correct css 
files. Looking at in Firebug I can't see much since all css files are 
squished. Is it possible to disable this so that I can see what is being 
included and what not.
I'll see if I can figure it out by looking at the apache logs. RT.log 
doesn't give a clue (debug enabled)


Regards,

Joop


RT Training Sessions (http://bestpractical.com/services/training.html)
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Barcelona, Spain  November 28 & 29, 2011

Re: [rt-users] AssetTracker.

[Torsten Brumm]

Hi Mark,
you should wait, Todd is working on a new release, working fine under 3.8.x

Torsten

2010/8/17 Mark Jenks 

>  I am running RT-3.8.8 and AT-1.2.4b1 and am having some problems.
>
>
>
> First off, not everyone can create assets.  Some people get “Asset could
> not be created due to an internal error”.  What can I look at?
>
>
>
> Also, I installed the AT-Shedder, but it doesn’t seem to be working with
> the RTx shredder.
>
>
>
> Am I missing something?
>
>
>
> 
>
> Mark Jenks
>
> Network Administrator
>
> *iod incorporated*
>
> mark.je...@iodincorporated.com
>
> 920-406-3702
>
>
>  CONFIDENTIALITY NOTICE: The information contained in this email message,
> including any attachments, may be privileged, confidential and otherwise
> protected from disclosure. If the reader of this message is not the intended
> recipient, you are hereby notified that any use, dissemination, distribution
> or copying of this message, including any attachments, is strictly
> prohibited. If you have received this email message in error, please notify
> the sender by reply email and delete/destroy the email message, including
> attachments, and any copies thereof. Although we have taken precautions to
> minimize the risk of transmitting viruses via email and attachments thereto,
> we do not guarantee that either is virus-free, and we accept no liability
> for any damages sustained as a result of any such viruses.
>
>
> RT Training in Washington DC, USA on Oct 25 & 26 2010
> Last one this year -- Learn how to get the most out of RT!
>



-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de

RT Training in Washington DC, USA on Oct 25 & 26 2010
Last one this year -- Learn how to get the most out of RT!

[rt-users] AssetTracker.

[Mark Jenks]

I am running RT-3.8.8 and AT-1.2.4b1 and am having some problems.

 

First off, not everyone can create assets.  Some people get "Asset could
not be created due to an internal error".  What can I look at?

 

Also, I installed the AT-Shedder, but it doesn't seem to be working with
the RTx shredder.

 

Am I missing something?

 



Mark Jenks

Network Administrator

iod incorporated

mark.je...@iodincorporated.com  

920-406-3702

 


CONFIDENTIALITY NOTICE:  The information contained in this email message, 
including any attachments, may be 
privileged, confidential and otherwise protected from disclosure.  If the 
reader of this message is not the 
intended recipient, you are hereby notified that any use, dissemination, 
distribution or copying of this 
message, including any attachments, is strictly prohibited.  If you have 
received this email message in 
error, please notify the sender by reply email and delete/destroy the email 
message, including attachments, 
and any copies thereof.  Although we have taken precautions to minimize the 
risk of transmitting viruses via 
email and attachments thereto, we do not guarantee that either is virus-free, 
and we accept no liability for 
any damages sustained as a result of any such viruses.

RT Training in Washington DC, USA on Oct 25 & 26 2010
Last one this year -- Learn how to get the most out of RT!

Re: [rt-users] AssetTracker 1.2.4

[Torsten Brumm]

OK, fixed this today:

Added to Type_Overlay.pm for AT the following:

$RIGHTS = {
SeeType=> 'Can this principal see this asset type',   #
loc_pair
...
...
ShowAssetComments   => 'See asset comments',#
loc_pair
...
...

};

Error is away now.
Torsten


2010/1/14 Brumm, Torsten / Kuehne + Nagel / Ham MI-ID <
torsten.br...@kuehne-nagel.com>

> Hi Together,
> just play around with Upgrading RT 3.6.5 to 3.8.7, upgrade is smooth so
> far, but AT seems to make problems:
>
> 1. On Config->AT->Admin->Types i get:
>
> Can't locate object method "ACLEquivalenceObjects" via package
> "RTx::AssetTracker::System" at /opt/rt3/bin/../lib/RT/Principal_Overlay.pm
> line 327.
>
> 2. If i open a asset, i get at the log:
>
> Invalid right. Couldn't canonicalize right 'ShowAssetComments'
> (/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:299), referer:
> http://rt38-messenger.int.kn/AssetTracker/Asset/Display.html?id=1
>
> Any ideas how to fix?
>
> Torsten
>
> Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann
> (Vors.), Dirk Blesius, Reiner Heiken, Bruno Mang, Alfred Manke, Christian
> Marnetté, Mark Reinhardt, Jens Wollesen, Rainer Wunn, Sitz: Bremen,
> Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich
> haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg
> Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne
>
>
>
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sa...@bestpractical.com
>
> 2010 RT Training Sessions!
> San Francisco, CA, USA - Feb 22 & 23
> Dublin, Ireland - Mar 15 & 16
> Boston, MA, USA - April 5 & 6
> Washington DC, USA - Oct 25 & 26
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker 1.2.4b1 and RT-Billing

[Torsten Brumm]

Hi,
just dropped a mail to the owner of the page for RT Billing, let's see what
happens.

Btw. AT 1.2.4 runs smoothe under RT 3.8.x

Torsten

2010/2/24 Christian Cuvelier 

>  Hi there,
>
>
>
> i just need some information.
>
> I´ve searched for a Billing Module for RT and found RT-Billing at
>
> http://mattwork.potsdam.edu/projects/wiki/index.php/RT-Billing but there i
> can´t find any Link to a Download.
>
>
>
> On this site there´s a hint to AssetTracker and I tried to test it, maybe
> RT-Billing is included ?!
>
>
>
> I found AT-1.2.3.zip to download. After a little bit searching I´ve read
> that it is only for RT version
> 3.6 and not 3.8.
>
> Okay I need Version 1.2.4b1, but i can´t find it. Tried to check it out
> from googlecode via svn, but the link there is broken.
>
> Maybe you have an answer for me where I can download these Extensions ??
>
> Thanks a lot
>
> Christian
>
>
>
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sa...@bestpractical.com
>
> 2010 RT Training Sessions!
> San Francisco, CA, USA - Feb 22 & 23
> Dublin, Ireland - Mar 15 & 16
> Boston, MA, USA - April 5 & 6
> Washington DC, USA - Oct 25 & 26
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker 1.2.4b1 and RT-Billing

[Brenner, Martin]

Hi Christian,

I don't know anything about RT-Billing, but I was able to get Asset Tracker
up and running on a new RT installation that I did a few months ago. The
link in the documentation is incorrect with respect to how to check-out the
svn. This is the command you have to use:

svn checkout http://asset-tracker-4rt.googlecode.com/svn/at/tags/1.2.4b1

Don't forget, you may have to install svn and you may have to use sudo
depending on how you are logged in.

As far as I can tell, there is no billing involved with the Asset Tracker
plug-in.

Hope this helps,
Martin

On Wed, Feb 24, 2010 at 3:28 PM, Christian Cuvelier <
christian.cuvel...@attmes.com> wrote:

>  Hi there,
>
>
>
> i just need some information.
>
> I´ve searched for a Billing Module for RT and found RT-Billing at
>
> http://mattwork.potsdam.edu/projects/wiki/index.php/RT-Billing but there i
> can´t find any Link to a Download.
>
>
>
> On this site there´s a hint to AssetTracker and I tried to test it, maybe
> RT-Billing is included ?!
>
>
>
> I found AT-1.2.3.zip to download. After a little bit searching I´ve read
> that it is only for RT version
> 3.6 and not 3.8.
>
> Okay I need Version 1.2.4b1, but i can´t find it. Tried to check it out
> from googlecode via svn, but the link there is broken.
>
> Maybe you have an answer for me where I can download these Extensions ??
>
> Thanks a lot
>
> Christian
>
>
>
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sa...@bestpractical.com
>
> 2010 RT Training Sessions!
> San Francisco, CA, USA - Feb 22 & 23
> Dublin, Ireland - Mar 15 & 16
> Boston, MA, USA - April 5 & 6
> Washington DC, USA - Oct 25 & 26
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] AssetTracker 1.2.4b1 and RT-Billing

[Christian Cuvelier]

Hi there,
 
i just need some information.
I´ve searched for a Billing Module for RT and found RT-Billing at
http://mattwork.potsdam.edu/projects/wiki/index.php/RT-Billing but there i can´t
find any Link to a Download.
 
On this site there´s a hint to AssetTracker and I tried to test it, maybe
RT-Billing is included ?!
 
I found AT-1.2.3.zip to download. After a little bit searching I´ve read that it
is only for RT version
3.6 and not 3.8.

Okay I need Version 1.2.4b1, but i can´t find it. Tried to check it out from
googlecode via svn, but the link there is broken.

Maybe you have an answer for me where I can download these Extensions ??

Thanks a lot

Christian___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] AssetTracker 1.2.4

[Brumm, Torsten / Kuehne + Nagel / Ham MI-ID]

Hi Together,
just play around with Upgrading RT 3.6.5 to 3.8.7, upgrade is smooth so far, 
but AT seems to make problems:

1. On Config->AT->Admin->Types i get:

Can't locate object method "ACLEquivalenceObjects" via package 
"RTx::AssetTracker::System" at /opt/rt3/bin/../lib/RT/Principal_Overlay.pm line 
327. 

2. If i open a asset, i get at the log:

Invalid right. Couldn't canonicalize right 'ShowAssetComments' 
(/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:299), referer: 
http://rt38-messenger.int.kn/AssetTracker/Asset/Display.html?id=1

Any ideas how to fix?

Torsten

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), 
Dirk Blesius, Reiner Heiken, Bruno Mang, Alfred Manke, Christian Marnetté, Mark 
Reinhardt, Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, 
HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & 
Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: 
Klaus-Michael Kuehne



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker 1.2.4: displayed Asset Statuses in "quicksearch"

[Brumm, Torsten / Kuehne + Nagel / Ham MI-ID]

Hi Peter,
have a look into AT_SiteConfig.pm there you can define new status like you do 
it inside RT! 


Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), 
Dirk Blesius, Reiner Heiken, Bruno Mang, Alfred Manke, Christian Marnetté, Mark 
Reinhardt, Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, 
HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & 
Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: 
Klaus-Michael Kuehne



-Urspruengliche Nachricht-
Von: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Peter C. Lai
Gesendet: Montag, 11. Januar 2010 21:55
An: t...@chaka.net
Cc: rt-users@lists.bestpractical.com
Betreff: [rt-users] AssetTracker 1.2.4: displayed Asset Statuses in 
"quicksearch"

How would I do the following under RT 3.8.x and AT 1.2.4?

Add another Asset Status? Do I just modify Type_Overlay.pm?

Do I get this new Asset Status to show up as a status column and count under 
the Quick Search screen?

Thanks.
--
===
Peter C. Lai | Bard College at Simon's Rock
Systems Administrator| 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428
===

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support: 
sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] AssetTracker 1.2.4: displayed Asset Statuses in "quick search"

[Peter C. Lai]

How would I do the following under RT 3.8.x and AT 1.2.4?

Add another Asset Status? Do I just modify Type_Overlay.pm?

Do I get this new Asset Status to show up as a status column and count
under the Quick Search screen?

Thanks.
-- 
===
Peter C. Lai | Bard College at Simon's Rock
Systems Administrator| 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428
===

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Assettracker error message: Can't locate object method "new" via package "RTx::AssetTracker::Types"...

[who else]

Update:

Strange things happen: By reloading the browser the "Assets"-Option in the
Menu might be there or dissappear. AT also creates new error messages like
this:

Creation of new Asset Type (i was able to create 5 or 6 of them before being
presented with this)

Can't locate object method "new" via package "RTx::AssetTracker::Type"
(perhaps you forgot to load "RTx::AssetTracker::Type"?) at
/opt/rt3/share/html/AssetTracker/Admin/Types/Modify.html line 87. 

Just entered a custom field for Asset Tracker, which has been saved, while i
wanted to create another one, the "Asset" Entry vanished. RT then looks like
AT wouldnt be there at all, no config options whatsoever.

Am wondering, whether it will find the entries i made before again, if it
will reappear.

Ok, came back, entered another custom field, this worked out, after creating
another one, "Assets" vanished again.

Someone experiencing this behaviour as well?

Thanks for help

w_e

-- 
View this message in context: 
http://www.nabble.com/Asset-tracking%2C-multiple-Contacts-in-same-company%2C-Custom-fields%2C-RTFM-and-more-tp22273450p22286923.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Assettracker error message: Can't locate object method "new" via package "RTx::AssetTracker::Types"...

[who else]

Hi Kevin,

got the following error with 1.2.4b1 (RT 3.8.2, RTFM 2.4.2):

Can't locate object method "new" via package "RTx::AssetTracker::Types"
(perhaps you forgot to load "RTx::AssetTracker::Types"?) at
/opt/rt3/share/html/AssetTracker/Admin/Types/index.html line 70. 

Haven't found anything with google, on the googlecode site or in this
list...

Can you point me in the right direction, please?

Best

w_e


Kevin Phair wrote:
> 
> who else wrote:
>> 
>> Sounds like a plan :-) Which version of RTx-AssetTracker are you using? I
>> can only find 1.2.3, not 1.2.4b1; anybody got a download link?
> 
> You can grab it out of their subversion repo, something like:
> 
> svn checkout http://asset-tracker-4rt.googlecode.com/svn/at/tags/1.2.4b1 
> at-1.2.4b1
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sa...@bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Asset-tracking%2C-multiple-Contacts-in-same-company%2C-Custom-fields%2C-RTFM-and-more-tp22273450p22285004.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker crashes loading asset...raw horsepower solution?

[John]

9,359

On Tue, 11 Nov 2008, Todd Chapman wrote:
> Date: Tue, 11 Nov 2008 13:04:14 -0500
> From: Todd Chapman <[EMAIL PROTECTED]>
> To: John <[EMAIL PROTECTED]>
> Cc: Curtis Bruneau <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] AssetTracker crashes loading asset...raw horsepower
> solution?
> 
> How many assets do you have? Nobody has ever seen this issue before
>
> On Tue, Nov 11, 2008 at 12:57 PM, John <[EMAIL PROTECTED]> wrote:
>
>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>>
>> I think i may have found a bit of a solution to the AT problem.  we're
>> running on 2 quad-core servers as frontends with 8gb memory each.  the
>> fault im seeing in AT is due to a timeout in apache waiting for its
>> backend processes to respond from huge queries...so:
>>
>>   
>> AddHandler fcgid-script .fcgi
>>
>> OutputBufferSize 128
>> IdleTimeout 600
>>   ProcessLifeTime 3600
>>   MaxProcessCount 8
>>   DefaultMinClassProcessCount 3
>>   DefaultMaxClassProcessCount 3
>>
>>   
>> IPCConnectTimeout 20
>> IPCCommTimeout 600
>>
>> has resolved the AT issue from what im seeing.  queries still take a long
>> time, but thats just because RT is pulling lots of other data from mysql
>> that im not certain is even pertanent to the asset/ticket at hand.  could
>> the speed of the query be increased by changing maxprocesscount to a
>> higher value?
>>
>> im running into issues now with the population of a user rights page that
>> includes 300-400 users...namely:
>>
>> RT::Group::Privileged Unimplemented in HTML::Mason::Commands.
>> (/opt/rt3/share/html/Elements/ShowUserConcise line 52)
>>
>> any ideas?
>>
>>
>>
>>> Date: Fri, 07 Nov 2008 12:52:04 -0500
>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>>
>>> The queries would execute fine, the problem at least in my case is it
>> tries
>>> to load the whole result set into memory causing oom-killer to go on
>> rampage.
>>> Apache will peak out, to sort of help this situation I added a mem limit
>> to
>>> the fastcgi handler which will basically die before things get really
>> ugly.
>>> I'm able to see this query in the log, it has no limit clause so it
>> really is
>>> getting everything. While doing a form of debug/trace on the
>> apache/handler
>>> I'm also able to see it trying to load the full row times search results
>>> (table.*) into memory. This is all on a ticket display from a large
>> search
>>> result. So unless you are loading it in memory as opposed to say a shell
>>> client output you won't run into memory problems.
>>>
>>> Best of luck with your situation, I have not been able to get any
>>> confirmation until now with you. I've produced somewhat detailed bug
>> report
>>> but it appears to be somewhat isolated.. people with low tickets will
>> never
>>> run into this problem.
>>>
>>> Curtis
>>>
>>> John wrote:
>>>> curtis:
>>>> ive played around re-executing the mysql queries related to the RT
>> crash,
>>>> and to no avail.  they execute just fine.
>>>>
>>>> could this perhaps be a syslog issue like in RT?  is there a seperate
>>>> control for syslogging in AT?
>>>>
>>>>
>>>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>>>>
>>>>> Date: Fri, 07 Nov 2008 10:43:48 -0500
>>>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>>>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>>>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>>>>
>>>>> Sounds exactly like the issue I have, I think something is trying to
>> get
>>>>> all those records, I tried to trace it but with no luck, I think it may
>> be
>>>>> related to the back/next links on the ticket display page. It's
>> checking
>>>>> each record for something, This is ok with small results but crashes
>> with
>>>>> large sets. I really wish I could figure this one out, I get the
>>>>> occasional 500 and users are made aware to keep search results smaller.
>> In
>>>>> my testing this affected 3.4.x 3.6.x a

Re: [rt-users] AssetTracker crashes loading asset...raw horsepower solution?

[Todd Chapman]

How many assets do you have? Nobody has ever seen this issue before

On Tue, Nov 11, 2008 at 12:57 PM, John <[EMAIL PROTECTED]> wrote:

> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>
> I think i may have found a bit of a solution to the AT problem.  we're
> running on 2 quad-core servers as frontends with 8gb memory each.  the
> fault im seeing in AT is due to a timeout in apache waiting for its
> backend processes to respond from huge queries...so:
>
>   
> AddHandler fcgid-script .fcgi
>
> OutputBufferSize 128
> IdleTimeout 600
>   ProcessLifeTime 3600
>   MaxProcessCount 8
>   DefaultMinClassProcessCount 3
>   DefaultMaxClassProcessCount 3
>
>   
> IPCConnectTimeout 20
> IPCCommTimeout 600
>
> has resolved the AT issue from what im seeing.  queries still take a long
> time, but thats just because RT is pulling lots of other data from mysql
> that im not certain is even pertanent to the asset/ticket at hand.  could
> the speed of the query be increased by changing maxprocesscount to a
> higher value?
>
> im running into issues now with the population of a user rights page that
> includes 300-400 users...namely:
>
> RT::Group::Privileged Unimplemented in HTML::Mason::Commands.
> (/opt/rt3/share/html/Elements/ShowUserConcise line 52)
>
> any ideas?
>
>
>
> > Date: Fri, 07 Nov 2008 12:52:04 -0500
> > From: Curtis Bruneau <[EMAIL PROTECTED]>
> > To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
> > Subject: Re: [rt-users] AssetTracker crashes loading asset
> >
> > The queries would execute fine, the problem at least in my case is it
> tries
> > to load the whole result set into memory causing oom-killer to go on
> rampage.
> > Apache will peak out, to sort of help this situation I added a mem limit
> to
> > the fastcgi handler which will basically die before things get really
> ugly.
> > I'm able to see this query in the log, it has no limit clause so it
> really is
> > getting everything. While doing a form of debug/trace on the
> apache/handler
> > I'm also able to see it trying to load the full row times search results
> > (table.*) into memory. This is all on a ticket display from a large
> search
> > result. So unless you are loading it in memory as opposed to say a shell
> > client output you won't run into memory problems.
> >
> > Best of luck with your situation, I have not been able to get any
> > confirmation until now with you. I've produced somewhat detailed bug
> report
> > but it appears to be somewhat isolated.. people with low tickets will
> never
> > run into this problem.
> >
> > Curtis
> >
> > John wrote:
> >> curtis:
> >> ive played around re-executing the mysql queries related to the RT
> crash,
> >> and to no avail.  they execute just fine.
> >>
> >> could this perhaps be a syslog issue like in RT?  is there a seperate
> >> control for syslogging in AT?
> >>
> >>
> >> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
> >>
> >>> Date: Fri, 07 Nov 2008 10:43:48 -0500
> >>> From: Curtis Bruneau <[EMAIL PROTECTED]>
> >>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
> >>> Subject: Re: [rt-users] AssetTracker crashes loading asset
> >>>
> >>> Sounds exactly like the issue I have, I think something is trying to
> get
> >>> all those records, I tried to trace it but with no luck, I think it may
> be
> >>> related to the back/next links on the ticket display page. It's
> checking
> >>> each record for something, This is ok with small results but crashes
> with
> >>> large sets. I really wish I could figure this one out, I get the
> >>> occasional 500 and users are made aware to keep search results smaller.
> In
> >>> my testing this affected 3.4.x 3.6.x and 3.8.x
> >>>
> >>> John wrote:
> >>>> well, just as i thought the RT slowness issue had been resolved,
> >>>> assettracker
> >>>> is now dying when loading a ticket out of a large list.
> >>>>
> >>>> example:  clicking "all assets" enumerates a 9000 row list fine,
> >>>> but clicking on any element in the list will crunch for a while
> >>>> then die with a 500 error.
> >>>>
> >>>> smaller lists with say 1000-3000 rows are sluggish when loading
> >>>> an asset from the list, but succeed.
> >>>>
> >>>&g

[rt-users] AssetTracker crashes loading asset...raw horsepower solution?

[John]

On Fri, 7 Nov 2008, Curtis Bruneau wrote:

I think i may have found a bit of a solution to the AT problem.  we're 
running on 2 quad-core servers as frontends with 8gb memory each.  the 
fault im seeing in AT is due to a timeout in apache waiting for its 
backend processes to respond from huge queries...so:

   
 AddHandler fcgid-script .fcgi

OutputBufferSize 128
IdleTimeout 600
   ProcessLifeTime 3600
   MaxProcessCount 8
   DefaultMinClassProcessCount 3
   DefaultMaxClassProcessCount 3

   
IPCConnectTimeout 20
IPCCommTimeout 600

has resolved the AT issue from what im seeing.  queries still take a long 
time, but thats just because RT is pulling lots of other data from mysql 
that im not certain is even pertanent to the asset/ticket at hand.  could 
the speed of the query be increased by changing maxprocesscount to a 
higher value?

im running into issues now with the population of a user rights page that 
includes 300-400 users...namely:

RT::Group::Privileged Unimplemented in HTML::Mason::Commands. 
(/opt/rt3/share/html/Elements/ShowUserConcise line 52)

any ideas?



> Date: Fri, 07 Nov 2008 12:52:04 -0500
> From: Curtis Bruneau <[EMAIL PROTECTED]>
> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] AssetTracker crashes loading asset
> 
> The queries would execute fine, the problem at least in my case is it tries 
> to load the whole result set into memory causing oom-killer to go on rampage. 
> Apache will peak out, to sort of help this situation I added a mem limit to 
> the fastcgi handler which will basically die before things get really ugly. 
> I'm able to see this query in the log, it has no limit clause so it really is 
> getting everything. While doing a form of debug/trace on the apache/handler 
> I'm also able to see it trying to load the full row times search results 
> (table.*) into memory. This is all on a ticket display from a large search 
> result. So unless you are loading it in memory as opposed to say a shell 
> client output you won't run into memory problems.
>
> Best of luck with your situation, I have not been able to get any 
> confirmation until now with you. I've produced somewhat detailed bug report 
> but it appears to be somewhat isolated.. people with low tickets will never 
> run into this problem.
>
> Curtis
>
> John wrote:
>> curtis:
>> ive played around re-executing the mysql queries related to the RT crash, 
>> and to no avail.  they execute just fine.
>> 
>> could this perhaps be a syslog issue like in RT?  is there a seperate 
>> control for syslogging in AT?
>> 
>> 
>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>> 
>>> Date: Fri, 07 Nov 2008 10:43:48 -0500
>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>> 
>>> Sounds exactly like the issue I have, I think something is trying to get 
>>> all those records, I tried to trace it but with no luck, I think it may be 
>>> related to the back/next links on the ticket display page. It's checking 
>>> each record for something, This is ok with small results but crashes with 
>>> large sets. I really wish I could figure this one out, I get the 
>>> occasional 500 and users are made aware to keep search results smaller. In 
>>> my testing this affected 3.4.x 3.6.x and 3.8.x
>>> 
>>> John wrote:
>>>> well, just as i thought the RT slowness issue had been resolved, 
>>>> assettracker
>>>> is now dying when loading a ticket out of a large list.
>>>> 
>>>> example:  clicking "all assets" enumerates a 9000 row list fine,
>>>> but clicking on any element in the list will crunch for a while
>>>> then die with a 500 error.
>>>> 
>>>> smaller lists with say 1000-3000 rows are sluggish when loading
>>>> an asset from the list, but succeed.
>>>> 
>>>> [EMAIL PROTECTED]
>>>> SDF Public Access UNIX System - http://sdf.lonestar.org
>>>> ___
>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>> 
>>>> Community help: http://wiki.bestpractical.com
>>>> Commercial support: [EMAIL PROTECTED]
>>>> 
>>>> 
>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy 
>>>> a copy at http://rtbook.bestpractical.com
>>>> 
>>>> 
>>>> 
>>> 
>>> 
>> 
>> [EMAIL PROTECTED]
>> SDF Public Access UNIX System - http://sdf.lonestar.org
>

[EMAIL PROTECTED]
SDF Public Access UNIX System - http://sdf.lonestar.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker crashes loading asset

[Curtis Bruneau]

That's around near the limit of what I can pull in. While you are 
probably right with it being isolated, 20 seconds does seem a little 
suspect. I'm curious how much memory is being used during that call. We 
have a lot of attachments which makes each record rather large at times. 
If you do end up finding a solution to your problem I'm curious to hear it.

John wrote:
> hrm...i just pulled in a list of 47,000 RT tickets and was able to 
> load a single ticket after a time of about 20 seconds...seemed normal.
> have you tried Set($LogToSyslog , 'alert'); as a solution?
>
> this seems isolated to assettracker...i think...
>
> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>
>> Date: Fri, 07 Nov 2008 13:12:53 -0500
>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>
>>   While my issue is not related to asset tracker, the behavior sounds 
>> identical. It seems to be related to how RT handles search and 
>> display, the only thing I can think of is the menu on the left, It 
>> has to determine the first and last record and also next and prev, I 
>> think it's doing a full scan to figure it out.. pretty intensive 
>> operation, It would be better if it didn't have to deal with table.* 
>> and say only table.ticketid.
>>
>> <> < Prev
>> #12345
>> Next >
>> Last >>
>>
>> Sorry for the confusion, could just be a coincidence.
>>
>> Curtis
>>
>> John wrote:
>>>
>>> not certain it makes much sense...ive never had this problem in rt 
>>> 3.4.5 with at 1.2.3..
>>>
>>>
>>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>>>
>>>
>>>
>>>> Date: Fri, 07 Nov 2008 12:52:04 -0500
>>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>>>
>>>> The queries would execute fine, the problem at least in my case is 
>>>> it tries to load the whole result set into memory causing 
>>>> oom-killer to go on rampage. Apache will peak out, to sort of help 
>>>> this situation I added a mem limit to the fastcgi handler which 
>>>> will basically die before things get really ugly. I'm able to see 
>>>> this query in the log, it has no limit clause so it really is 
>>>> getting everything. While doing a form of debug/trace on the 
>>>> apache/handler I'm also able to see it trying to load the full row 
>>>> times search results (table.*) into memory. This is all on a ticket 
>>>> display from a large search result. So unless you are loading it in 
>>>> memory as opposed to say a shell client output you won't run into 
>>>> memory problems.
>>>>
>>>> Best of luck with your situation, I have not been able to get any 
>>>> confirmation until now with you. I've produced somewhat detailed 
>>>> bug report but it appears to be somewhat isolated.. people with low 
>>>> tickets will never run into this problem.
>>>>
>>>> Curtis
>>>>
>>>> John wrote:
>>>>> curtis:
>>>>> ive played around re-executing the mysql queries related to the RT 
>>>>> crash, and to no avail.  they execute just fine.
>>>>>
>>>>> could this perhaps be a syslog issue like in RT?  is there a 
>>>>> seperate control for syslogging in AT?
>>>>>
>>>>>
>>>>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>>>>>
>>>>>> Date: Fri, 07 Nov 2008 10:43:48 -0500
>>>>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>>>>> To: John <[EMAIL PROTECTED]>, 
>>>>>> rt-users@lists.bestpractical.com
>>>>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>>>>>
>>>>>> Sounds exactly like the issue I have, I think something is trying 
>>>>>> to get all those records, I tried to trace it but with no luck, I 
>>>>>> think it may be related to the back/next links on the ticket 
>>>>>> display page. It's checking each record for something, This is ok 
>>>>>> with small results but crashes with large sets. I really wish I 
>>>>>> could figure this one out

Re: [rt-users] AssetTracker crashes loading asset

[John]

hrm...i just pulled in a list of 47,000 RT tickets and was able to load a 
single ticket after a time of about 20 seconds...seemed normal.
have you tried Set($LogToSyslog , 'alert'); as a solution?

this seems isolated to assettracker...i think...

On Fri, 7 Nov 2008, Curtis Bruneau wrote:

> Date: Fri, 07 Nov 2008 13:12:53 -0500
> From: Curtis Bruneau <[EMAIL PROTECTED]>
> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] AssetTracker crashes loading asset
>
>   While my issue is not related to asset tracker, the behavior sounds 
> identical. It seems to be related to how RT handles search and display, the 
> only thing I can think of is the menu on the left, It has to determine the 
> first and last record and also next and prev, I think it's doing a full scan 
> to figure it out.. pretty intensive operation, It would be better if it 
> didn't have to deal with table.* and say only table.ticketid.
>
> < < Prev
> #12345
> Next >
> Last >>
>
> Sorry for the confusion, could just be a coincidence.
>
> Curtis
>
> John wrote:
>> 
>> not certain it makes much sense...ive never had this problem in rt 3.4.5 
>> with at 1.2.3..
>> 
>> 
>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>> 
>> 
>> 
>>> Date: Fri, 07 Nov 2008 12:52:04 -0500
>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>> 
>>> The queries would execute fine, the problem at least in my case is it 
>>> tries to load the whole result set into memory causing oom-killer to go on 
>>> rampage. Apache will peak out, to sort of help this situation I added a 
>>> mem limit to the fastcgi handler which will basically die before things 
>>> get really ugly. I'm able to see this query in the log, it has no limit 
>>> clause so it really is getting everything. While doing a form of 
>>> debug/trace on the apache/handler I'm also able to see it trying to load 
>>> the full row times search results (table.*) into memory. This is all on a 
>>> ticket display from a large search result. So unless you are loading it in 
>>> memory as opposed to say a shell client output you won't run into memory 
>>> problems.
>>> 
>>> Best of luck with your situation, I have not been able to get any 
>>> confirmation until now with you. I've produced somewhat detailed bug 
>>> report but it appears to be somewhat isolated.. people with low tickets 
>>> will never run into this problem.
>>> 
>>> Curtis
>>> 
>>> John wrote:
>>>> curtis:
>>>> ive played around re-executing the mysql queries related to the RT crash, 
>>>> and to no avail.  they execute just fine.
>>>> 
>>>> could this perhaps be a syslog issue like in RT?  is there a seperate 
>>>> control for syslogging in AT?
>>>> 
>>>> 
>>>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>>>> 
>>>>> Date: Fri, 07 Nov 2008 10:43:48 -0500
>>>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>>>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>>>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>>>> 
>>>>> Sounds exactly like the issue I have, I think something is trying to get 
>>>>> all those records, I tried to trace it but with no luck, I think it may 
>>>>> be related to the back/next links on the ticket display page. It's 
>>>>> checking each record for something, This is ok with small results but 
>>>>> crashes with large sets. I really wish I could figure this one out, I 
>>>>> get the occasional 500 and users are made aware to keep search results 
>>>>> smaller. In my testing this affected 3.4.x 3.6.x and 3.8.x
>>>>> 
>>>>> John wrote:
>>>>>> well, just as i thought the RT slowness issue had been resolved, 
>>>>>> assettracker
>>>>>> is now dying when loading a ticket out of a large list.
>>>>>> 
>>>>>> example:  clicking "all assets" enumerates a 9000 row list fine,
>>>>>> but clicking on any element in the list will crunch for a while
>>>>>> then die with a 500 error.
>>>>>> 
>>>>>> smaller lists with say 1000-3000 rows 

Re: [rt-users] AssetTracker crashes loading asset

[Curtis Bruneau]

While my issue is not related to asset tracker, the behavior sounds 
identical. It seems to be related to how RT handles search and display, 
the only thing I can think of is the menu on the left, It has to 
determine the first and last record and also next and prev, I think it's 
doing a full scan to figure it out.. pretty intensive operation, It 
would be better if it didn't have to deal with table.* and say only 
table.ticketid.

<
Last >>

Sorry for the confusion, could just be a coincidence.

Curtis

John wrote:
>
> not certain it makes much sense...ive never had this problem in rt 
> 3.4.5 with at 1.2.3..
>
>
> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>
>
>
>> Date: Fri, 07 Nov 2008 12:52:04 -0500
>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>
>> The queries would execute fine, the problem at least in my case is it 
>> tries to load the whole result set into memory causing oom-killer to 
>> go on rampage. Apache will peak out, to sort of help this situation I 
>> added a mem limit to the fastcgi handler which will basically die 
>> before things get really ugly. I'm able to see this query in the log, 
>> it has no limit clause so it really is getting everything. While 
>> doing a form of debug/trace on the apache/handler I'm also able to 
>> see it trying to load the full row times search results (table.*) 
>> into memory. This is all on a ticket display from a large search 
>> result. So unless you are loading it in memory as opposed to say a 
>> shell client output you won't run into memory problems.
>>
>> Best of luck with your situation, I have not been able to get any 
>> confirmation until now with you. I've produced somewhat detailed bug 
>> report but it appears to be somewhat isolated.. people with low 
>> tickets will never run into this problem.
>>
>> Curtis
>>
>> John wrote:
>>> curtis:
>>> ive played around re-executing the mysql queries related to the RT 
>>> crash, and to no avail.  they execute just fine.
>>>
>>> could this perhaps be a syslog issue like in RT?  is there a 
>>> seperate control for syslogging in AT?
>>>
>>>
>>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>>>
>>>> Date: Fri, 07 Nov 2008 10:43:48 -0500
>>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>>>
>>>> Sounds exactly like the issue I have, I think something is trying 
>>>> to get all those records, I tried to trace it but with no luck, I 
>>>> think it may be related to the back/next links on the ticket 
>>>> display page. It's checking each record for something, This is ok 
>>>> with small results but crashes with large sets. I really wish I 
>>>> could figure this one out, I get the occasional 500 and users are 
>>>> made aware to keep search results smaller. In my testing this 
>>>> affected 3.4.x 3.6.x and 3.8.x
>>>>
>>>> John wrote:
>>>>> well, just as i thought the RT slowness issue had been resolved, 
>>>>> assettracker
>>>>> is now dying when loading a ticket out of a large list.
>>>>>
>>>>> example:  clicking "all assets" enumerates a 9000 row list fine,
>>>>> but clicking on any element in the list will crunch for a while
>>>>> then die with a 500 error.
>>>>>
>>>>> smaller lists with say 1000-3000 rows are sluggish when loading
>>>>> an asset from the list, but succeed.
>>>>>
>>>>> [EMAIL PROTECTED]
>>>>> SDF Public Access UNIX System - http://sdf.lonestar.org
>>>>> ___
>>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>>
>>>>> Community help: http://wiki.bestpractical.com
>>>>> Commercial support: [EMAIL PROTECTED]
>>>>>
>>>>>
>>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly 
>>>>> Media. Buy a copy at http://rtbook.bestpractical.com
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>> [EMAIL PROTECTED]
>>> SDF Public Access UNIX System - http://sdf.lonestar.org
>>
>
> [EMAIL PROTECTED]
> SDF Public Access UNIX System - http://sdf.lonestar.org
>
>

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker crashes loading asset

[John]

not certain it makes much sense...ive never had this problem in rt 3.4.5 
with at 1.2.3..


On Fri, 7 Nov 2008, Curtis Bruneau wrote:



> Date: Fri, 07 Nov 2008 12:52:04 -0500
> From: Curtis Bruneau <[EMAIL PROTECTED]>
> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] AssetTracker crashes loading asset
> 
> The queries would execute fine, the problem at least in my case is it tries 
> to load the whole result set into memory causing oom-killer to go on rampage. 
> Apache will peak out, to sort of help this situation I added a mem limit to 
> the fastcgi handler which will basically die before things get really ugly. 
> I'm able to see this query in the log, it has no limit clause so it really is 
> getting everything. While doing a form of debug/trace on the apache/handler 
> I'm also able to see it trying to load the full row times search results 
> (table.*) into memory. This is all on a ticket display from a large search 
> result. So unless you are loading it in memory as opposed to say a shell 
> client output you won't run into memory problems.
>
> Best of luck with your situation, I have not been able to get any 
> confirmation until now with you. I've produced somewhat detailed bug report 
> but it appears to be somewhat isolated.. people with low tickets will never 
> run into this problem.
>
> Curtis
>
> John wrote:
>> curtis:
>> ive played around re-executing the mysql queries related to the RT crash, 
>> and to no avail.  they execute just fine.
>> 
>> could this perhaps be a syslog issue like in RT?  is there a seperate 
>> control for syslogging in AT?
>> 
>> 
>> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>> 
>>> Date: Fri, 07 Nov 2008 10:43:48 -0500
>>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>> 
>>> Sounds exactly like the issue I have, I think something is trying to get 
>>> all those records, I tried to trace it but with no luck, I think it may be 
>>> related to the back/next links on the ticket display page. It's checking 
>>> each record for something, This is ok with small results but crashes with 
>>> large sets. I really wish I could figure this one out, I get the 
>>> occasional 500 and users are made aware to keep search results smaller. In 
>>> my testing this affected 3.4.x 3.6.x and 3.8.x
>>> 
>>> John wrote:
>>>> well, just as i thought the RT slowness issue had been resolved, 
>>>> assettracker
>>>> is now dying when loading a ticket out of a large list.
>>>> 
>>>> example:  clicking "all assets" enumerates a 9000 row list fine,
>>>> but clicking on any element in the list will crunch for a while
>>>> then die with a 500 error.
>>>> 
>>>> smaller lists with say 1000-3000 rows are sluggish when loading
>>>> an asset from the list, but succeed.
>>>> 
>>>> [EMAIL PROTECTED]
>>>> SDF Public Access UNIX System - http://sdf.lonestar.org
>>>> ___
>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>> 
>>>> Community help: http://wiki.bestpractical.com
>>>> Commercial support: [EMAIL PROTECTED]
>>>> 
>>>> 
>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy 
>>>> a copy at http://rtbook.bestpractical.com
>>>> 
>>>> 
>>>> 
>>> 
>>> 
>> 
>> [EMAIL PROTECTED]
>> SDF Public Access UNIX System - http://sdf.lonestar.org
>

[EMAIL PROTECTED]
SDF Public Access UNIX System - http://sdf.lonestar.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker crashes loading asset

[Curtis Bruneau]

The queries would execute fine, the problem at least in my case is it 
tries to load the whole result set into memory causing oom-killer to go 
on rampage. Apache will peak out, to sort of help this situation I added 
a mem limit to the fastcgi handler which will basically die before 
things get really ugly. I'm able to see this query in the log, it has no 
limit clause so it really is getting everything. While doing a form of 
debug/trace on the apache/handler I'm also able to see it trying to load 
the full row times search results (table.*) into memory. This is all on 
a ticket display from a large search result. So unless you are loading 
it in memory as opposed to say a shell client output you won't run into 
memory problems.

Best of luck with your situation, I have not been able to get any 
confirmation until now with you. I've produced somewhat detailed bug 
report but it appears to be somewhat isolated.. people with low tickets 
will never run into this problem.

Curtis

John wrote:
> curtis:
> ive played around re-executing the mysql queries related to the RT 
> crash, and to no avail.  they execute just fine.
>
> could this perhaps be a syslog issue like in RT?  is there a seperate 
> control for syslogging in AT?
>
>
> On Fri, 7 Nov 2008, Curtis Bruneau wrote:
>
>> Date: Fri, 07 Nov 2008 10:43:48 -0500
>> From: Curtis Bruneau <[EMAIL PROTECTED]>
>> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
>> Subject: Re: [rt-users] AssetTracker crashes loading asset
>>
>> Sounds exactly like the issue I have, I think something is trying to 
>> get all those records, I tried to trace it but with no luck, I think 
>> it may be related to the back/next links on the ticket display page. 
>> It's checking each record for something, This is ok with small 
>> results but crashes with large sets. I really wish I could figure 
>> this one out, I get the occasional 500 and users are made aware to 
>> keep search results smaller. In my testing this affected 3.4.x 3.6.x 
>> and 3.8.x
>>
>> John wrote:
>>> well, just as i thought the RT slowness issue had been resolved, 
>>> assettracker
>>> is now dying when loading a ticket out of a large list.
>>>
>>> example:  clicking "all assets" enumerates a 9000 row list fine,
>>> but clicking on any element in the list will crunch for a while
>>> then die with a 500 error.
>>>
>>> smaller lists with say 1000-3000 rows are sluggish when loading
>>> an asset from the list, but succeed.
>>>
>>> [EMAIL PROTECTED]
>>> SDF Public Access UNIX System - http://sdf.lonestar.org
>>> ___
>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>
>>> Community help: http://wiki.bestpractical.com
>>> Commercial support: [EMAIL PROTECTED]
>>>
>>>
>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>>> Buy a copy at http://rtbook.bestpractical.com
>>>
>>>
>>>
>>
>>
>
> [EMAIL PROTECTED]
> SDF Public Access UNIX System - http://sdf.lonestar.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker crashes loading asset

[John]

curtis:
ive played around re-executing the mysql queries related to the RT crash, 
and to no avail.  they execute just fine.

could this perhaps be a syslog issue like in RT?  is there a seperate 
control for syslogging in AT?


On Fri, 7 Nov 2008, Curtis Bruneau wrote:

> Date: Fri, 07 Nov 2008 10:43:48 -0500
> From: Curtis Bruneau <[EMAIL PROTECTED]>
> To: John <[EMAIL PROTECTED]>, rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] AssetTracker crashes loading asset
> 
> Sounds exactly like the issue I have, I think something is trying to get all 
> those records, I tried to trace it but with no luck, I think it may be 
> related to the back/next links on the ticket display page. It's checking each 
> record for something, This is ok with small results but crashes with large 
> sets. I really wish I could figure this one out, I get the occasional 500 and 
> users are made aware to keep search results smaller. In my testing this 
> affected 3.4.x 3.6.x and 3.8.x
>
> John wrote:
>> well, just as i thought the RT slowness issue had been resolved, 
>> assettracker
>> is now dying when loading a ticket out of a large list.
>> 
>> example:  clicking "all assets" enumerates a 9000 row list fine,
>> but clicking on any element in the list will crunch for a while
>> then die with a 500 error.
>> 
>> smaller lists with say 1000-3000 rows are sluggish when loading
>> an asset from the list, but succeed.
>> 
>> [EMAIL PROTECTED]
>> SDF Public Access UNIX System - http://sdf.lonestar.org
>> ___
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>> 
>> Community help: http://wiki.bestpractical.com
>> Commercial support: [EMAIL PROTECTED]
>> 
>> 
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a 
>> copy at http://rtbook.bestpractical.com
>> 
>>
>> 
>
>

[EMAIL PROTECTED]
SDF Public Access UNIX System - http://sdf.lonestar.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] AssetTracker crashes loading asset

[Curtis Bruneau]

Sounds exactly like the issue I have, I think something is trying to get 
all those records, I tried to trace it but with no luck, I think it may 
be related to the back/next links on the ticket display page. It's 
checking each record for something, This is ok with small results but 
crashes with large sets. I really wish I could figure this one out, I 
get the occasional 500 and users are made aware to keep search results 
smaller. In my testing this affected 3.4.x 3.6.x and 3.8.x

John wrote:
> well, just as i thought the RT slowness issue had been resolved, 
> assettracker
> is now dying when loading a ticket out of a large list.
>
> example:  clicking "all assets" enumerates a 9000 row list fine,
> but clicking on any element in the list will crunch for a while
> then die with a 500 error.
>
> smaller lists with say 1000-3000 rows are sluggish when loading
> an asset from the list, but succeed.
>
> [EMAIL PROTECTED]
> SDF Public Access UNIX System - http://sdf.lonestar.org
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>
>   

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] AssetTracker crashes loading asset

[John]

well, just as i thought the RT slowness issue had been resolved, 
assettracker
is now dying when loading a ticket out of a large list.

example:  clicking "all assets" enumerates a 9000 row list fine,
but clicking on any element in the list will crunch for a while
then die with a 500 error.

smaller lists with say 1000-3000 rows are sluggish when loading
an asset from the list, but succeed.

[EMAIL PROTECTED]
SDF Public Access UNIX System - http://sdf.lonestar.org
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com