WTObject number was jump!

[CHASEONHO]

attach the photo

The number will jump as follows. suddenly!
Why is that?
I do not know why.
How do I increment it by 1?
At what point does OOTB actually increase by 20?
In my opinion, the moment number jump occur when the server is restarted.
Or after a day ...

[RoyCrerar · Accepted solution]

Hi, Been having similar issues. The reason for the jump is that there is a cache on the sequence. When the server restarts this is lost. The reason caching is used is for performance, it's quicker to create the numbers you need if they are cached.

I use a sequence that absolutely should not have missing numbers for audit trail. To get that working I had to make the sequence no-cache.

If you need help to create a new sequence with no-cache please let me know.

[CHASEONHO]

Thanks!

could you help me how to create no-sequence please?

[RoyCrerar]

OK,  I cannot se the PTC solutions suggested above as my login is restricted.

First you need to be able to run the Windchill shell. in CMD window on the your Windchill appsvr run the shell. our command is 

D:\PTC\WC\Windchill\bin\windchill.exe -w "D:\PTC\WC\Windchill" --java="D:\PTC\\WC\Java\jre\bin\java.exe" shell

Your command may be slightly different depending on drive definition etc.

You need to run SQLPLUS as administrator 

sqlplus <administrator name>/<adminpassword>

Once in you can either Alter Sequence or Create Sequence

at prompt

SQL> Alter Sequence <sequence name>

 2 nocache;

Hope this helps.

[TomU]

See this KB articles:

• https://www.ptc.com/en/support/article?n=CS18948
• https://www.ptc.com/en/support/article?n=CS208897
• https://www.ptc.com/en/support/article?n=CS124192
• https://www.ptc.com/en/support/article?n=CS8303