Skip to main content
C
CHASEONHO18-Opal
18-Opal
December 6, 2017
Solved

WTObject number was jump!

  • December 6, 2017
  • 4 replies
  • 2230 views

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 ...

Best answer by RoyCrerar

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.

4 replies

R
RoyCrerar1-VisitorAnswer
1-Visitor
December 6, 2017

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.

C
CHASEONHO18-OpalAuthor
18-Opal
December 7, 2017

Thanks!

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

R
RoyCrerar1-Visitor
1-Visitor
December 7, 2017

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.

Terms & ConditionsAccessibility statement