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 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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of otrs-request@otrs.org Sent: lundi, 5. mars 2012 16:17 To: otrs@otrs.org Subject: otrs Digest, Vol 42, Issue 5

Send otrs mailing list submissions to        otrs@otrs.org

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        otrs-request@otrs.org

You can reach the person managing the list at        otrs-owner@otrs.org

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 Subject: Re: [otrs] Clean-up database after switch to ArticleStorageFS To: "User questions and discussions about OTRS." Message-ID:         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 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