Reset FolderID sequence

Chris_Pickford
Chris_Pickford
in AppWorks #1

Hi all,

 

Does anyone know how (or if it's possible) to reset the FolderID sequence or set it to an arbituary number?

 

I.e. the current maximum value in eFolder.eFolderID is '0000000000000000000000000038855' but I would like to tell the engine to set the next folder to '0000000000000000000000010000000' and begin incrementing from that point.

 

The reason I'd like to do this is due to an import of data from our production data warehouse into our development data warehouse which includes a load of production FolderIDs. I'd like to make an obvious distinction between folder data imported from production and folder data created in development.

 

I have tried simply adding a row to eFolder table with the desired eFolderID but this was ignored and normal sequence was maintained. I can't see any identity definitions set up on the table either which leads me to believe the engine must be generating the ID programatically. Is there any way to force set this?

 

Many thanks,

 

Chris

Tagged:

Comments

  • Kevin Manuel
    Kevin Manuel
    #2

    The eFolderID's are sequenced using the eFolderID table. That table has one column, ID, which is used to keep track of consumed eFolderID's and to determine the next available one. You can make an insert into that column which will cause the system to use that number incremented by one for the next new folder started. The ID column is enabled for Identity so you will need to override this if you want to do a manual insert.

     

    The following SQL will make the entry you requested.

     

    set identity_insert eFolderID on

    go

    insert into eFolderID (ID) values ('9999999')

    set identity_insert eFolderID off

    go

     

    The next eFolderID will be 0000000000000000000000010000000 after that changes is made.

  • BPS_Pid
    BPS_Pid
    #3

    If you are using Oracle as DBMS you must realign (using nextval or recreating the object) sequence EFOLDERID_SEQ.

    Look at pl/sql EWORK.GET_FOLDERID

     

    bye

    Max

     

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform