My Oracle Support Banner

"java.sql.SQLRecoverableException: IO Error: SO Exception was generated" When Using The Service Name In The JDBC Connection String At Creation Of CSF Entries (Doc ID 1911338.1)

Last updated on AUGUST 15, 2018

Applies to:

Oracle Secure Enterprise Search - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Symptoms

SES 11.2.2.2 got installed in mode #3.
Then, seeing the following error in "ess_server1-diagnostic.log" when crawling data source:

[ESS_JobMetadataID: JobDefinition://oracle/apps/ess/search/OracleSearchCrawlerCore] Execution error for request 10. Reason: Spawned job for request 10 produced the error exit code: ERROR[[
oracle.as.scheduler.ExecutionErrorException: Spawned job for request 10 produced the error exit code: ERROR


and in the request launcher log file (for ex: 9.log) found in the crawler log directory (or each ESS request in EM)
this log is <request ID>.log :

[2014-07-23T16:56:55.644-07:00] [search] [NOTIFICATION] [] [oracle.search] [tid: main] [ecid: 0000KT_e0FS4ioc5TjG7yc1Jo4j7000001,0] Creating launcher for the crawler
[2014-07-23T16:56:55.863-07:00] [search] [NOTIFICATION] [] [oracle.search] [tid: main] [ecid: 0000KT_e0FS4ioc5TjG7yc1Jo4j7000001,0] Retrieved credentials to connect to the database
[2014-07-23T16:56:56.059-07:00] [search] [ERROR] [] [oracle.search] [tid: main] [ecid: 0000KT_e0FS4ioc5TjG7yc1Jo4j7000001,0] Error connecting to database: IO Error: SO Exception was generated
[2014-07-23T16:56:56.059-07:00] [search] [ERROR] [] [oracle.search] [tid: main] [ecid: 0000KT_e0FS4ioc5TjG7yc1Jo4j7000001,0] Error in ESSCrawlerLauncher: IO Error: SO Exception was generated
[2014-07-23T16:56:56.060-07:00] [search] [ERROR] [] [oracle.search] [tid: main] [ecid: 0000KT_e0FS4ioc5TjG7yc1Jo4j7000001,0] [[
java.sql.SQLRecoverableException: IO Error: SO Exception was generated


All the data sources are up and running in the WLS console though .

Changes

 Here is the output of the listCred command to list the entry in CSF:

wls:/search_domain/serverConfig> listCred(map="oracle.search", key="SEARCH_DATABASE")
Already in Domain Runtime Tree

[Name : jdbc:oracle:thin:@hostname.domain_name:1521:db_service_name.domain_name), Description : null, expiry Date : null]
PASSWORD:xxxxx

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.