idA2A2 generation logic

[Srikanth1]

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

How is idA2A2 generated in the object DB tables like WTDocMaster, WTDoc?
Is the value generated in sequence regardless of the table/object type?
I verified the DB sequence, ID_Sequence but this does not seem to be generating the number in sync with the object creation.
Please advise.

[avillanueva]

This I found in knowledge base:

https://www.ptc.com/en/support/article/CS375842?source=search

[Cassie]

• PTC does not guarantee the order and continuous for sequence numbers, only uniqueness
• Oracle caches for a sequence 20 numbers by default

• It is recommended to keep cache sequencing for a best performance

• Turning off sequence caching will not eliminate gaps or skipping of sequence
• https://www.ptc.com/en/support/article/cs113612

[bhushan.d · Accepted solution]

Hi @Srikanth1,

This is Bhushan from PTC Technical Support.

The IDA2A2 field uses a sequence that generated a new sequence number every time.

However, the same sequence is used by all tables having the IDA2A2 field.

Hence you can see inconsistencies in the IDA2A2 field of the WTDocument and the IDA2A2 is supposed to be used internally.

For customer use, we have a Number field that can be the next sequence number for a specific object type.

Also, when the database application is restarted, all cached sequence numbers get skipped hence PTC does not guarantee order and continuous sequence.

Only the uniqueness of the sequence number is guaranteed.

Check the article: CS113612 - Auto-numbering of objects not incrementing correctly in Windchill PDMLink 

For Oracle, the cached number is 20 whereas for SQL Server it is 1000.

There are ways to block the caching however it may result in a performance impact on the database level.

If my response helps, please mark it as the solution to help other members. Thanks for using the Community! 

[bhushan.d]

Hi @Srikanth1,

I wanted to follow up with you on your post 'idA2A2 generation logic' to see if your question has been answered.

If so, please designate the appropriate post as the Accepted Solution for the benefit of other members who may have the same question.
If not, please post your current status in the public thread so that we can continue to support.

Thanks,

Bhushan