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)
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)
Comments
Post a Comment