Skip Headers
Oracle® Fusion Applications Administrator's Guide
11g Release 1 (11.1.1.5)

Part Number E14496-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

19 Troubleshooting Oracle Enterprise Crawl and Search Framework

This chapter describes common problems that you might encounter when using Oracle Enterprise Crawl and Search Framework (ECSF) and explains how to solve them.

This chapter includes the following topics:

In addition to this chapter, review the Oracle Fusion Middleware Error Messages Reference for information about the error messages you may encounter.

19.1 Problems and Solutions

This section describes common problems and solutions. It contains the following topics:

19.1.1 Missing Parameters for Search Engine Instance

You do not see any parameters for the search engine instance you created.

Problem

Seed data is not set up on your Oracle Fusion Applications database.

Solution

Execute the ECSF_SEED_DATA.sql script against your Oracle Fusion Applications database.

19.1.2 Cannot Create Search Engine Instance

You are unable to create a search engine instance record.

Problem

An existing search engine instance record is present.

Solution

  1. Execute the following SQL statement:

    select * from ECSF_ENGINE_INSTANCE

  2. Delete the row that contains null values for all fields except the ID and Name fields, and commit the deletion.

  3. Recreate the search engine instance.

19.1.3 Searchable Object Not Listed in Fusion Applications Control for ECSF

Your searchable object is not listed in the table of the Add a Searchable Object to Selected Engine Instance dialog.

Following are two possible causes and solutions for this issue:

Problem

The searchable object is not in the Oracle Fusion Applications database. You can check by executing the following SQL statement against your Oracle Fusion Applications database:

select * from ECSF_SEARCH_INDEX_OBJECT

Solution

Register the searchable object in the Oracle Fusion Applications database. For information, see Task 2, "Register the Searchable Objects".

Problem

The searchable object has already been associated with an engine instance. This is evident when a value exists in the SEI_ID column.

Solution

Disassociate the searchable object from the current engine instance. For information, see Task 3, "Disassociate the Searchable Objects from Search Engine Instances".

You can identify the engine instance with which the searchable object is associated by executing the following SQL statement:

select * from ECSF_ENGINE_INSTANCE where ID = sei_id_value_of_your_searchable_object_record

Alternatively, you can browse through the engine instances in Fusion Applications Control for ECSF.

19.1.4 Searchable Object Deployment Fails

Your attempt to deploy a searchable object using Fusion Applications Control for ECSF fails.

Following are two possible causes and solutions for this issue:

Problem

The ECSF application, which is deployed to Oracle WebLogic Server, does not contain the search metadata file.

Solution

Make sure the ECSF application contains the search metadata file, and redeploy it to Oracle WebLogic Server. For information, see the "Deploying and Crawling Searchable Objects" chapter in Oracle Fusion Applications Developer's Guide.

Problem

The ECSF_RUNTIME_URL search engine instance parameter is not set, or is set incorrectly.

Solution

Make sure the ECSF_RUNTIME_URL parameter is set correctly.

19.1.5 Searchable Object Undeployment Fails

Your attempt to undeploy a searchable object from an engine instance fails.

Problem

The searchable object you are trying to undeploy does not exist in the Oracle SES data sources.

Solution

Make sure the searchable object you are trying to undeploy is deployed to an engine instance, as indicated when the DEPLOYED flag is set to TRUE, or the Deployed column is checked in Fusion Applications Control for ECSF.

19.1.6 Search Category Deployment Fails

Your attempt to deploy the search category to the engine instance fails.

Problem

There are no deployed searchable objects associated with the search category.

Solution

Make sure you associate searchable objects with the search category before you attempt to deploy the search category. For information, see Task 3, "Associate Searchable Objects with the Search Categories".

19.1.7 Cannot Start, Undeploy, or Delete the Index Schedule

You cannot start, undeploy, or delete the index schedule.

Problem

The index schedule is in ERROR_MANUAL_RECOVERY state, which results from restarting the database.

Solution

You must recover the stuck ESS request. For information, see the "Stuck Scheduling Requests" section in Oracle Secure Enterprise Search Administrator's Guide.

19.1.8 Crawl Fails

You can view the data in feeds, but you receive an error when you attempt to crawl the data into the search engine.

Problem

You did not specify a search plug-in for your searchable object, so the default security plug-in is being used. The default security plug-in requires you to select a secure attribute.

Solution

Select a secure attribute when you define searchable attributes. For information, see the "Creating Searchable Objects" chapter in Oracle Fusion Applications Developer's Guide.

19.1.9 Invalid Channel Feed Type Error

You receive the following error during a scheduled crawl:

Error: Invalid Channel Feed type "error".

Problem

When the crawl was scheduled to start, the crawl state of the searchable object was CRAWLING. ECSF allows a searchable object to be crawled by only one process at a time. If you are certain that the searchable object is not being crawled, then the last crawl was abnormally terminated, and the ECSF metadata was not properly updated to indicate that the crawl had concluded.

Solution

Manually start the crawl to reset the state of the crawl and enable the searchable object to be crawled. For information, see Task 5, "Start the Index Schedules".

19.1.10 ECSF Query Error

You receive the following error when you click on a facet value:

unexpected ECSF Query Error: oracle.ecsf.SearchException: Field
'facet_attribute' cannot be used for this query because it has not been
indexed in on the search engine

Problem

You deployed the searchable object to the Oracle SES instance, so it became available for search and the facet tree was rendered with its facet values. However, the crawl had either failed or no documents were indexed, so Oracle SES does not contain the searchable attribute.

Solution

Determine why the crawl failed, undeploy the searchable object, and then redeploy it to the Oracle SES instance to generate a new index.

19.1.11 FND-6603 Error

You receive the FND-6603 error that halts search functionality.

Problem

The search categories could not be fetched, or results could not be obtained from all the selected search categories. There may be other causes for the error.

Solution

You can change the server startup parameters to increase the web service timeout value to 5 minutes (500,000 milliseconds). For information, see the "How to Set the System Parameter for Web Service" section in Oracle Fusion Applications Developer's Guide.

You can also undeploy the categories that are failing to load. For information, see Task 1, "Undeploy the Search Categories".

19.2 Diagnosing Enterprise Crawl and Search Problems

This section describes general approaches for diagnosing ECSF problems. It contains the following topics:

19.2.1 Diagnosing ECSF Command Line Administration Utility Issues

To diagnose issues related to ECSF Command Line Administration Utility, you can check the log file (ecsfCmdLineAdminLog.txt) located in the log subdirectory where runCmdLineAdmin.sh or runCmdLineAdmin.bat file is executed.

19.2.2 Diagnosing Fusion Applications Control for ECSF Issues

To diagnose issues related to Fusion Applications Control for ECSF, you can also check for error messages in the log files located in DOMAIN_HOME/sysman/log.

If the parameters for the selected search engine instance are not configured correctly, a window with error messages appears. The error message contains three entries: a summary of the error, the specific error message from the runtime server, and the detailed stack trace information. The messages in the first and the second entries are internationalized (that is, they are translated to the language of the selected locale).

19.2.3 Diagnosing Failures During Deploy/Undeploy Operations for Search Categories

If you experience failures while deploying or undeploying search categories, check for the following:

  • The database connection is successful.

  • The searchable object is available in the Oracle Enterprise Manager repository.

  • The associated searchable objects are deployed.

  • The deployed object is available in Oracle SES.

19.3 Using My Oracle Support for Additional Troubleshooting Information

You can use My Oracle Support (formerly MetaLink) to help resolve Oracle Fusion Applications problems. My Oracle Support contains several useful troubleshooting resources, such as:

You can access My Oracle Support at https://support.oracle.com.