Error migrating 5.0.42 to 6.0.30

ITLogSupport · Post by **ITLogSupport** » 02 Feb 2021, 12:44

Hello,

I hope you are well and healthy!

I'm migrating OTRS 5.0.42 to 6.0.30 and I'm stuck running scripts/DBUpdate-to-6.pl. This is the output I get:

Code: Select all

scripts/DBUpdate-to-6.pl

 Migration started ...

 Checking requirements ...

    Requirement check for: Check framework version ...
    Requirement check for: Check required Perl version ...
    Requirement check for: Check required database version ...
    Requirement check for: Check database charset ...
    Requirement check for: Check required Perl modules ...
    Requirement check for: Check if database has been backed up ...

        Did you backup the database? [Y]es/[N]o: y

    Requirement check for: Upgrade database structure ...
    Requirement check for: Migrating time zone configuration ...
    Requirement check for: Update calendar appointment future tasks ...
    Requirement check for: Migrate GenericAgent jobs configuration ...
    Requirement check for: Migrate TicketAppointment rules configuration ...
    Requirement check for: Create entries in new article table ...
    Requirement check for: Migrate ArticleType in ProcessManagement Data ...
    Requirement check for: Migrate ArticleType in PostMaster filters ...

 Executing tasks ...

    Step 1 of 44: Check framework version ...
    Step 2 of 44: Check required Perl version ...
    Step 3 of 44: Check required database version ...
    Step 4 of 44: Check database charset ...
    Step 5 of 44: Check required Perl modules ...
    Step 6 of 44: Check installed CPAN modules for known vulnerabilities ...
Collecting all installed modules. This can take a while...
Archive-Zip (requires 1.60) has 1 advisories
  * CPANSA-Archive-Zip-2018-01
    perl-archive-zip is vulnerable to a directory traversal in Archive::Zip. It was found that the Archive::Zip module did not properly sanitize paths while extracting zip files. An attacker able to provide a specially crafted archive for processing could use this flaw to write or overwrite arbitrary files in the context of the perl interpreter.

    Affected range: <1.61

    CVEs: CVE-2018-10860

    References:
    https://security-tracker.debian.org/tracker/CVE-2018-10860
    https://github.com/redhotpenguin/perl-Archive-Zip/pull/33

