Error upgrading from 6.4.5 to 6.5.1

Moderator: crythias

Post Reply
giacomos
Znuny newbie
Posts: 12
Joined: 28 Sep 2022, 14:51
Znuny Version: 6.0.38
Real Name: Giacomo

Error upgrading from 6.4.5 to 6.5.1

Post by giacomos »

Hi, I have an issue when upgrading from 6.4.5 to 6.5.1.
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)!
The error arise twice, in the following steps:

- 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
What can I do to resolve this issue?

---

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.
skullz
Znuny superhero
Posts: 621
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Error upgrading from 6.4.5 to 6.5.1

Post by skullz »

Can you check value of

Ticket::Frontend::AgentTicketNoteToLinkedTicket###LinkedTicketStateDefault
Reedu
Znuny newbie
Posts: 31
Joined: 11 Mar 2013, 15:08
Znuny Version: Znuny 6.1.2
Real Name: Adam

Re: Error upgrading from 6.4.5 to 6.5.1

Post by Reedu »

Hi
I've got too problem with upate from 6.4.5 to 6.5.1.
In my example i've done update from:
6.2.2 -> 6.3.1 -> 6.3.4 (as stated in doc's) -> 6.4.5 -> 6.5.1 (failed)
You've got error with LinkedTicketStateDefault , and mine problem was with PriorityDefault
Ticket::Frontend::AgentTicketNoteToLinkedTicket###PriorityDefault which were set to "3 normal"

For me it looks that integrating AgentTicketNoteToLinkedTicket didn't ended up well :)
When i list invalid system configuration (./bin/otrs.Console.pl Admin::Config::ListInvalid) only this PriorityDefault were showing.
So i thought that maybe it's was trying to translate values?
What i'd to do was to set proper value.

Try to do ./bin/otrs.Console.pl Admin::Config::FixInvalid then re-run migrate script
root
Administrator
Posts: 3961
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Error upgrading from 6.4.5 to 6.5.1

Post by root »

HI,
Reedu wrote: 11 Apr 2023, 15:56 Hi
I've got too problem with upate from 6.4.5 to 6.5.1.
In my example i've done update from:
6.2.2 -> 6.3.1 -> 6.3.4 (as stated in doc's) -> 6.4.5 -> 6.5.1 (failed)
You've got error with LinkedTicketStateDefault , and mine problem was with PriorityDefault
Ticket::Frontend::AgentTicketNoteToLinkedTicket###PriorityDefault which were set to "3 normal"

For me it looks that integrating AgentTicketNoteToLinkedTicket didn't ended up well :)
When i list invalid system configuration (./bin/otrs.Console.pl Admin::Config::ListInvalid) only this PriorityDefault were showing.
So i thought that maybe it's was trying to translate values?
What i'd to do was to set proper value.
The problem is not the integration of the add-on. It's because the default values for priority and sometimes state are not existing anymore. This happens with all configurations that expect default entities in the system.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
giacomos
Znuny newbie
Posts: 12
Joined: 28 Sep 2022, 14:51
Znuny Version: 6.0.38
Real Name: Giacomo

Re: Error upgrading from 6.4.5 to 6.5.1

Post by giacomos »

skullz wrote: 11 Apr 2023, 15:47 Can you check value of

Ticket::Frontend::AgentTicketNoteToLinkedTicket###LinkedTicketStateDefault
I changed in file ./Config/Files/ZZZAAuto.pm the following line

Code: Select all

$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'LinkedTicketStateDefault'} =  'open';
from 'open' to 'Aperto'; (our language is Italian)

I ran again `sudo -u otrs /opt/otrs/scripts/MigrateToZnuny6_5.pl`
and I got an error about another variable:

Code: Select all

Message: Setting Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault Effective value is not correct: Entity value is invalid(open)!
So I opened again ./Config/Files/ZZZAAuto.pm and changed also

Code: Select all

$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'StateDefault'} =  'open';
from 'open' to 'Aperto'

But when I ran again `sudo -u otrs /opt/otrs/scripts/MigrateToZnuny6_5.pl`,
I got the same previous error message regarding AgentTicketNoteToLinkedTicket###StateDefault invalid:

Code: Select all

Message: Setting Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault Effective value is not correct: Entity value is invalid(open)!
So I realized that the ./Config/Files/ZZZAAuto.pm has been overwritten like this:

Code: Select all

$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'LinkedTicketStateDefault'} =  'Nuovo';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'StateDefault'} =  'open';
- 'LinkedTicketStateDefault' from 'Aperto' became 'Nuovo' (which appears to be valid) and
- 'StateDefault' from 'Aperto' became 'open' (while this one seems invalid)

