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
