ER JOB 1 Failure (Doc ID 3005350.1)

Last updated on FEBRUARY 25, 2024

Applies to:

Symptoms

User upgraded to CS to 81254 and encountered issue with ER Job 1.

steps to verify:

Go to deployed/ficdb/bin

run the ER job1.

Expected result:
The ER job1 should be successful

Actual result:
The ER job1 failed with below error

Error observed in load-to-es.log

java.io.IOException: Unable to parse response body for Response{requestLine=GET _mtermvectors HTTP/1.1, host=<hostname>:9200, response=HTTP/1.1 200 OK}
at org.elasticsearch.client.RestHighLevelClient.internalPerformRequest(RestHighLevelClient.java:1751) ~[elasticsearch-rest-high-level-client-7.14.0.jar:7.14.0]
at org.elasticsearch.client.RestHighLevelClient.performRequest(RestHighLevelClient.java:1717) ~[elasticsearch-rest-high-level-client-7.14.0.jar:7.14.0]
at org.elasticsearch.client.RestHighLevelClient.performRequestAndParseEntity(RestHighLevelClient.java:1684) ~[elasticsearch-rest-high-level-client-7.14.0.jar:7.14.0]
at org.elasticsearch.client.RestHighLevelClient.mtermvectors(RestHighLevelClient.java:1470) ~[elasticsearch-rest-high-level-client-7.14.0.jar:7.14.0]
at com.oracle.fccm.loadToOpenSearch.utility.IndexDataLoadingUtil.applyTranslation(IndexDataLoadingUtil.java:1351) ~[classes!/:?]

Error observed in er-batch.log.

 com.oracle.ofss.fccm.Service.CreateInputIndex - Returned Message from createIndex :: {"STATUS":"FAILED","MESSAGE":"Error occurred in Export File, failed to export the file, response -> \nFAILED","COUNT":-1}
INFO com.oracle.ofss.fccm.util.QueryUtil - Merge into FCC_ER_FULL completed.
ERROR com.oracle.ofss.fccm.Service.CreateInputIndex - Exception occurred while executing batch. {}
java.lang.Exception: java.lang.Exception: Exception occurred while loading data:
at com.oracle.ofss.fccm.Service.CreateInputIndex.mergeAndLoadToES(CreateInputIndex.java:492) ~[seprate-schema-er-job-8.1.2.5.0.jar:?]
at com.oracle.ofss.fccm.Service.CreateInputIndex.restClient(CreateInputIndex.java:228) [seprate-schema-er-job-8.1.2.5.0.jar:?]
at com.oracle.ofss.fccm.Service.CreateInputIndex.main(CreateInputIndex.java:299) [seprate-schema-er-job-8.1.2.5.0.jar:?]
Caused by: java.lang.Exception: Exception occurred while loading data:
at com.oracle.ofss.fccm.Service.CreateInputIndex.loadDataToElasticSearch(CreateInputIndex.java:547) ~[seprate-schema-er-job-8.1.2.5.0.jar:?]
at com.oracle.ofss.fccm.Service.CreateInputIndex.lambda$mergeAndLoadToES$2(CreateInputIndex.java:482) ~[seprate-schema-er-job-8.1.2.5.0.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]

Cause

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