Error migration from otrs-5.0.42 to znuny-6.3.4

Moderator: crythias

Post Reply
DevOpsEngineer
Znuny newbie
Posts: 1
Joined: 18 Sep 2023, 13:34
Znuny Version: 6.3.4
Real Name: Marius

Error migration from otrs-5.0.42 to znuny-6.3.4

Post by DevOpsEngineer »

Hi, I apologize for my first post on the forum.
But I've been searching for a solution online for quite a while and couldn't find a solution to the problem described below. I kindly request your technical support. Centos 7.9 znuny-6.3.4/PGSQL 9.2 Error description: After step-by-step migration from otrs-5.0.42 to znuny-6.3.4, there is an issue with long login times, and the following entry is recorded in the log:


Sep 18 12:13:27 otrs-prod01-otrs01 OTRS-CGI-10[28097]: [Error][Kernel::System::Ticket::TicketSearch::TicketCountByAttribute][Line:2867]: number of parameters must be between 0 and 65535, SQL: 'SELECT COUNT(*), queue_id FROM ticket WHERE id IN AND queue_id IS NOT NULL GROUP BY queue_id LIMIT 10000'

[Mon Sep 18 12:13:27 2023] -e: DBD::Pg::st execute failed: number of parameters must be between 0 and 65535 at /opt/otrs//Kernel/System/DB.pm line 695.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Sep 18 12:13:27 2023
Message: number of parameters must be between 0 and 65535, SQL: 'SELECT COUNT(*), queue_id FROM ticket WHERE id IN
RemoteAddress: ::1
RequestURI: /otrs/index.pl?

Traceback (28097):
Module: Kernel::System::Ticket::TicketSearch::TicketCountByAttribute Line: 2867
Module: Kernel::Output::HTML::Dashboard::TicketQueueOverview::Run Line: 178
Module: Kernel::Modules::AgentDashboardCommon::_Element Line: 981
Module: Kernel::Modules::AgentDashboardCommon::Run Line: 611
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1144
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 39
Module: (eval) (v1.99) Line: 207
Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
Module: ModPerl::Registry
Post Reply