Sequence

GW12345 · 2022-07-20T20:50:44+00:00

There was an error rendering this rich post.

GW12345

Has the same DB sequence been used to generate ID for DTREE (DTREE.DATAID) and KUAF(KUAF.ID)?

Regards,

Gerry

Find more posts tagged with

Comments

David Henshaw

Gerry - I'm not fully understanding your question, but believe the answer is no.

DTree.DataID is allocated when/as needed - and if I recall correctly the application essentially reserves "chunks" for each thread. If you run a multithreaded system or one with multiple front ends you'll see the DataID for content is not always sequential based on when items are created.

One should never assume that the next unused DataID in the table i.e. max+1 is available - it may already have been allocated for use, or could even have been a deleted item.

HFCDev

Correct. Each thread will grab a bunch of unique id's, by incrementing a sequence. This leads to the odd behavior where an object with a smaller Data ID can have a later creation date. I think that pool of ID'S in each thread can be used for data id's, workflow id's, or user id's. I used to know exactly where this was done in Cs 10.0 buts been a while since I last looked.
Hugh

Appu Nair

@"Hugh Ferguson" are you thinking KID …
The KUAF.ID is traditionally inserted as the personal workspace Id of the user and made owner of that so kuaf.ids and some DTree.dataids may look identical

David Henshaw

@GW12345 - the operative point to my response, Appu's and Hughs is that any assumption you make about the database is at your own peril.

If you need a copy of the database schema document, contact your OpenText Account rep. Even then, inserting, deleting or updating the database directly is usually frowned upon. And without knowing the application logic and how it also manages allocation of IDs I would never "ask the database" to give me the next relevant ID.....use the programmatic interfaces or web services for those things to be assured.

Appu Nair

@Henshaw_David @GW12345 @Hugh Ferguson see Brain Walsh's reply KID is the main source for most of the ID's

urltofoolbothttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=74446987&objAction=viewincontainer