
OK carlos, I found the cause of my issue. The migration was fine, but someone here made changes on "Edit Config Settings in Ticket -> Frontend::Agent::Ticket::ViewQueue" and the queue view failed on key sort 7 in :Ticket::Frontend::AgentTicketQueue###QueueSort . I remove the 'key 7' and queue view is working now.
Thanks for your time.
regards
Israel.
________________________________
De: Carlos Rodríguez
Please view your table ticket on the database,
The fields Ticketfreetext, ticketarticlefreetext and ticketfreetime these should not be
If exists you must to use the scripts of migration again,
2012/10/1 Israel Garcia
Hi Carlos,
I run the script /opt/otrs/bin/otrs.RebuildTicketIndex.pl, restart all OTRS and no success. Should I check in another place? Log file still saying:
[Mon Oct 1 15:52:38 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)! [Mon Oct 1 15:52:38 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)! [Mon Oct 1 15:52:38 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)! [Mon Oct 1 15:52:38 2012][Notice][Kernel::System::Web::InterfaceAgent::Run] Response::Agent: 1s taken (URL:Action=AgentTicketQueue;QueueID=5;View=:igarcia) [Mon Oct 1 15:52:39 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)! [Mon Oct 1 15:52:39 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy
(TicketFreeKey7)!
[Mon Oct 1 15:52:39 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)! [Mon Oct 1 15:52:40 2012][Notice][Kernel::System::Web::InterfaceAgent::Run] Response::Agent: 1s taken (URL:Action=AgentTicketQueue;QueueID=5;Filter=All:igarcia) [Mon Oct 1 15:52:41 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)! [Mon Oct 1 15:52:41 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)! [Mon Oct 1 15:52:41 2012][Error][Kernel::System::TicketSearch::TicketSearch][417] Need valid SortBy (TicketFreeKey7)!
Should you need another info for this issue? I need, if possible, your help to solve this before to touch anything and break it ALL trying to fix it.
Thanks much.
________________________________ De: Carlos Andrés Gallego Arboleda
Para: Israel Garcia
; User questions and discussions about OTRS. Enviado: Lunes 1 de octubre de 2012 15:48 Asunto: Re: [otrs] Queue view are not showing data after upgrade to 3.1
Hi Israel,
You can use the scripts
/opt/otrs/script/otrs.RebuildTicketIndex.pl
2012/10/1 Israel Garcia
Hi Carlos,
I made a mistake when I said 3.0,16 I meant 3.1.16. Do you think I should reinstall all ITSM* from the Package manager TAB?
Really don't know which I made wrong on the migration. I appreciate your help. Thanks much.
regards, Israel.
________________________________ De: Carlos Rodríguez
Para: Israel Garcia ; User questions and discussions about OTRS. Enviado: Lunes 1 de octubre de 2012 13:54 Asunto: Re: [otrs] Queue view are not showing data after upgrade to 3.1 Hi Israel,
Sure this is easy ITSM 3.0.x is designed for OTRS 3.0.x, since you already upgrade OTRS to 3.1 you need also to upgrade ITSM packages to 3.1.x
please follow this link to get your packages http://www.otrs.com/en/open-source/get-otrs/software-download/
OTRS 3.1 introduces a new concept called DynamicFields, that replaces TicketFreeText, TicketFreeTime, ArticleFreeText and ArticleFreeTime, etc fixed fields in the Database.
Que pases un buen día / Have a nice day!
((enjoy))
Carlos Rodríguez
On Oct 1, 2012, at 5:49 AM, Israel Garcia
wrote: Hi everybody
After an upgrade to version 3.1 of OTRS and upgrade of ITSM addons from 3.0.5 to 3.0.16 'Queue tickets' are not shown:
When clic on 'Queue view' there's no tickets data found. Any idea why?
Log file is showing:
Appreciate your help.
Thanks.
--------------------------------------------------------------------- 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
---------------------------------------------------------------------
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