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.