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) ...
The Incident Archive: A blog to store my knowledge on the errors that I fix on a daily basis