Opensearch dashboard complains that `opensearch_dashboards_*` index already exists and doesn't start

[Pavan-Gunda]

Describe the bug:

During the migration process, Opensearch dashboard is complaining that the index opensearch_dashboards_2 index already exists and that it couldn't perform it's migration.

To Reproduce: Follow the migration docs v0.31

Steps to reproduce the behaviour:

Expected behaviour:

This should not happen and opensearch dashboards should start with the correct index

Version (add all relevant versions):

• Compliant Kubernetes apps version 0.31

Additional context:

Here's the log from opensearch

{"type":"log","@timestamp":"2023-08-10T09:03:26Z","tags":["info","savedobjects-service"],"pid":1,"message":"Creating index .opensearch_dashboards_2."}
{"type":"log","@timestamp":"2023-08-10T09:03:35Z","tags":["error","opensearch","data"],"pid":1,"message":"[resource_already_exists_exception]: index [.opensearch_dashboards_2/YGg3xRfoTjOyAPajcBsVQA] already exists"}
{"type":"log","@timestamp":"2023-08-10T09:03:35Z","tags":["warning","savedobjects-service"],"pid":1,"message":"Unable to connect to OpenSearch. Error: resource_already_exists_exception: [resource_already_exists_exception] Reason: index [.opensearch_dashboards_2/YGg3xRfoTjOyAPajcBsVQA] already exists"}