Unable to delete Azure SQL DB, logs display Internal Server Error

Question

I recently created a database, I was initiated the process of moving it to elastic pool Hyperscale, but due to some reason I no longer wanted that, so while the migration to elastic pool was in progress, i initiated the deletion of the database, but it didn't get deleted, I even got deleted successfully notification. I checked the activity log, here's what I found, I am pasting the JSON which I am seeing under the Activity log of that database. It's been a day and still I am not able to delete the instance and the instance is being charged. Can someone help me with this ?

{
    "authorization": {
        "action": "Microsoft.Sql/servers/databases/delete",
        "scope": "/subscriptions/fd490646-4466-4b37-aafe-345b0d15dd21/resourceGroups/leadcurrent/providers/Microsoft.Sql/servers/lc-master/databases/onesearch"
    },
    "caller": "[REDACTED]",
    "channels": "Operation",
    "claims": {
        "aud": "https://management.core.windows.net/",
        "iss": "https://sts.windows.net/a7488d9a-c068-4fc1-a8a4-e1e46bf04fe6/",
        "iat": "1719855519",
        "nbf": "1719855519",
        "exp": "1719860259",
        "http://schemas.microsoft.com/claims/authnclassreference": "1",
        "aio": "AYQAe/8XAAAA/v4vaT9YRfk3klZi2EJwsBBxhmC+qj1N4jZhsUe+zZN2oOOTS5po5p2eQbBl7FUPtcHrehuebJi4qgPgi0BzQMYRC3y3uZmpZY4GTL90iK3+UwAzAh0MnbITi9eRwb6guHiigAc5eMtvNMl9oxRNwzSSz3W/K07mLyKYA4qQ8Mg=",
        "altsecid": "1:live.com:0003BFFD5EDE6252",
        "http://schemas.microsoft.com/claims/authnmethodsreferences": "pwd,mfa",
        "appid": "b677c290-cf4b-4a8e-a60e-91ba650a4abe",
        "appidacr": "0",
        "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/emailaddress": "[REDACTED]",
        "http://schemas.microsoft.com/identity/claims/identityprovider": "live.com",
        "idtyp": "user",
        "ipaddr": "2405:201:1003:f0fd:904b:389d:e958:66ee",
        "name": "mahesh",
        "http://schemas.microsoft.com/identity/claims/objectidentifier": "4aa58e21-0c25-43f2-8775-26c5252a09bd",
        "puid": "100320039B687260",
        "rh": "0.Ab0Amo1Ip2jAwU-opOHka_BP5kZIf3kAutdPukPawfj2MBMDAYI.",
        "http://schemas.microsoft.com/identity/claims/scope": "user_impersonation",
        "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier": "1Tqxs8cyvUBL4sk7w1r76DExFIP6xtFwAc5gVuL-mvA",
        "http://schemas.microsoft.com/identity/claims/tenantid": "a7488d9a-c068-4fc1-a8a4-e1e46bf04fe6",
        "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name": "live.com#[REDACTED]",
        "uti": "J5GtqMU8k0ueLPr_Ez7oAA",
        "ver": "1.0",
        "wids": "13bd1c72-6f4a-4dcf-985f-18d3b80f208a",
        "xms_edov": "true",
        "xms_idrel": "14 5",
        "xms_tcdt": "1719492782"
    },
    "correlationId": "180d4a50-f44a-4d73-b516-2c41e0ac305e",
    "description": "",
    "eventDataId": "ab5e67b9-73b0-4c03-9bab-e4314cc2c18e",
    "eventName": {
        "value": "EndRequest",
        "localizedValue": "End request"
    },
    "category": {
        "value": "Administrative",
        "localizedValue": "Administrative"
    },
    "eventTimestamp": "2024-07-01T18:14:36.6160021Z",
    "id": "/subscriptions/fd490646-4466-4b37-aafe-345b0d15dd21/resourcegroups/leadcurrent/providers/Microsoft.Sql/servers/lc-master/databases/onesearch/events/ab5e67b9-73b0-4c03-9bab-e4314cc2c18e/ticks/638554544766160021",
    "level": "Error",
    "operationId": "99634ed1-6894-4f93-a3b6-3ea33ef6fdbc",
    "operationName": {
        "value": "Microsoft.Sql/servers/databases/delete",
        "localizedValue": "Delete SQL database"
    },
    "resourceGroupName": "leadcurrent",
    "resourceProviderName": {
        "value": "Microsoft.Sql",
        "localizedValue": "Microsoft SQL"
    },
    "resourceType": {
        "value": "Microsoft.Sql/servers/databases",
        "localizedValue": "Microsoft.Sql/servers/databases"
    },
    "resourceId": "/subscriptions/fd490646-4466-4b37-aafe-345b0d15dd21/resourcegroups/leadcurrent/providers/Microsoft.Sql/servers/lc-master/databases/onesearch",
    "status": {
        "value": "Failed",
        "localizedValue": "Failed"
    },
    "subStatus": {
        "value": "",
        "localizedValue": ""
    },
    "submissionTimestamp": "2024-07-01T18:16:33Z",
    "subscriptionId": "fd490646-4466-4b37-aafe-345b0d15dd21",
    "tenantId": "a7488d9a-c068-4fc1-a8a4-e1e46bf04fe6",
    "properties": {
        "statusMessage": "{\"status\":\"Failed\",\"error\":{\"code\":\"ResourceOperationFailure\",\"message\":\"The resource operation completed with terminal provisioning state 'Failed'.\",\"details\":[{\"code\":\"InternalServerError\",\"message\":\"An unexpected error occured while processing the request. Tracking ID: '68343e49-e04e-47ff-8d4c-ae34e04e4128'\"}]}}",
        "eventCategory": "Administrative",
        "entity": "/subscriptions/fd490646-4466-4b37-aafe-345b0d15dd21/resourcegroups/leadcurrent/providers/Microsoft.Sql/servers/lc-master/databases/onesearch",
        "message": "Microsoft.Sql/servers/databases/delete",
        "hierarchy": "fd490646-4466-4b37-aafe-345b0d15dd21"
    },
    "relatedEvents": []
}