How do i reset the number for a WTDocument to start from a particular number.

[klakshmi]

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.6

How do i rest the number for a WTDocument to start from a particular number.

Here are the errors that I faced
N/A

[BenLoosli]

The numbering of all objects is controlled from an OIR (Object Initialization Rule).

The number can be either manual or sequenced from the database. If sequenced, the system does skip numbers, depending on how you have it setup will  determine how it skips them.

You would need to be a system admin in order to modify the rules.

By resetting the numbering, be aware that Windchill can only have that number in its system one time,

[klakshmi]

Hello Ben,

Thank You very much for replying.

I did change in the OIR's and it is for a specific subtype of a document. When i change the numbers it's starting from some random numbers. When i change it back to the original OIR it's starting from those numbers. I think i'll have to reset in the database. We are using MSSQL, if you know or help with the commands to reset it it'll be very helpful.

Thanks,

Kiran

[klakshmi]

Hi Ben,

If you know the MSSAL command to reset or change the starting number, can you please provide me the command.

Thanks,

Kiran

[avillanueva]

Here is some generic information on sequences for SQL Server: https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-sequence-transact-sql?view=sql-server-ver17

You would need DB level access. Something you should consider is if you want to be using a sequence (which I know is default with OIRs) or allow users to enter in their own numbers. Typically, a company would have their own document numbering system in place and not rely on a random sequence number defaulted by Windchill.  Note that you are not garunteed the next number. There can be gaps and once it advances, it does not reuse numbers. Sequences only move in one direction. 

[anursingh]

Hi @klakshmi,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Of course, if you have more to share on your issue, please pursue the conversation. 

Thanks,
Anurag

[BenLoosli]

I do not what the command is in MSSQL, I have only used Oracle for the Windchill database.

Look at the name of the sequence used in the OIR and then you should be able to find that name in the database.

Also, check out this article: Article - CS49245 - How to create own numbering sequence used for Number Generators for specific Object Type in Windchill PDMLink