Index For Customer Search Fails When We Try To Create Full Indexing (Doc ID 1509520.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Fusion Common CRM - Version 11.1.4.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 12-Sep-2014

Symptoms

When first time Search Index was run, It errored out.

When looked into Logs, Error shows as below :

Error in the SES Console for the Customer Profile Index Schedule
EQA-15021: The associated Oracle Enterprise Scheduler (ESS) request with ID 37966 is no longer executing. The request ended in state ERROR with the following information: oracle.as.scheduler.ExecutionErrorException: Spawned job for request 37966 produced the error exit code: ERROR

 

When looked into crawler logs, It was as below :

[2012-11-26T17:57:19.118-06:00] [search] [ERROR] [] [oracle.search] [tid: Main Thread] [ecid: 0000Jgz9ol3D4iVRy2J7D01Gh07U000001,0] [[
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

 

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