You are viewing limited content. For full access, please sign in.

Question

Question

Sudden and unexplainable increase in Entry ID numbers

asked on December 10, 2016 Show version history

We have a new repository where the entry IDs seem to have jumped from 160 to 34627. Below is a screenshot of the toc table:

Shouldn't row 161 show a toc of 161? What can cause a tocid to spike like that?

We don't have any infinite-loop workflows.

And then my next question: is there a way to fix this? I'd rather not recreate this repository, since I've already done so once to fix this very issue in an older version of the repository. Except on that one, the entry ID counter was in the millions before we noticed the issue.

(The entry IDs are used as Applicant IDs for a recruitment system. Each applicant is assigned an Applicant ID, which is the Entry ID of their folder in the repository. When they call the company, they are supposed to provide that ID and the person on the other line is supposed to do an Entry ID Search to find the applicant's folder. So it is not feasible for it to be very large numbers.)

0 0

Answer

SELECTED ANSWER
replied on December 12, 2016

It's most likely to this SQL issue present in SQL 2012 and higher. I don't think Microsoft acknowledged it as a bug yet but they do have a startup parameter that allegedly disables it.

0 0
replied on December 12, 2016

Damn, that sucks. I guess we'll have to re-engineer the system to use our own sequence counters.

Thank you for the information Miruna. smiley

0 0
replied on December 12, 2016

SQL Sequences have the same issue.

0 0
replied on December 12, 2016 Show version history

Well, with sequences you can use the "no cache" option, which works around the issue. No need to fiddle with using specific trace flags when starting SQL Server. wink

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.