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

[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