Upgrade OTRS 4 to 5 errors

[galaxis]

Hello,

I must upgrade my Otrs v4.0.16-01 to 5.0.7-01 on a CentOS server 6.7.
My database server got the mysql-server-5.1.73 version. All tables are InnoDB, I also modify my "my.cnf" file to make this storage engine as default.

I've launched the scripts to test my DB and modules required ( ALL ok ) but during the database upgrade step with the script "DBUpdate-to-5.pl", I've got this error :

Code: Select all

Step 12 of 17: Fixup statistics time field configuration where the time interval is too small...
Updated statistic 10 (Astreinte by queues).
Updated statistic 2 (New Tickets by queues).
Updated statistic 5 (Closed tickets by queues).
ERROR: OTRS-DBUpdate-to-5.pl-01 Perl: 5.10.1 OS: linux Time: Fri Mar  4 11:03:11 2016

 Message: _TimeInSeconds: Need TimeUnit!

 Traceback (2302):
   Module: Kernel::Output::HTML::Statistics::View::_TimeInSeconds Line: 2432
   Module: Kernel::Output::HTML::Statistics::View::StatsConfigurationValidate Line: 1815
   Module: main::_FixupStatsTimeInterval Line: 2027
   Module: scripts/DBUpdate-to-5.pl Line: 162

ERROR: OTRS-DBUpdate-to-5.pl-01 Perl: 5.10.1 OS: linux Time: Fri Mar  4 11:03:11 2016

 Message: _TimeInSeconds: Need TimeUnit!

 Traceback (2302):
   Module: Kernel::Output::HTML::Statistics::View::_TimeInSeconds Line: 2432
   Module: main::__ANON__ Line: 1964
   Module: main::_FixupStatsTimeInterval Line: 2035
   Module: scripts/DBUpdate-to-5.pl Line: 162

done.

I have no ideas where to begin to fix this.
Do you have any clues? maybe someone already encountered this problem

Just in case this is my version of perl : perl-5.10.1-141.el6_7.1.x86_64


Thanks in advance
Best regards,

Alexis.

[blastik]

I would try to go through all the stats i've created and put wider time values ?

[galaxis]

I would try to go through all the stats i've created and put wider time values ?

Could you please explain more ? I don't undertand what you want to say by put wider time values

Thanks.

[blastik]

I would try to go through all the stats i've created and put wider time values ?

Could you please explain more ? I don't undertand what you want to say by put wider time values

Thanks.

Try to export all the stats. Delete them. Do upgrade. Import them.
Looks like the upgrade script doesnt like some of the values set in the stats configured in your system.

[galaxis]

Hello blastik,

I didn't see the notification of your response.. sorry about that.
It could be a good idea, i'll test that and i'll tell you if yes or no it was such a good idea !!

Thanks,
Alexis

[galaxis]

Omg you had right !!

We had an stat which wasn't configured properly.
Once I removed it, everything worked perfectly !
Thanks for your help

I have absolutely no ideas on how I can put in resolve this thread .. If a moderator could see that and do this for me, it will be nice.
Thanks in advance