My issue seems similar to
viewtopic.php?f=62&t=43558 although I
don't think it is related to addons or packages. The only package
that I have installed is SystemMonitoring (currently version 6.4.3).
I have successfully upgraded my znuny installation from 6.0.39
- to 6.0.48
- to 6.1.2
- to 6.2.1
- to 6.3.4
- to 6.4.5
But when I tried to upgrade to 6.5.1, when issuing the command
"MigrateToZnuny6_5.pl", I ran into the following error:
Code: Select all
Message: EffectiveValue is invalid! Entity value is invalid(open)!
- Step 7 of 18: Migrate SysConfig settings ...
- Step 11 of 18: Integrate Znuny-NoteToLinkedTicket ...
The second error appears to be fatal, aborting the migration.
I selected "Yes" to both questions
- Did you backup the database? [Y]es/[N]o: Y
- Should the SysConfig be migrated? [Y]es/[N]o: Y
The OS I am using is Ubuntu 22.
All updates that I made where source updates.
If I start again apache I can see the web application apparently up
and running. I can see existing tickets and I am able to open new
ones.
In SysConfig, under Core -> Ticket, the state "open" appears under the
following settings:
Code: Select all
- Ticket::UnlockStateType
- new
- open
- Ticket::ViewableStateType
- new
- open
- pending reminder
- pending auto
- Ticket::InvalidOwner::StateChange
- pending auto -> open
- pending reminder -> open
---
PS: Full log is:
Code: Select all
$ sudo su -c "/opt/otrs/scripts/MigrateToZnuny6_5.pl" -s /bin/bash otrs
Migration started ...
Checking requirements ...
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: Migrate SysConfig settings ...
Should the SysConfig be migrated? [Y]es/[N]o: Y
Executing tasks ...
Step 1 of 18: Check required Perl version ...
Step 2 of 18: Check required database version ...
Step 3 of 18: Check database charset ...
Step 4 of 18: Check required Perl modules ...
Step 5 of 18: Check if database has been backed up ...
Step 6 of 18: Rebuild configuration ...
Step 7 of 18: Migrate SysConfig settings ...
ERROR: MigrateToZnuny6_5.pl-26 Perl: 5.36.0 OS: linux Time: Tue Apr 11 10:44:16 2023
Message: EffectiveValue is invalid! Entity value is invalid(open)!
Traceback (31206):
Module: Kernel::System::SysConfig::SettingUpdate Line: 512
Module: Kernel::System::SysConfig::SettingsSet Line: 4731
Module: Kernel::System::SysConfig::Migration::MigrateSysConfigSettings Line: 367
Module: scripts::Migration::Znuny::MigrateSysConfigSettings::Run Line: 224
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/otrs/scripts/MigrateToZnuny6_5.pl Line: 82
ERROR: MigrateToZnuny6_5.pl-26 Perl: 5.36.0 OS: linux Time: Tue Apr 11 10:44:17 2023
Message: EffectiveValue is invalid! Entity value is invalid(open)!
Traceback (31206):
Module: Kernel::System::SysConfig::SettingUpdate Line: 512
Module: Kernel::System::SysConfig::SettingsSet Line: 4731
Module: Kernel::System::SysConfig::Migration::MigrateSysConfigSettings Line: 367
Module: scripts::Migration::Znuny::MigrateSysConfigSettings::Run Line: 224
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/otrs/scripts/MigrateToZnuny6_5.pl Line: 82
ERROR: MigrateToZnuny6_5.pl-26 Perl: 5.36.0 OS: linux Time: Tue Apr 11 10:44:18 2023
Message: Setting Ticket::Frontend::AgentTicketNoteToLinkedTicket###LinkedTicketStateDefault Effective value is not correct: Entity value is invalid(open)!
Traceback (31206):
Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3488
Module: Kernel::System::SysConfig::SettingsSet Line: 4742
Module: Kernel::System::SysConfig::Migration::MigrateSysConfigSettings Line: 367
Module: scripts::Migration::Znuny::MigrateSysConfigSettings::Run Line: 224
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/otrs/scripts/MigrateToZnuny6_5.pl Line: 82
Step 8 of 18: Migrate DBCRUD UUID columns ...
Calendar::Plugin: Column dbcrud_uuid in table calendar_appointment_plugin...
Column already exists
OAuth2Token: Column dbcrud_uuid in table oauth2_token...
Column already exists
OAuth2TokenConfig: Column dbcrud_uuid in table oauth2_token_config...
Column already exists
Step 9 of 18: Migrate dynamic fields ...
Step 10 of 18: Migrate notification events ...
Step 11 of 18: Integrate Znuny-NoteToLinkedTicket ...
ERROR: MigrateToZnuny6_5.pl-26 Perl: 5.36.0 OS: linux Time: Tue Apr 11 10:44:19 2023
Message: Setting Ticket::Frontend::AgentTicketNoteToLinkedTicket###LinkedTicketStateDefault Effective value is not correct: Entity value is invalid(open)!
Traceback (31206):
Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3488
Module: Kernel::System::SysConfig::SettingsSet Line: 4742
Module: scripts::Migration::Znuny::IntegrateZnunyNoteToLinkedTicket::_ArticleActionConfigAdd Line: 60
Module: scripts::Migration::Znuny::IntegrateZnunyNoteToLinkedTicket::Run Line: 33
Module: scripts::Migration::_ExecuteComponent Line: 167
Module: scripts::Migration::Run Line: 77
Module: /opt/otrs/scripts/MigrateToZnuny6_5.pl Line: 82
Not possible to complete migration. Check previous messages for more information.