SES Process Getting Stuck In "Executing" Status During Crawl With "java.sql.SQLException: Closed Connection" Error In Crawler Log File (Doc ID 2078579.1)

Last updated on MARCH 13, 2017

Applies to:

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

Symptoms

On :SES 11.2.2.2.0 version, Crawler

The SES crawler process getting stuck in "Executing" status during crawl.

These errors are seen in the crawler log file,

Internal error: java.sql.SQLException: Closed Connection, from: JdbcPagesProcessedManager.close
java.sql.SQLException: Closed Connection

or

Error in ESSCrawlerLauncher: IO Error: Software caused connection abort: recv failed

The database has been configured with connection timeout limits or a firewall is between the SES database and middle tier installation that has connection timeout limits.

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