Basic/Advanced Search in Oracle Webcenter Spaces/Portal Does Not Return Any Documents in Taskflows - UCM SearchIndexerEngineName = DATABASE.METADATA

(Doc ID 1326427.1)

Last updated on AUGUST 10, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.3.0 to 11.1.1.7.0 [Release 11g]
Oracle WebCenter Portal - Version 11.1.1.3.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.
*** Checked for relevance 10-SEP-2013 ***

Symptoms

Using either the Basic or Advanced search within Oracle WebCenter Spaces or/and Oracle WebCenter Portal taskflows (Document Viewer, Content Presenter, etc) always returns this value:

"No documents were found."
** OR **
"No documents or folders were found."

The criteria entered should return some documents.
Using a similar search in UCM returns the expected documents.


Example from Content Presenter taskflow

1. Create a Space
2. Make sure that Documents service is enabled for the Space, within the General Settings -> Services
3. Under the Pages make sure the Documents page is shown
4. Within the Documents page, upload a document - ex: ucm_search.JPG
5. Go to the Home page (CTRL+SHIFT+E) and add the Content Presenter taskflow
6. Click on the wrench of Content Presenter taskflow
7. Click on the "Select Content" button, under the Preview tab or onto the Content tab
8. Click on Browse button
9. Enter a name of a document (ex: ucm) in the search box and clicked enter...


     -> It did NOT return the ucm_search.JPG image.



Useful diagnostics

Use TRACE:32 onto the oracle.webcenter.doclib.* - refer to:
  • <Note:1078361.1> - How To Diagnose/Debug a WebCenter Spaces Issue?
  • <Note:1206848.1> - How To Diagnose/Debug a WebCenter 11g Issue within JDeveloper 11g?
If you'll see something similar to the below (it means no results are seen = ENTRY -1):
[2011-07-12T11:55:18.737-04:00] [WC_Spaces] [TRACE:16] [] [oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 1524f3792657365f:-28eddf07:13106069a5b:-8000-000000000000802a,0] [SRC_CLASS: oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: basicSearch] ENTRY ucm
[2011-07-12T11:55:18.823-04:00] [WC_Spaces] [TRACE] [] [oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 1524f3792657365f:-28eddf07:13106069a5b:-8000-000000000000802a,0] [SRC_CLASS: oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: basicSearch] Sending VCR query: Search[repositoryId=WebCenterSpaces-ucm, max to return=-1, useFullTextSearch=true, useCache=true, fullText="[[
Metadata criteria((cm_contentType equals IDC:GlobalProfile)AND(cm_nodeName likeignorecase *ucm*)AND(cm_path equals /WebCenterSpaces-ucm//*)AND(cm_isContent [any] equals true))
isOr=false"]

]]
[2011-07-12T11:55:18.824-04:00] [WC_Spaces] [TRACE:16] [] [oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 1524f3792657365f:-28eddf07:13106069a5b:-8000-000000000000802a,0] [SRC_CLASS: oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: basicSearch] RETURN
[2011-07-12T11:55:18.911-04:00] [WC_Spaces] [TRACE:16] [] [oracle.webcenter.doclib.internal.view.presenter.ContentPresenter] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 1524f3792657365f:-28eddf07:13106069a5b:-8000-000000000000802a,0] [SRC_CLASS: oracle.webcenter.doclib.internal.view.presenter.ContentPresenter] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: getWizardTaskflowId] RETURN /oracle/webcenter/doclib/view/jsf/taskflows/presenter/contentPresenterWizard.xml#content-presenter-wizard
[2011-07-12T11:55:19.159-04:00] [WC_Spaces] [TRACE:16] [] [oracle.webcenter.doclib.internal.view.AbstractMainViewTreeModel] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 1524f3792657365f:-28eddf07:13106069a5b:-8000-000000000000802a,0] [SRC_CLASS: oracle.webcenter.doclib.internal.view.AbstractMainViewTreeModel] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: setRowIndex(int rowIndex)] ENTRY -1

Changes

No changes.

Default install of Oracle Webcenter 11g (11.1.1.3+) and/with Oracle Universal Content Managment 11g (11.1.1.3+).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms