Is there a way to migrate from MySQL to PostgreSQL?

[Miguel Ferraz]

Hi

I’ve tried a migration using pgloader, but when I try to use OTOBO I get the following errors:

RemoteAddress: 193.137.54.7
RequestURI: /otobo/index.pl?Action=AgentTicketQueue

Traceback (29064):
Module: Kernel::System::Main::Require Line: 85
Module: Kernel::Output::HTML::Layout::NavigationBar Line: 3321
Module: Kernel::Modules::AgentTicketQueue::Run Line: 194
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1257
Module: ModPerl::ROOT::ModPerl::Registry::opt_otobo_bin_cgi_2dbin_index_2epl::handler Line: 37
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::handler (v1.99) Line: 32

ERROR: OTOBO-CGI-15 Perl: 5.30.0 OS: linux Time: Mon Jul 12 14:48:44 2021

Message: Invalid date/time string 2017-11-03 11:02:42+00.

RemoteAddress: 193.137.54.7
RequestURI: /otobo/index.pl?Action=AgentTicketQueue

Traceback (29064):
Module: Kernel::System::DateTime::_StringToHash Line: 1768
Module: Kernel::System::DateTime::_CPANDateTimeObjectCreate Line: 1825
Module: Kernel::System::DateTime::new Line: 167
Module: Kernel::System::ObjectManager::_ObjectBuild Line: 323
Module: Kernel::System::ObjectManager::Create Line: 254
Module: Kernel::System::Ticket::IndexAccelerator::StaticDB::TicketAcceleratorIndex Line: 526
Module: Kernel::System::Ticket::TicketAcceleratorIndex Line: 7820
Module: Kernel::Modules::AgentTicketQueue::BuildQueueView Line: 546
Module: Kernel::Modules::AgentTicketQueue::Run Line: 476
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1257
Module: ModPerl::ROOT::ModPerl::Registry::opt_otobo_bin_cgi_2dbin_index_2epl::handler Line: 37
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::handler (v1.99) Line: 32

ERROR: OTOBO-CGI-15 Perl: 5.30.0 OS: linux Time: Mon Jul 12 14:48:44 2021

Message: Invalid value for String: 2017-11-03 11:02:42+00.

RemoteAddress: 193.137.54.7
RequestURI: /otobo/index.pl?Action=AgentTicketQueue

Traceback (29064):
Module: Kernel::System::DateTime::_CPANDateTimeObjectCreate Line: 1827
Module: Kernel::System::DateTime::new Line: 167
Module: Kernel::System::ObjectManager::_ObjectBuild Line: 323
Module: Kernel::System::ObjectManager::Create Line: 254
Module: Kernel::System::Ticket::IndexAccelerator::StaticDB::TicketAcceleratorIndex Line: 526
Module: Kernel::System::Ticket::TicketAcceleratorIndex Line: 7820
Module: Kernel::Modules::AgentTicketQueue::BuildQueueView Line: 546
Module: Kernel::Modules::AgentTicketQueue::Run Line: 476
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1257
Module: ModPerl::ROOT::ModPerl::Registry::opt_otobo_bin_cgi_2dbin_index_2epl::handler Line: 37
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::handler (v1.99) Line: 32

ERROR: OTOBO-CGI-15 Perl: 5.30.0 OS: linux Time: Mon Jul 12 14:48:44 2021

Message: Error creating DateTime object ( ‚String‘ => ‚2017-11-03 11:02:42+00‘ ).

RemoteAddress: 193.137.54.7
RequestURI: /otobo/index.pl?Action=AgentTicketQueue

Traceback (29064):
Module: Kernel::System::DateTime::new Line: 188
Module: Kernel::System::ObjectManager::_ObjectBuild Line: 323
Module: Kernel::System::ObjectManager::Create Line: 254
Module: Kernel::System::Ticket::IndexAccelerator::StaticDB::TicketAcceleratorIndex Line: 526
Module: Kernel::System::Ticket::TicketAcceleratorIndex Line: 7820
Module: Kernel::Modules::AgentTicketQueue::BuildQueueView Line: 546
Module: Kernel::Modules::AgentTicketQueue::Run Line: 476
Module: Kernel::System::Web::InterfaceAgent::Run Line: 1257
Module: ModPerl::ROOT::ModPerl::Registry::opt_otobo_bin_cgi_2dbin_index_2epl::handler Line: 37
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::handler (v1.99) Line: 32

[Mon Jul 12 15:48:44.817310 2021] [:error] [pid 29064] Can’t call method „Delta“ on an undefined value at /opt/otobo/Kernel/System/Ticket/IndexAccelerator/StaticDB.pm line 533.\n

 

Also I’ve tried to export the data after migration, and imported otobo-schema.postgresql.sql, after that the exported sql, and after that otobo-schema-post.postgresql.sql.

 

[Author]

Posts