Hello @TataSaiAbhinav-6768,
Thanks for your response. If there is no harm is deleting and recreating it, then I would definitely give a try. First try to create a new with same data and try if throws the same error or it works fine. If it works fine, then try deleting and recreating it and see how it goes.
If you notice the same behavior even after deleting and recreating it, then I would recommend filing a support ticket for deeper investigation. If you have a support plan and to create a support ticket, you can follow the steps described in this document: Create an Azure support request