Kernel::System::Ticket::Number::Date autoincrement counter not working

Moderator: crythias

Post Reply
jbaptiste
OTRS advanced
Posts: 103
Joined: 01 Aug 2015, 03:45
OTRS Version?: 6.0.x
Contact:

Kernel::System::Ticket::Number::Date autoincrement counter not working

Post by jbaptiste »

Hi,

I have the ticket counter set as Kernel::System::Ticket::Number::Date autoincrement, but is not working as documented, the counter is being restarted daily, but that is how DateChecksum works, as I understand it Date should have a "global" counter that is not reset:
Selects the ticket number generator module. "AutoIncrement" increments the ticket number, the SystemID and the counter are used with SystemID.counter format (e.g. 1010138, 1010139). With "Date" the ticket numbers will be generated by the current date, the SystemID and the counter. The format looks like Year.Month.Day.SystemID.counter (e.g. 200206231010138, 200206231010139). With "DateChecksum" the counter will be appended as checksum to the string of date and SystemID. The checksum will be rotated on a daily basis. The format looks like Year.Month.Day.SystemID.Counter.CheckSum (e.g. 2002070110101520, 2002070110101535).
Is my understanding correct ?
Want to run OTRS on docker ? checkout my OTRS on docker HOWTO | Project's github page

root
Administrator
Posts: 2563
Joined: 18 Dec 2007, 12:23
OTRS Version?: Znuny LTS and 4/5/6
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Kernel::System::Ticket::Number::Date autoincrement counter not working

Post by root »

Hello,

The OTRS AG changed the behaviour of this generator with version 6. Before version 6 the counter works like described, with version 6 they changed the behaviour to a daily reset.

No need to file a bug at bugs.otrs.org, they probably won't fix it. If you believe it's a framework bug you may file it here: https://github.com/znuny/Znuny/issues/

- Roy
Znuny LTS and ((OTRS) Community Edition CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

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

Do you want to contribute or want to know why ?

jbaptiste
OTRS advanced
Posts: 103
Joined: 01 Aug 2015, 03:45
OTRS Version?: 6.0.x
Contact:

Re: Kernel::System::Ticket::Number::Date autoincrement counter not working

Post by jbaptiste »

Well then it clearly is a bug as Date is behaving as DateChecksum, and current documentation say they behave differently. Where the bug lies ? I don't know if it is a framework issue or what, if it makes sense to report it on https://github.com/znuny/Znuny/issues/ I will.
Want to run OTRS on docker ? checkout my OTRS on docker HOWTO | Project's github page

root
Administrator
Posts: 2563
Joined: 18 Dec 2007, 12:23
OTRS Version?: Znuny LTS and 4/5/6
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Kernel::System::Ticket::Number::Date autoincrement counter not working

Post by root »

jbaptiste wrote:
15 Jan 2021, 21:36
Well then it clearly is a bug as Date is behaving as DateChecksum, and current documentation say they behave differently. Where the bug lies ? I don't know if it is a framework issue or what, if it makes sense to report it on https://github.com/znuny/Znuny/issues/ I will.
Hi,

The problem is in the file Kernel/System/Ticket/Number/Date.pm in the sub IsDateBase which returns 1 instead of 0.

I'm not able to decide if it's a framework bug or not, but it's worth a shot to find out.

- Roy
Znuny LTS and ((OTRS) Community Edition CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

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

Do you want to contribute or want to know why ?

jbaptiste
OTRS advanced
Posts: 103
Joined: 01 Aug 2015, 03:45
OTRS Version?: 6.0.x
Contact:

Re: Kernel::System::Ticket::Number::Date autoincrement counter not working

Post by jbaptiste »

Excellent, let me know if you need me to open an issue, I will gladly do it.
Want to run OTRS on docker ? checkout my OTRS on docker HOWTO | Project's github page

bah
OTRS newbie
Posts: 6
Joined: 19 Feb 2019, 17:59
OTRS Version?: 6.0.30
Real Name: Arne

Re: Kernel::System::Ticket::Number::Date autoincrement counter not working

Post by bah »

I'm having similar issues.
Only the counter is not reset daily, it happens once in a while.
Also, some numbers are just not being used. (eg. where the last number is 80 or 90)
tickets_79.png
tickets_81.png
You do not have the required permissions to view the files attached to this post.
OTRS 6.0.x (private/testing) on Linux with MySQL database.

Post Reply