Apparently I am tweaking variables in the wrong place.
Where do I have to change values?
skullz
Znuny superhero
Posts: 621
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Error upgrading from 6.4.5 to 6.5.1

Post by skullz »

To check, as otrs user,

Code: Select all

bin/otrs.Console.pl Admin::Config::Read --setting-name Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault
To update as otrs user,

Code: Select all

bin/otrs.Console.pl Admin::Config::Update --setting-name Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault TICKET_STATE_NAME
giacomos
Znuny newbie
Posts: 12
Joined: 28 Sep 2022, 14:51
Znuny Version: 6.0.38
Real Name: Giacomo

Re: Error upgrading from 6.4.5 to 6.5.1

Post by giacomos »

Thank you skullz, I managed to fix invalid setting values by issuing:

Code: Select all

sudo -u otrs bin/otrs.Console.pl Admin::Config::Update --setting-name Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault --value Aperto
ivanmarrese
Znuny newbie
Posts: 4
Joined: 07 Sep 2023, 15:51
Znuny Version: 6.4.5
Real Name: Ivan
Company: Directa

Re: Error upgrading from 6.4.5 to 6.5.1

Post by ivanmarrese »

Hi,

We are facing the same problem that Giacomo had but with a significant difference.
We completely miss all “Ticket::Frontend::AgentTicketNoteToLinkedTicket” settings in our System Configuration.
I mean :

Code: Select all

Ticket::Frontend::AgentTicketNoteToLinkedTicket###Body
Ticket::Frontend::AgentZnunyNoteToLinkedTicket###HistoryComment
Ticket::Frontend::AgentZnunyNoteToLinkedTicket###HistoryType
.
.
Could anyone explain how to import those items into my Znuny.
Is there a module containing all of them?
Before the upgrade procedure from 6.4 to 6.5 there’s no file named AgentTicketNoteToLinkedTicket.pm in /opt/…
After the procedure it appears right here:

Code: Select all

./znuny-6.5.4/Kernel/Output/HTML/ArticleAction/AgentTicketNoteToLinkedTicket.pm
./znuny-6.5.4/Kernel/Modules/AgentTicketNoteToLinkedTicket.pm
During the upgrade we receive errors obviously..

Code: Select all

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: Upgrade database structure ...
    Requirement check for: Migrate SysConfig settings ...

        Should the SysConfig be migrated? [Y]es/[N]o: y


 Executing tasks ... 

    Step 1 of 21: Check required Perl version ...
    Step 2 of 21: Check required database version ...
    Step 3 of 21: Check database charset ...
    Step 4 of 21: Check required Perl modules ...
    Step 5 of 21: Check if database has been backed up ...
    Step 6 of 21: Upgrade database structure ...
    Step 7 of 21: Rebuild configuration ...
    Step 8 of 21: Migrate SysConfig settings ...
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-01 Perl: 5.32.1 OS: linux Time: Thu Sep 14 15:55:09 2023

 Message: EffectiveValue is invalid! Entity value is invalid(open)!

 Traceback (49139): 
   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: scripts/MigrateToZnuny6_5.pl Line: 82

ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-01 Perl: 5.32.1 OS: linux Time: Thu Sep 14 15:55:09 2023

 Message: EffectiveValue is invalid! Entity value is invalid(open)!

 Traceback (49139): 
   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: scripts/MigrateToZnuny6_5.pl Line: 82

ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-01 Perl: 5.32.1 OS: linux Time: Thu Sep 14 15:55:10 2023

 Message: Setting Ticket::Frontend::AgentTicketNoteToLinkedTicket###LinkedTicketStateDefault Effective value is not correct: Entity value is invalid(open)!

 ….

 Not possible to complete migration. Check previous messages for more information.
So…We are currently stuck at version 6.4.5 (i would like to get to 7.x, one day...)

I hope some of you can help me

Ivan
skullz
Znuny superhero
Posts: 621
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Error upgrading from 6.4.5 to 6.5.1

Post by skullz »

Do you try running the config update as latest giacomo post?
ivanmarrese
Znuny newbie
Posts: 4
Joined: 07 Sep 2023, 15:51
Znuny Version: 6.4.5
Real Name: Ivan
Company: Directa

Re: Error upgrading from 6.4.5 to 6.5.1

Post by ivanmarrese »

skullz wrote: 15 Sep 2023, 10:31 Do you try running the config update as latest giacomo post?
yes and I get

Code: Select all

