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 OCTOBER 13, 2023

Applies to:

Symptoms

Using either the Basic or Advanced search within Oracle WebCenter Spaces or/and Oracle WebCenter Portal taskflows (Document Viewer, Content Presenter, etc) 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?

The logs will show something similar to the below (it means no results are seen = ENTRY -1):

[<TIMESTAMP>] [WC_Spaces] [TRACE:16] [] [oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [SRC_CLASS: oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: basicSearch] ENTRY ucm
[<TIMESTAMP>] [WC_Spaces] [TRACE] [] [oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [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"]
]]
[<TIMESTAMP>] [WC_Spaces] [TRACE:16] [] [oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [SRC_CLASS: oracle.webcenter.doclib.internal.view.VCRRepositoryLogic] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: basicSearch] RETURN

[<TIMESTAMP>] [WC_Spaces] [TRACE:16] [] [oracle.webcenter.doclib.internal.view.presenter.ContentPresenter] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [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
[<TIMESTAMP>] [WC_Spaces] [TRACE:16] [] [oracle.webcenter.doclib.internal.view.AbstractMainViewTreeModel] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [SRC_CLASS: oracle.webcenter.doclib.internal.view.AbstractMainViewTreeModel] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: setRowIndex(int rowIndex)] ENTRY -1

Changes

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

Cause