Hi Philippe, I think the issue you're having is that you use the StaticDB index accelerator. This creates a 'materialized view' that holds ticket data, and OTRS looks at that one when displaying the queue view. Updating the queue name does not trigger a rebuild of this index. There is a script that runs in cron which indeed does the rebuild: bin/otrs.RebuildTicketIndex.pl - a workaround would be to run this script after you've renamed the queues, and the correct names will appear in the queue view.
See also this issue in our bug tracker: http://bugs.otrs.org/show_bug.cgi?id=5189 Hope this helps, -- Mike On Wed, Mar 7, 2012 at 11:32, Martignier, Philippe <[email protected]> wrote: > Hi there, > > The problem is still there, BUT the queues are refreshed during the night. > > It means on Monday I modify the name of a queue > > On Tuesday only I can see that change in queueview (AgentTicketQueue). > > Question: is there a job that runs a refresh during the night? > > I have that on both installations of OTRS (production and test ones). > > It was working perfectly before (but I can not tell exactly when it brokes) > > Thanks for any idea, cause I am lost on this ... > > Cheers, > > Philippe > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > [email protected] > Sent: lundi, 5. mars 2012 16:17 > To: [email protected] > Subject: otrs Digest, Vol 42, Issue 5 > > Send otrs mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.otrs.org/cgi-bin/listinfo/otrs > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of otrs digest..." > > > Today's Topics: > > 1. Re: Clean-up database after switch to ArticleStorageFS > (Steven Carr) > 2. Problem of refresh in queue view (Martignier, Philippe) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 5 Mar 2012 14:37:00 +0000 > From: Steven Carr <[email protected]> > Subject: Re: [otrs] Clean-up database after switch to ArticleStorageFS > To: "User questions and discussions about OTRS." <[email protected]> > Message-ID: > <calmep07l2aqgqu2vmwdghbzqroyqxb1hbupzvlxsosnzkqj...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > My bad, it looks like the otrs.ArticleStorageSwitch.pl did move the > articles out of the 'article_plain' table, but the actual 'article' table > still contains a plaintext copy of the message eating up a fair chunk of > database space. > > Steve > > > On 5 March 2012 13:58, Steven Carr <[email protected]> wrote: > >> Anyone know what is safe to clean (read delete) out of the database after >> switching OTRS (3.0.11) over to ArticleStorageFS? or if there is something >> you can run to magically get rid of the redundant articles eating up space >> in the database? >> >> Thanks >> >> Steve >> > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.otrs.org/pipermail/otrs/attachments/20120305/d7901f09/attachment-0001.html> > > ------------------------------ > > Message: 2 > Date: Mon, 5 Mar 2012 16:15:45 +0100 > From: "Martignier, Philippe" <[email protected]> > Subject: [otrs] Problem of refresh in queue view > To: "[email protected]" <[email protected]> > Message-ID: > <c6026f755865704592feef72ec4927bf08d2e57...@iccv103c.gms02.unicc.org> > Content-Type: text/plain; charset="us-ascii" > > I tried to clean the caches as proposed here on the mailing list, it has no > effect at all. > > > please run $OTRS_HOME/bin/otrs.CacheDelete.pl once and check your frontend > again. > > > > Right in the admin menu, wrong in queueview ... > > > > Any help welcome > > > > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > [email protected] > Sent: lundi, 5. mars 2012 15:36 > To: [email protected] > Subject: otrs Digest, Vol 42, Issue 4 > > > > Send otrs mailing list submissions to > > [email protected] > > > > To subscribe or unsubscribe via the World Wide Web, visit > > http://lists.otrs.org/cgi-bin/listinfo/otrs > > or, via email, send a message with subject or body 'help' to > > [email protected] > > > > You can reach the person managing the list at > > [email protected] > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of otrs digest..." > > > > > > Today's Topics: > > > > 1. Errors during ArticleStorageSwitch (Sune T. Tougaard) > > 2. Clean-up database after switch to ArticleStorageFS (Steven Carr) > > 3. Problem of refresh in queue view (Martignier, Philippe) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Mon, 5 Mar 2012 12:20:21 +0000 > > From: "Sune T. Tougaard" <[email protected]> > > Subject: [otrs] Errors during ArticleStorageSwitch > > To: "[email protected]" <[email protected]> > > Message-ID: > > > <307b82f59acec64a963ef7b6284114dd1c331...@dkmail01.lint.lyngso-industri.dk> > > > > Content-Type: text/plain; charset="us-ascii" > > > > Hi list, > > > > I've been trying out different options on our test-install of otrs (currently > 3.1.1.). > > One thing I wanted to try, was to use the filesystem for articlestorage. > > I guess it works ok, but doing the actual switch with the current content of > the DB seems to be giving me some troubles. > > > > After a while, the following message appears: > > > > ERROR: OTRS-otrs.ArticleStorageSwitch.pl-20 Perl: 5.12.3 OS: MSWin32 Time: > Fri Mar 2 15:00:49 2012 > > > > Message: Not all files are moved! (TicketID:211813/ArticleID:440337)! > > > > Traceback (2572): > > Module: Kernel::System::Ticket::TicketArticleStorageSwitch (v1.540) Line: > 7105 > > Module: otrs\otrs\bin\otrs.ArticleStorageSwitch.pl (v1.16) Line: 164 > > > > After that, trying to start it again, gives me a "Can't create PID > ArticleStorageSwitch, because it's already running". > > I can start it again with a "-f 1" option and it starts over and then dies > again a little later (it usually continues past the earlier "problem point"). > > > > The log doesn't reveal much. > > Any ideas? > > > > Should I just continue forcing it, hoping it eventually gets through all > 42000 tickets (it gets a couple of thousands each time, I think)? Or am I > perhaps missing a step somewhere? > > > > Thanks for any input. > > > > -- > > /Sune T. > > > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > <http://lists.otrs.org/pipermail/otrs/attachments/20120305/ec421adb/attachment-0001.html> > > > > ------------------------------ > > > > Message: 2 > > Date: Mon, 5 Mar 2012 13:58:17 +0000 > > From: Steven Carr <[email protected]> > > Subject: [otrs] Clean-up database after switch to ArticleStorageFS > > To: "User questions and discussions about OTRS." <[email protected]> > > Message-ID: > > <CALMep04VDNp7=6xbu6bcja2-8tgqjlkyqb7p3faewzxc6-m...@mail.gmail.com> > > Content-Type: text/plain; charset="utf-8" > > > > Anyone know what is safe to clean (read delete) out of the database after > > switching OTRS (3.0.11) over to ArticleStorageFS? or if there is something > > you can run to magically get rid of the redundant articles eating up space > > in the database? > > > > Thanks > > > > Steve > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > <http://lists.otrs.org/pipermail/otrs/attachments/20120305/c35aa3e9/attachment-0001.html> > > > > ------------------------------ > > > > Message: 3 > > Date: Mon, 5 Mar 2012 15:35:18 +0100 > > From: "Martignier, Philippe" <[email protected]> > > Subject: [otrs] Problem of refresh in queue view > > To: "[email protected]" <[email protected]> > > Message-ID: > > <c6026f755865704592feef72ec4927bf08d2e57...@iccv103c.gms02.unicc.org> > > Content-Type: text/plain; charset="us-ascii" > > > > Hi there > > > > I have a huge problem of refresh. > > > > Version 2.4.8 > > > > In the admin menu, I change the name of a queue and it is shown correctly in > the move screen and in the my preferences (my queues), but in the ticket > view, the name displayed is the old one. > > > > I tried with different browser, with different login, the result is still the > same. The queue view in the ticket view is not properly refreshed. > > > > Any help welcome > > > > Thanks > > > > PS: since dec 2009 the system never went wrong ... > > > > > > Philippe Martignier > > > > Communications Division > > > > Customer Service Center > > > > Email : [email protected]<mailto:[email protected]> > > > > Phone : 00 41 022 338 72 36 > > > > Building : NC > > > > Office : 3, 316 > > > > > > World Intellectual Property Organization Disclaimer: > > > > This electronic message may contain privileged, confidential and > > copyright protected information. If you have received this e-mail > > by mistake, please immediately notify the sender and delete this > > e-mail and all its attachments. Please ensure all e-mail attachments > > are scanned for viruses prior to opening or using. > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > <http://lists.otrs.org/pipermail/otrs/attachments/20120305/430f226f/attachment.html> > > > > ------------------------------ > > > > --------------------------------------------------------------------- > > OTRS mailing list: otrs - Webpage: http://otrs.org/ > > Archive: http://lists.otrs.org/pipermail/otrs > > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > > > End of otrs Digest, Vol 42, Issue 4 > > *********************************** > > World Intellectual Property Organization Disclaimer: > > This electronic message may contain privileged, confidential and > copyright protected information. If you have received this e-mail > by mistake, please immediately notify the sender and delete this > e-mail and all its attachments. Please ensure all e-mail attachments > are scanned for viruses prior to opening or using. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.otrs.org/pipermail/otrs/attachments/20120305/47764f60/attachment.html> > > ------------------------------ > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > End of otrs Digest, Vol 42, Issue 5 > *********************************** > > World Intellectual Property Organization Disclaimer: > > This electronic message may contain privileged, confidential and > copyright protected information. If you have received this e-mail > by mistake, please immediately notify the sender and delete this > e-mail and all its attachments. Please ensure all e-mail attachments > are scanned for viruses prior to opening or using. > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
