Wednesday, May 7, 2014

Web Center Content : quick status update

This is not recommended:

I really needed a document to go from status Done to status Released for a presentation on our training environment and did not have time to restore.

(Our indexer was broken because we had files missing due to a db restore but no file system restore)

(In the ???_OCS schema)

Step 1) Find the revision

  SELECT * FROM REVISIONS where ddocname = '1390427192270'

Step 2) Update the revision based on did

UPDATE REVISIONS SET DSTATUS = 'RELEASED', DRELEASESTATE = 'Y', DRELEASEDATE = SYSDATE where did = 109336;

Now I could search for the document yay!


Errors found in the logs:

Universal Content Management - Content Server Indexing aborted.

An error occurred during indexing.
[APP: Oracle Universal Content Management - Content Server] general exception[[
intradoc.common.ServiceException: !csIndexerRenameFailedAbort
        at intradoc.indexer.CommonIndexerBulkLoader.handleLoadError(CommonIndexerBulkLoader.java:614)
        at intradoc.indexer.CommonIndexerBulkLoader.loadRecordWebChange(CommonIndexerBulkLoader.java:247)
        at intradoc.indexer.IndexerBulkLoader.createBulkLoad(IndexerBulkLoader.java:322)
        at intradoc.indexer.IndexerBulkLoader.doWork(IndexerBulkLoader.java:171)
        at intradoc.indexer.Indexer.doIndexing(Indexer.java:419)
        at intradoc.indexer.Indexer.buildIndex(Indexer.java:327)
        at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1026)

No comments:

Post a Comment