cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Helpdesk_OCMW
Engaged Sweeper
Hi,

We've noticed that the ticket ID counter is not working correctly.

For some reason, there are gaps in the numbering of the ticket IDs in our system.
Last time this happened was Tuesday/Wednesday this week: last ticket Tuesdaynight was #8597,
first ticket Wednesdaymorning was #9595.

This happened a few times before but now it is getting out of hand.
We have made about 5.5k tickets in our helpdesk system, but our latest assigned tickets get IDs from 9600 and counting.

What causes the numbering to create this leap in the numbering?

Thanks for your help.

Maxim
2 REPLIES 2
Helpdesk_OCMW
Engaged Sweeper
Thanks for you answer, Karel.
I've passed this on to our system engineers, the startup parameter has been added.

Fingers crossed, ofcourse there's no way of knowing for sure it won't happen again.
If it doesn't in the next few months, I'll mark your post as a solution.

Regards, Maxim.
Karel_DS
Champion Sweeper III
This might be due to a feature MSSQL Server 2012 introduced called sequences. Whenever MSSQL Server gets turned off it automagially increments identity counters by 10000. Since this identity is used for ticket IDs those get a +10000 as well.

The following link proposed a solution to this problem: https://www.codeproject.com/Tips/668042/SQL-Server-2012-Auto-Identity-Column-Value-Jump-Is. Scroll down to the possible solutions and try adding '-t272' as an MSSQL Server startup parameter.