bin/otrs.Console.pl Admin::Config::Read --setting-name Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault
Gathering setting value...
Setting: Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault
open
Done.
The value "open" shold be the right one because we've never used/changed it..
neverthless when i re-run (as otrs user)

Code: Select all

scripts/MigrateToZnuny6_5.pl
i get

Code: Select all

Message: Setting Ticket::Frontend::AgentTicketNoteToLinkedTicket###LinkedTicketStateDefault Effective value is not correct: Entity value is invalid(open)!
Notice that

Code: Select all

grep "AgentTicketNoteToLinkedTicket" ./Kernel/Config/Files/XML/Ticket.xml 
                <Item Key="AgentTicketNoteToLinkedTicket">
                        <Item Key="Module">Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket</Item>
                <Item Key="AgentTicketNoteToLinkedTicket">
                        <Item Key="Module">Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket</Item>
                <Item Key="AgentTicketNoteToLinkedTicket">
                        <Item Key="Module">Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket</Item>
                <Item Key="AgentTicketNoteToLinkedTicket">
                        <Item Key="Module">Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket</Item>
and

Code: Select all

grep "AgentTicketNoteToLinkedTicket" ./Kernel/Config/Files/ZZZAAuto.pm 
$Self->{'Frontend::Module'}->{'AgentTicketNoteToLinkedTicket'} =  {
$Self->{'Loader::Module::AgentTicketNoteToLinkedTicket'}->{'001-NoteToLinkedTicket'} =  {
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Body'} =  '';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'HistoryComment'} =  '%%NoteToLinkedTicket';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'HistoryType'} =  'AddNote';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'IsVisibleForCustomerDefault'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'LinkedTicketState'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'LinkedTicketStateDefault'} =  'open';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Note'} =  '1';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'NoteMandatory'} =  '1';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'NoteToTicket'} =  '1';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'NoteToTicketDefault'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Owner'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'OwnerMandatory'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Permission'} =  'note';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Priority'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'PriorityDefault'} =  '3 normal';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Queue'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Responsible'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'SLAMandatory'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Service'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'ServiceMandatory'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'State'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'StateDefault'} =  'open';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'StateType'} =  [
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Subject'} =  '';
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'TicketType'} =  0;
$Self->{'Ticket::Frontend::AgentTicketNoteToLinkedTicket'}->{'Title'} =  0;
  'AgentTicketNoteToLinkedTicket' => {
    'Module' => 'Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket',
  'AgentTicketNoteToLinkedTicket' => {
    'Module' => 'Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket',
  'AgentTicketNoteToLinkedTicket' => {
    'Module' => 'Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket',
  'AgentTicketNoteToLinkedTicket' => {
    'Module' => 'Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket',
  'AgentTicketNoteToLinkedTicket' => {
    'Module' => 'Kernel::Output::HTML::ArticleAction::AgentTicketNoteToLinkedTicket',
Maybe I've missed something in the previous upgrades. We have a Znuny 6.4 in production that works really fine. And i'm doing test in Znuny/test environment just to be able to switch to the version 6.5.
A little confused :(
KaiHerlemann
Znuny Employee
Posts: 10
Joined: 15 Apr 2022, 20:34
Znuny Version: 6.4
Real Name: Kai Herlemann
Company: Znuny

Re: Error upgrading from 6.4.5 to 6.5.1

Post by KaiHerlemann »

Hi,

to solve this issue, please run in the Znuny home directory the following command:

Code: Select all

bin/otrs.Console.pl Maint::Config::Rebuild --cleanup
Then execute the upgrade script again.

@giacomos:
in the file ./Config/Files/ZZZAAuto.pm are your current settings saved - to change this file to change settings won't help!
For example, if you deploy your system configuration, this file will be automatically changed. It will be also changed if your rebuild your system configuration. If you migrate to another Znuny version, it will be always rebuilt too.
Because of this you see in the upgrade log

Code: Select all

Step 6 of 18: Rebuild configuration ...
skullz
Znuny superhero
Posts: 621
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Error upgrading from 6.4.5 to 6.5.1

Post by skullz »

Nothing to worry about the new files..its a new features integrated in 6.5.

how about this? what the response ?

Code: Select all

bin/otrs.Console.pl Admin::Config::Read --setting-name Ticket::Frontend::AgentTicketPhone###StateDefault
ivanmarrese
Znuny newbie
Posts: 4
Joined: 07 Sep 2023, 15:51
Znuny Version: 6.4.5
Real Name: Ivan
Company: Directa

Re: Error upgrading from 6.4.5 to 6.5.1

Post by ivanmarrese »

skullz wrote: 15 Sep 2023, 15:24 Nothing to worry about the new files..its a new features integrated in 6.5.

how about this? what the response ?

Code: Select all

bin/otrs.Console.pl Admin::Config::Read --setting-name Ticket::Frontend::AgentTicketPhone###StateDefault
What I got is:

Code: Select all

otrs@otrs:~$ bin/otrs.Console.pl Admin::Config::Read --setting-name Ticket::Frontend::AgentTicketPhone###StateDefault
Gathering setting value...

Setting: Ticket::Frontend::AgentTicketPhone###StateDefault
assigned

Done.
skullz
Znuny superhero
Posts: 621
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Error upgrading from 6.4.5 to 6.5.1

Post by skullz »

then try to use 'assigned' instead of open

Code: Select all

bin/otrs.Console.pl Admin::Config::Update --setting-name Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault --value assigned
then reexecute the migration script
or follow KaiHerlemann recommendation
ivanmarrese
Znuny newbie
Posts: 4
Joined: 07 Sep 2023, 15:51
Znuny Version: 6.4.5
Real Name: Ivan
Company: Directa

Re: Error upgrading from 6.4.5 to 6.5.1

Post by ivanmarrese »

KaiHerlemann wrote: 15 Sep 2023, 15:19 Hi,

to solve this issue, please run in the Znuny home directory the following command:

Code: Select all

bin/otrs.Console.pl Maint::Config::Rebuild --cleanup
Then execute the upgrade script again.

@giacomos:
in the file ./Config/Files/ZZZAAuto.pm are your current settings saved - to change this file to change settings won't help!
For example, if you deploy your system configuration, this file will be automatically changed. It will be also changed if your rebuild your system configuration. If you migrate to another Znuny version, it will be always rebuilt too.
Because of this you see in the upgrade log

Code: Select all

Step 6 of 18: Rebuild configuration ...
Ok let's rebuild --> Error: There was a problem writing ZZZAAuto.pm

Code: Select all

otrs@otrs:/opt/znuny-6.5.4$ bin/otrs.Console.pl Maint::Config::Rebuild --cleanup
Rebuilding the system configuration...
ERROR: OTRS-otrs.Console.pl-Maint::Config::Rebuild-01 Perl: 5.32.1 OS: linux Time: Fri Sep 15 13:53:38 2023

 Message: Setting Ticket::Frontend::AgentTicketNoteToLinkedTicket###LinkedTicketStateDefault Effective value is not correct: Entity value is invalid(open)!

 Traceback (3069): 
   Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3488
   Module: Kernel::System::Console::Command::Maint::Config::Rebuild::Run Line: 138
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: bin/otrs.Console.pl Line: 37

Error: There was a problem writing ZZZAAuto.pm.
i also changed the value with an error

Code: Select all

otrs@otrs:/opt/znuny-6.5.4$ bin/otrs.Console.pl Admin::Config::Update --setting-name Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault --value assigned
Updating setting value...

ERROR: OTRS-otrs.Console.pl-Admin::Config::Update-01 Perl: 5.32.1 OS: linux Time: Fri Sep 15 14:01:49 2023

 Message: Setting Ticket::Frontend::AgentTicketNoteToLinkedTicket###LinkedTicketStateDefault Effective value is not correct: Entity value is invalid(open)!

 Traceback (3093): 
   Module: Kernel::System::SysConfig::ConfigurationDeploy Line: 3488
   Module: Kernel::System::Console::Command::Admin::Config::Update::Run Line: 234
   Module: (eval) Line: 461
   Module: Kernel::System::Console::BaseCommand::Execute Line: 455
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 81
   Module: bin/otrs.Console.pl Line: 37

Error: Deployment failed!
But the value has changed in some way...

Code: Select all

otrs@otrs:/opt/znuny-6.5.4$ bin/otrs.Console.pl Admin::Config::Read --setting-name Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault
Gathering setting value...

Setting: Ticket::Frontend::AgentTicketNoteToLinkedTicket###StateDefault
assigned

Done.
Folder/file permission

Code: Select all

otrs@otrs:/opt/znuny-6.5.4/Kernel/Config/Files$ ls -al
total 368
drwxrwsr-x 3 otrs www-data   4096 Sep 15 16:09 .
drwxrwsr-x 4 otrs www-data   4096 Sep 15 12:36 ..
drwxrwsr-x 2 otrs www-data   4096 Sep 15 13:05 XML
-rw-rw---- 1 otrs www-data 363194 Sep 15 16:09 ZZZAAuto.pm
skullz
Znuny superhero
Posts: 621
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Error upgrading from 6.4.5 to 6.5.1

Post by skullz »

Code: Select all

re-execute the migration script
Post Reply