Troubleshooting issues with removing MSSQL datasets and restoring indices

Original Slack Thread

Hi, I’m using datahub delete --platform mssql --hard to remove all MSSQL datasets, but I got this result in the below picture. I checked, and there is no urn:dataPlatform:mssql% in MySQL (that is correct). So, I checked Elasticsearch and found that the data should be removed. Then, when ingesting the MSSQL from the UI, I got ‘No assets were ingested.’
I searched for the problem in the troubleshoot channel; many people have the same issue, and they use ‘restore indices’ to solve it. I followed this document, but nothing happened. The search result in the UI is still wrong. Does anyone have some idea?attachment

Hey there! :wave: Make sure your message includes the following information if relevant, so we can help more effectively!

  1. Which DataHub version are you using? (e.g. 0.12.0)
  2. Please post any relevant error logs on the thread!

My DataHub version is 0.13.0, and I use the command “datahub docker quickstart” to deploy.