Total advisories found: 1

    WARNING: CPAN::Audit reported that one or more installed CPAN modules have known vulnerabilities (see above). Please note that there might be false positives for distributions patching Perl modules without changing their version number.

    Step 7 of 44: Check if database has been backed up ...
    Step 8 of 44: Upgrade database structure ...
    Step 9 of 44: Migrate configuration ...
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.26.3 OS: linux Time: Tue Feb 2 09:56:01 2021

 Message: Error serializing data:

 Traceback (30416):
   Module: Kernel::System::Storable::Serialize Line: 87
   Module: Kernel::System::Cache::FileStorable::Set Line: 79
   Module: Kernel::System::Cache::Set Line: 245
   Module: Kernel::System::SysConfig::DB::DefaultSettingListGet Line: 1425
   Module: Kernel::System::SysConfig::_GetSettingsToDeploy Line: 5847
   Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3421
   Module: scripts::DBUpdateTo6::Base::RebuildConfig Line: 94
   Module: scripts::DBUpdateTo6::MigrateConfigEffectiveValues::Run Line: 48
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: scripts/DBUpdate-to-6.pl Line: 87

    Step 10 of 44: Refresh configuration cache after migration of OTRS 5 settings ...
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.26.3 OS: linux Time: Tue Feb 2 09:56:20 2021

 Message: Error serializing data:

 Traceback (30416):
   Module: Kernel::System::Storable::Serialize Line: 87
   Module: Kernel::System::Cache::FileStorable::Set Line: 79
   Module: Kernel::System::Cache::Set Line: 245
   Module: Kernel::System::SysConfig::DB::DefaultSettingListGet Line: 1425
   Module: Kernel::System::SysConfig::_GetSettingsToDeploy Line: 5847
   Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3421
   Module: scripts::DBUpdateTo6::Base::RebuildConfig Line: 94
   Module: scripts::DBUpdateTo6::RebuildConfig::Run Line: 27
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: scripts/DBUpdate-to-6.pl Line: 87

    Step 11 of 44: Migrating ticket storage configuration ...
    Step 12 of 44: Migrating article search index configuration ...
    Step 13 of 44: Migrating ticket zoom customer information widget configuration ...
    Step 14 of 44: Drop deprecated table gi_object_lock_state ...
    Step 15 of 44: Migrate PossibleNextActions setting ...
    Step 16 of 44: Migrate ZoomExpand setting ...
    Step 17 of 44: Migrating time zone configuration ...
    Step 18 of 44: Migrating modified settings ...
    Step 19 of 44: Create appointment calendar tables ...
    Step 20 of 44: Create ticket number counter tables ...
    Step 21 of 44: Update calendar appointment future tasks ...
    Step 22 of 44: Add basic appointment notification for reminders ...
    Step 23 of 44: Create Form Draft tables ...
    Step 24 of 44: Clean and drop group_user permission_value column ...
    Step 25 of 44: Migrate GenericAgent jobs configuration ...
    Step 26 of 44: Migrate TicketAppointment rules configuration ...
    Step 27 of 44: Migrate Merged Ticket history name values ...
    Step 28 of 44: Migrate ticket statistics ...
    Step 29 of 44: Migrate ticket notifications ...
    Step 30 of 44: Create entries in new article table ...
    Step 31 of 44: Post changes on article related tables ...
    Step 32 of 44: Migrate ArticleType in ProcessManagement Data ...
    Step 33 of 44: Migrate ArticleType in PostMaster filters ...
    Step 34 of 44: Migrate chat articles ...
    Step 35 of 44: Initialize default cron jobs ...
    Step 36 of 44: Migrate web service configuration ...
    Step 37 of 44: Migrate package repository configuration ...
    Step 38 of 44: Migrate ticket search profiles ...
    Step 39 of 44: Uninstall Merged Feature Add-Ons ...
    Step 40 of 44: Clean up the cache ...
    Step 41 of 44: Refresh configuration cache another time ...
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.26.3 OS: linux Time: Tue Feb 2 09:56:30 2021

 Message: Error serializing data:

 Traceback (30416):
   Module: Kernel::System::Storable::Serialize Line: 87
   Module: Kernel::System::Cache::FileStorable::Set Line: 79
   Module: Kernel::System::Cache::Set Line: 245
   Module: Kernel::System::SysConfig::DB::DefaultSettingListGet Line: 1425
   Module: Kernel::System::SysConfig::_GetSettingsToDeploy Line: 5847
   Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3421
   Module: scripts::DBUpdateTo6::Base::RebuildConfig Line: 94
   Module: scripts::DBUpdateTo6::RebuildConfigCleanup::Run Line: 27
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: scripts/DBUpdate-to-6.pl Line: 87

    Step 42 of 44: Deploy ACLs ...
    Step 43 of 44: Deploy processes ...
    Step 44 of 44: Check invalid settings ...
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.26.3 OS: linux Time: Tue Feb 2 09:56:32 2021

 Message: Error serializing data:

 Traceback (30416):
   Module: Kernel::System::Storable::Serialize Line: 87
   Module: Kernel::System::Cache::FileStorable::Set Line: 79
   Module: Kernel::System::Cache::Set Line: 245
   Module: Kernel::System::SysConfig::DB::DefaultSettingListGet Line: 1425
   Module: Kernel::System::SysConfig::ConfigurationListGet Line: 3042
   Module: Kernel::System::SysConfig::ConfigurationInvalidList Line: 3229
   Module: scripts::DBUpdateTo6::InvalidSettingsCheck::Run Line: 38
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: scripts/DBUpdate-to-6.pl Line: 87

ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.26.3 OS: linux Time: Tue Feb 2 09:56:38 2021

 Message: Error serializing data: Max. recursion depth with nested structures exceeded at /usr/lib64/perl5/vendor_perl/Storable.pm line 363, at /opt/otrs/Kernel/System/Storable.pm line 82.


 Traceback (30416):
   Module: Kernel::System::Storable::Serialize Line: 87
   Module: Kernel::System::Cache::FileStorable::Set Line: 79
   Module: Kernel::System::Cache::Set Line: 245
   Module: Kernel::System::SysConfig::DB::DefaultSettingListGet Line: 1425
   Module: Kernel::System::SysConfig::ConfigurationListGet Line: 3042
   Module: Kernel::System::SysConfig::ConfigurationInvalidList Line: 3229
   Module: Kernel::System::Console::Command::Admin::Config::FixInvalid::Run Line: 63
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: scripts::DBUpdateTo6::InvalidSettingsCheck::Run Line: 85
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: scripts/DBUpdate-to-6.pl Line: 87

