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

Question

Question

tocid int column max value

Laserfiche
Updated November 19, 2015
asked on November 19, 2015

As SQL savvy folks know, an integer column in SQL Server has a max value of 2.1 billion (2,147,483,647)

Tocid (entry id) is the identity column in the Toc table, so if a customer were to reach the max limit, what would be the solution from Laserfiche?

 

0 0

Answer

APPROVED ANSWER
replied on November 19, 2015

We've had a customer run into the limit. They were given an SQL script to compact their tocids. They had many fewer than 2^31 - 1 entries, but large gaps in the tocids. If you find that you will hit the limit within 6 months, you should contact LF tech support to begin a compaction process.

0 0

Replies

replied on November 19, 2015

If you reach this limit by actually creating 2 billion documents, that is impressive. It might be worth investigating restructuring your data across multiple repositories. However, if you have large gaps in the id range (e.g. if you had an out of control workflow or script that was creating & deleting entries in a loop), you can reseed the tocid column by finding a large gap in the tocids and running 

dbcc checkident (toc, reseed, XXXXX)

where XXXXX is the beginning of the gap. New entries will get IDs starting at that point.

 

1 0
replied on November 19, 2015

Thanks Robert. Our system is fully automated where incoming documents arrive via email and are subsequently imported to our repository. We also have a lot of Quick Fields processing that, by it's nature, deletes and re-creates 10's of thousands of documents as it's processing batches of documents.

 

One of your customers is bound to reach the limit at some point. I was just wondering how this would be handled on the customer's behalf. We are no where near the limit, but could be one day in the future.

 

Would your solution be to split the repository into multiples? If so, is there a script or SDK routine pre-written for that?

0 0
APPROVED ANSWER
replied on November 19, 2015

We've had a customer run into the limit. They were given an SQL script to compact their tocids. They had many fewer than 2^31 - 1 entries, but large gaps in the tocids. If you find that you will hit the limit within 6 months, you should contact LF tech support to begin a compaction process.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...