My Oracle Support Banner

SCP Jobs Not Releasing DB Connections (Doc ID 2391306.1)

Last updated on APRIL 25, 2018

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.17.11.0 to 11.13.18.01.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.13.17.11.0 version, Performance

SCP jobs not releasing DB connections

ESS jobs are erroring because no sessions are available.

Examples below:
Request Details: 164599(Error)
Request processing resulted in error with the below message.
 ERROR:PreProcessing failed to set ApplSession
Job Definition InterfaceLoaderController

Request Details: 164604(Error)
Request processing resulted in error with the below message.
 ERROR:PreProcessing failed to set ApplSession
Job Definition UpdateKeywordSearchJob

This process has leaks on both rac instances:

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.