topic Re: Workflow Auto Generated Document number in Windchill

Workflow Auto Generated Document number

BenLoosli — Fri, 04 May 2018 13:33:05 GMT

In the OOTB Change Request workflow, we have the number field set to Auto generate.In the OIR for Change Request, we have the following lines for the number field.<AttrValue id = "number"algorithm="com.ptc.windchill.enterprise.revisionControlled.server.impl.NumberGenerator"ignore="false"

Re: Workflow Auto Generated Document number

BenPerry — Thu, 26 Feb 2015 21:20:35 GMT

Try this on the DB (log into SQLPlus):

ALTER SEQUENCE WTCHANGEREQUESTID_seq NOCACHE;

Are you able to confirm on a test system first?

Re: Workflow Auto Generated Document number

BenLoosli — Thu, 26 Feb 2015 21:36:37 GMT

I will try that on my test system.

I would guess that other numbers could also be changed to be sequential by doing the same nocache alteration.

Re: Workflow Auto Generated Document number

BenLoosli — Thu, 26 Feb 2015 22:14:58 GMT

How do I alter the initial starting number to 3000?

It is currently at 63 and when I tried to edit it in the Oracle Console, it said start number cannot exceed current number. Current number could not be editted in the console.

Re: Workflow Auto Generated Document number

BenPerry — Fri, 27 Feb 2015 02:03:33 GMT

This is assuming Oracle database. The difference between the desired next number and the current next number is (3000-64 = 2936).

ALTER SEQUENCE WTCHANGEREQUESTID_seq INCREMENT BY 2936;
SELECT WTCHANGEREQUESTID_seq.nextval FROM dual;
ALTER SEQUENCE WTCHANGEREQUESTID_seq INCREMENT BY 1;

Again, test it. I might be off by 1 number?

I am quite perplexed as to why these sequences aren't set up OOTB as NOCACHE. I continuously hear of admins complaining about number sequences jumping by 20 (the default cache value) sometimes.

Some references:

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS113612

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS124192

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS133468

Creating a number Sequence in Windchill - Gotcha

FYI...I have never created the sequence with the exec.wtpk.createSequence() command. Instead, I've always used the CREATE SEQUENCE ... command with correct parameters (including NOCACHE at the end of the statement). I don't know of the difference between the 2 methods.