Fusion Global HR: Intermittent Errors with ESS job to create index definition and perform initial ingest to OSCS (Doc ID 3016062.1)

Last updated on JULY 28, 2024

Applies to:

Symptoms

 ESS Job - ESS job to create index definition and perform initial ingest to OSCS is intermittently ending into error for the indexName - fa-hcm-person

Error Message - 

ESS job FndOSCSIndexIngestESS failed with errorError while connecting to elastic: statusCode: 500 response: {"createIndex::fa-hcm-person-fnd-zdt":{"createIndex::fa-hcm-person-v29":{"acknowledged":true,"shards_acknowledged":true,"index":"fa-hcm-person-v29"},"status":0,"createAlias::fa-hcm-person-fnd-zdt":{"acknowledged":true}},"status":500,"initialIngest::fa-hcm-person-fnd-zdt":{"status":500,"message":"failure : java.util.concurrent.ExecutionException: java.lang.RuntimeException: oracle.jbo.DMLException: JBO-26061: Error while opening JDBC connection.","errors":[],"messages":["Processing Initial Ingestion for index : fa-hcm-person-fnd-zdt","Initial process state : {\"ingestStartTime\":\"2024-03-12 21:00:05.587\"}","Total number of rows to be processed : 11926","Total number of rows processed in the current run 30"]}}

Changes

 NA

Cause

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