Datahub version: v0.9.6.1 CLI: 0.9.6.4 Problem: When we ingest metadata using the datahub cli from oracle source, the GMS service throws "document missing exception". Due to this metadata is never ingested in datahub. This error comes randomly but it persists for this particular ingestion. We are able to modify descriptions, create domains from the datahub UI. Error

[62]: index [datahubprod_datasetindex_v2], type [_doc], id [urn%3Ali%3Adataset%3A%28urn%3Ali%3AdataPlatform%3Aoracle%2Cbtvl.item_master%2CPROD%29], message [[datahubprod_datasetindex_v2/zU2-TAicR3aYyFw_r6niQg][[datahubprod_datasetindex_v2][0]] ElasticsearchException[Elasticsearch exception [type=document_missing_exception, reason=[_doc][urn%3Ali%3Adataset%3A%28urn%3Ali%3AdataPlatform%3Aoracle%2Cbtvl.item_master%2CPROD%29]: document missing]]]

Hey there 👋 I'm The DataHub Community Support bot. I'm here to help make sure the community can best support you with your request. Let's double check a few things first: 1️⃣ There's a lot of good information on our docs site: www.datahubproject.io/docs, Have you searched there for a solution? Yes button ✅ It's not uncommon that someone has run into your exact problem before in the community. Have you searched Slack for similar issues? ✅ button

Hi Abhishek, you might need to run restore indices on ES. This thread might help!: https://datahubspace.slack.com/archives/CV2UVAPPG/p1682634125369549?thread_ts=1682591633.438969&cid=CV2UVAPPG And this guide : https://datahubproject.io/docs/how/restore-indices/

Hi @delightful-ram-75848 I executed the curl command for restoreIndices and got the following response but the metadata is still not visible on the datahub ui. # Curl command

curl --location --request POST '<https://mydatahub.com/api/gms/aspects?action=restoreIndices>' --header 'Authorization: Bearer fdfdf' --header 'Content-Type: application/json' --data-raw '{ "urn": "urn:li:dataset:(urn:li:dataPlatform:oracle,btvl.item_master,PROD)" }'

# Response

{
  "value": "{args=RestoreIndicesArgs(start=0, batchSize=10, numThreads=1, batchDelayMs=1, aspectName=null, urn=urn:li:dataset:(urn:li:dataPlatform:oracle,btvl.item_master,PROD), urnLike=null), result=RestoreIndicesResult(ignored=0, rowsMigrated=10, timeSqlQueryMs=2, timeGetRowMs=1, timeUrnMs=0, timeEntityRegistryCheckMs=0, aspectCheckMs=0, createRecordMs=1, sendMessageMs=13)}"
}