Folder name number sequence

Can anyone tell me how the folder name number is generated? Not the efolderid - that's no issue. But we moving from 9.1 with Oracle to 9.3 with SQL Server and ideally I'd like to avoid duplicate folder names. So if the process prefix is setup as "PRO-" with a suffix length of 3, the first folder gets the name "PRO-001" and so on. It reset the numbering when we testing in our Dev environment.

I can change the prefixes to say "PRO-1" but thought it was worth the question to see if we can just set the starting number to something close to the last number already used.

Thanks!

Find more posts tagged with

BPM

Comments

Brian Mellert

I reset starting folder IDs way back in V7, and it appears they are using the same approach in V9, so I presume it will work in V9 as well. (I have not tested to confirm.)

There is a table named seq for each project table in solutions.

If you insert the number you wish to start with, folder name numbers should continue from that point. (I don't recall if an engine restart is needed, but it would probably be a good thing either way.)