cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

WTObject number was jump!

CHASEONHO
18-Opal

WTObject number was jump!

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

1 ACCEPTED SOLUTION

Accepted Solutions
RoyCrerar
14-Alexandrite
(To:CHASEONHO)

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.

View solution in original post

4 REPLIES 4
RoyCrerar
14-Alexandrite
(To:CHASEONHO)

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.

Thanks!

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

RoyCrerar
14-Alexandrite
(To:CHASEONHO)

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.

Announcements