Spice Jet Airlines — Refund of of failed transaction money

I had tried to make a spice jet reservation on the 16 June 2022 through the Spice Jet website. The process went through till the amount being deducted from my bank account, but the ticket was not issued to me. When I checked it was found that the transaction had failed. The amount being deducted from my bank account being 6572/-. Transaction number[protected]. When I called up the customer care, they assured me that the money will be refunded back into my account in 7 to 14 days.
I have been sending them emails regarding the same since the last five months at an interval of 15 to 20 days. They always reply that we are looking into the issue and will solve it soon.
Till date the money has not been credited to my account.
The above issue is creating a lot of mental tension to me and my family.