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 <carlos.rodrig...@otrs.com>
Para: User questions and discussions about OTRS. <otrs@otrs.org>
CC: Israel Garcia <iga3...@yahoo.com>
Enviado: Lunes 1 de octubre de 2012 16:32
Asunto: Re: [otrs] Queue view are not showing data after upgrade to 3.1
Hi Israel,
Did you follow all upgrade instructions to upgrade OTRS from 3.0 to 3.1?
I mean all steps from "UPGRADING" file?
((enjoy))
Carlos Rodríguez
On Oct 1, 2012, at 9:05 AM, Carlos Andrés Gallego Arboleda
<carlos.gall...@itconsultores.com.co> wrote:
OK Israel,
>
>
>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 <iga3...@yahoo.com>
>
>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 <carlos.gall...@itconsultores.com.co>
>>
>>Para: Israel Garcia <iga3...@yahoo.com>; User questions and discussions about
>>OTRS. <otrs@otrs.org>
>>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 <iga3...@yahoo.com>
>>
>>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 <carlos.rodrig...@otrs.com>
>>>Para: Israel Garcia <iga3...@yahoo.com>; User questions and discussions
>>>about OTRS. <otrs@otrs.org>
>>>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 <iga3...@yahoo.com> 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
---------------------------------------------------------------------
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