This discussion is archived
10 Replies Latest reply: Aug 15, 2013 7:47 AM by 9f6b2b30-67d2-4c54-9592-4fd042c12046 RSS

UCM 11g - ContentID counter - how to reset?

903268 Newbie
Currently Being Moderated
I have migrated a bunch of content from an instance of Stellent into Oracle UCM 11g.

Stellent used a "counters" table to know how to increment the ContentId of new check-ins.

11g uses something different - db autoincrement fields, I think.

Anyways, when I check in a doc to the system, I get errors "The content ID '546437' is not unique", for example.

How does one reset the content ID counter to some number like 750000 so I don't have this problem. I'd rather not have to add a prefix to the content ID (eg ucm546437).

I just want to set the counter to some arbitrary high number and just let it roll from there.

Please let me know.

JDM
  • 1. Re: UCM 11g - ContentID counter - how to reset?
    ryan sullivan Pro
    Currently Being Moderated
    Here's a post showing details on the new implementation:

    https://blogs.oracle.com/ecmarch/entry/what_happened_to_the_content_i

    Basically, it caching an allocation of content ids, so it's not as exact as it used to be as far as sequence goes.

    if you want a random, unique id, can you simply check in the content item w/o ddocname? That will auto-create one for you from the id pool.

    -ryan
  • 2. Re: UCM 11g - ContentID counter - how to reset?
    903268 Newbie
    Currently Being Moderated
    Thanks Ryan. I did read that blog post.

    My problem isn't that I particularly care about what the contentID is, it's that the "cached" sequence is just not high enough to check in new documents. Is there a way to simply reset the sequence to, say 700000, and just let it roll from there? That would solve my problems.

    J.D.
  • 3. Re: UCM 11g - ContentID counter - how to reset?
    ryan sullivan Pro
    Currently Being Moderated
    Hmm.. have you tried to change the LAST_NUMBER value in the IDCSEQDOCID sequence?

    Looks like the common method to do this is to alter the sequence to change the increment value, then trigger the sequence to increment the LAST_NUMBER.

    For example, if you wanted to increase the value of the counter by 30000, you would:


    SELECT IDCSEQDOCID.NEXTVAL S FROM DUAL;

    to get the current value of the sequence

    ALTER SEQUENCE IDCSEQDOCID INCREMENT BY 30000 MINVALUE 0;

    to set the increment step

    SELECT IDCSEQDOCID.NEXTVAL S FROM DUAL;

    to trigger the increment step

    ALTER SEQUENCE IDCSEQDOCID increment by 1;

    to return the sequence increment back to normal

    SELECT IDCSEQDOCID.NEXTVAL FROM DUAL;

    to verify that the sequence is at your new range



    I have not done this, so make sure to test it on a PoC system or DEV system! Let us know how it goes!

    -ryan
  • 4. Re: UCM 11g - ContentID counter - how to reset?
    903268 Newbie
    Currently Being Moderated
    Hi Ryan,

    I guess I'm not following you. The statements below do not look like anything I've ever seen in MS SQL Server. Are these system functions on an Oracle DB?

    So, just for records, there are several "IdcSeq*" tables in my database.

    None of them show an Identity seed of 546438, which is where UCM wants to set my contentIDs on a new check in. I'm trying to force the number to be 640000 so I won't have any collisions with existing content migrated from another system.

    I guess I am completely unsure where the contentID counter lives at this point.

    Any ideas?

    Thanks!

    J.D
  • 5. Re: UCM 11g - ContentID counter - how to reset?
    ryan sullivan Pro
    Currently Being Moderated
    yeah, I was referring to Oracle sequences.

    do you see a table named "IDCSEQDOCID" in your db?

    SQL Server handles auto-numbering differently than Oracle dbs. SQL Server can apply an 'increment' directly to a field in a table or it can use a GUID, which is closer to oracle's distributed (i.e., not self-contained in the table) option.

    Does this article point you in the right direction:

    http://www.sql-server-performance.com/2011/sequence-sql-server-2011/

    Can you find the "IDCSEQDOCID" sequence using the method described in that post?

    Thanks,
    -ryan

    Ryan Sullivan | ECMconsultant
    http://www.ecmconsultant.net/
  • 6. Re: UCM 11g - ContentID counter - how to reset?
    903268 Newbie
    Currently Being Moderated
    Unfortunately, I'm using SQLServer 2005 and not 2012 - there is no "sequence object" in my database.

    It is completely unclear where UCM pulls a number for the dDocName field...
  • 7. Re: UCM 11g - ContentID counter - how to reset?
    ryan sullivan Pro
    Currently Being Moderated
    Does this shed some light:

    http://blogs.msdn.com/b/sqlcat/archive/2006/04/10/sql-server-sequence-number.aspx

    if you search for "Sql server 2005 sequence" you'll get a lot of information about how oracle sequences are defined in sqlserver. I'd hope that one result would be able to provide some direction.

    -ryan
  • 8. Re: UCM 11g - ContentID counter - how to reset?
    903268 Newbie
    Currently Being Moderated
    I have been unable to determine where the heck UCM generates the ContentID sequence. I'm not sure anybody knows, sadly. I have changed increment seeds on the tables and it did not affect the ContentID naming. Go figure.
  • 9. Re: UCM 11g - ContentID counter - how to reset?
    889438 Newbie
    Currently Being Moderated
    Hi!

    I am facing the same error against SQL Server 2008 database. I tried to follow the tips in this post and change some configurations and data in my database, but it doesn't work. Would someone have any advice?

    Thanks!
    Otavio Lima
  • 10. Re: UCM 11g - ContentID counter - how to reset?
    9f6b2b30-67d2-4c54-9592-4fd042c12046 Newbie
    Currently Being Moderated


    Hi,

     

    I have just been working on the same thing. In addition to changing IDCSEQDOCID Ialso changed IDCSEQREVCLASSID & IDCSEQREVID. As advised in http://docs.oracle.com/cd/E23520_01/doc.311/e20664/chapter_13.htm (13.3). This allowed me to manually increment the next id to 100,000 for our migration.

     

    Adrian

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points