Skipping missing settings for now...

Warning: TimeVacationDaysOneTime::Calendar2 is not an entity value type, skipping...

Following settings were not fixed:
  - TimeVacationDaysOneTime::Calendar2

Please use console command (bin/otrs.Console.pl Admin::Config::Update --help) or GUI to fix them.

Done.



 Migration completed!

Any help would be greatly appreciated.

Thanks in advance.
GAR

zzz · Post by **zzz** » 02 Feb 2021, 16:48

Hello GAR,

It's hard to say what's causing the issue without having more information.

Do you have any error messages in your web server or OTRS log (check for older ones)?
Are your Perl modules up to date (/opt/otrs/bin/otrs.CheckModules.pl)?

It looks like the update was still executed "successfully". Did you find any errors while calling the agent front end?

Best regards
Emin

skullz · Post by **skullz** » 03 Feb 2021, 01:59

If look closer, more to configuration error perhaps?
Do you have any custom xml or perl? You have to convert them first before upgrade.

From the doc

Code: Select all

Note: If you have any custom Perl or XML configuration files in Kernel/Config/Files, these need to be converted to the new formats supported by OTRS 6 before running the migration script.

ITLogSupport · Post by **ITLogSupport** » 04 Feb 2021, 12:02

zzz wrote: ↑02 Feb 2021, 16:48 Hello GAR,

It's hard to say what's causing the issue without having more information.

Do you have any error messages in your web server or OTRS log (check for older ones)?
Are your Perl modules up to date (/opt/otrs/bin/otrs.CheckModules.pl)?

It looks like the update was still executed "successfully". Did you find any errors while calling the agent front end?

Best regards
Emin

Thank you for your answer.

The agent front end opens just fine but AgentTicketZoom fails. I think the problem lies further back. I've restarted the migration process and I'm getting this error:

Code: Select all

Warning: Ticket::Frontend::AgentTicketZoom###DynamicField is not an entity value type, skipping...

Following settings were not fixed:
  - Ticket::Frontend::AgentTicketZoom###DynamicField

Please use console command (bin/otrs.Console.pl Admin::Config::Update --help) or GUI to fix them.

We do use Dynamic Fields.

How can I know which dynamic field is causing the problem?

Thank you very much!
Kind regards,
GAR

ITLogSupport · Post by **ITLogSupport** » 04 Feb 2021, 12:03

skullz wrote: ↑03 Feb 2021, 01:59 If look closer, more to configuration error perhaps?
Do you have any custom xml or perl? You have to convert them first before upgrade.

From the doc
Code: Select all
Note: If you have any custom Perl or XML configuration files in Kernel/Config/Files, these need to be converted to the new formats supported by OTRS 6 before running the migration script.

Thank you for your answer.

We don't use any custom Perl or XML configuration files. I've restarted the migration process and I'm getting this error:

Code: Select all

Warning: Ticket::Frontend::AgentTicketZoom###DynamicField is not an entity value type, skipping...

Following settings were not fixed:
  - Ticket::Frontend::AgentTicketZoom###DynamicField

Please use console command (bin/otrs.Console.pl Admin::Config::Update --help) or GUI to fix them.

We do use Dynamic Fields.

How can I know which dynamic field is causing the problem?

Thank you very much!
Kind regards,
GAR

zzz · Post by **zzz** » 04 Feb 2021, 12:15

Hello,

Try to reset the setting in the system configuration and reapply your own changes.

— Emin

ITLogSupport · Post by **ITLogSupport** » 17 Feb 2021, 14:05

Hello,

I hope everyone is well.

I've managed to correct the Dynamic field errors and the migration process completed without errors, nevertheless, it still crashes when I zoom in a ticket.

This is what I get in Apache logs:

Code: Select all

 RequestURI: /otrs/index.pl?Action=AgentDashboard

 Traceback (68021): 
   Module: Kernel::System::Stats::GetObjectBehaviours Line: 1129
   Module: Kernel::System::Stats::StatsGet Line: 272
   Module: Kernel::System::Stats::StatsListGet Line: 744
   Module: Kernel::Modules::AgentDashboardCommon::Run Line: 67
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1135
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 38
   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

[Wed Feb 17 11:25:43.540137 2021] [:error] [pid 68021:tid 139761272461056] Can't call method "FatalError" on an undefined value at /opt/otrs/Kernel/Modules/AgentTicketZoom.pm line 41.\n
ERROR: OTRS-CGI-10 Perl: 5.26.3 OS: linux Time: Wed Feb 17 11:28:14 2021

 Message: Attempt to reload Kernel/System/Stats/Static/FAQAccess.pm aborted.
Compilation failed in require at /opt/otrs/Kernel/System/Main.pm line 85.


 RemoteAddress:
 RequestURI: /otrs/index.pl?Action=AgentDashboard

 Traceback (68021): 
   Module: Kernel::System::Stats::GetObjectBehaviours Line: 1129
   Module: Kernel::System::Stats::StatsGet Line: 272
   Module: Kernel::System::Stats::StatsListGet Line: 744
   Module: Kernel::Modules::AgentDashboardCommon::Run Line: 67
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1135
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 38
   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

[Wed Feb 17 11:28:19.818469 2021] [:error] [pid 68021:tid 139761205319424] Can't call method "FatalError" on an undefined value at /opt/otrs/Kernel/Modules/AgentTicketZoom.pm line 41.\n

Any ideas?

Thank you very much.

Keep safe.
GAR

zzz · Post by **zzz** » 17 Feb 2021, 17:42

Could you show us a screenshot of your package manager (admin area)?

Best regards
Emin

ITLogSupport · Post by **ITLogSupport** » 17 Feb 2021, 18:38

zzz wrote: ↑17 Feb 2021, 17:42 Could you show us a screenshot of your package manager (admin area)?

Best regards
Emin

Here is the screenshot:
https://cloud.urbanos.com/index.php/s/kPSXbD34qn50PIj

zzz · Post by **zzz** » 17 Feb 2021, 18:50

The numbers look fine. Check your permissions, your web server configuration and remove the iPhone Handler.
Looks like you had a similar problem with your last upgrade: https://forums.otterhub.org/viewtopic.php?t=30403

— Emin

skullz · Post by **skullz** » 18 Feb 2021, 04:08

Are u using .rpm to upgrade?

Try to reinstall the .rpm

Code: Select all

rpm --install --force otrs-6.0.xx.noarch.rpm

Then go to package manager > reinstall any uncorrect installed addon.

Somehow, during upgrade via rpm and update ITSM, its restore back old file. (Theory only

)

ITLogSupport · Post by **ITLogSupport** » 19 Feb 2021, 16:07

zzz wrote: ↑17 Feb 2021, 18:50 The numbers look fine. Check your permissions, your web server configuration and remove the iPhone Handler.
Looks like you had a similar problem with your last upgrade: https://forums.otterhub.org/viewtopic.php?t=30403

— Emin

Hello,

Thank you for you answer.

I've check the permissions and removed iPhone Handler. My web server configuration hasn't changed after the upgrade. Still no luck.

Post by **root** » 19 Feb 2021, 16:24

Hi,

Please show the output of

Code: Select all

ls -l /opt/otrs/Kernel/Modules/AgentTicketZoom*

- Roy

ITLogSupport · Post by **ITLogSupport** » 19 Feb 2021, 19:17

skullz wrote: ↑18 Feb 2021, 04:08 Are u using .rpm to upgrade?

Try to reinstall the .rpm
Code: Select all
rpm --install --force otrs-6.0.xx.noarch.rpm
Then go to package manager > reinstall any uncorrect installed addon.

Somehow, during upgrade via rpm and update ITSM, its restore back old file. (Theory only )

Hello,

This solved it! Thank you very much for your help!!

Znuny and ((OTRS)) Community Edition

Error migrating 5.0.42 to 6.0.30

Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30

Re: Error migrating 5.0.42 to 6.0.30