An unexpected error occured while processing the request. Tracking ID

Mike Sarafidis 1

I have a powershell script that I had successfully used a couple of days before and created a MySQL Flex database.

I tried to create another database and I was getting an error regarding admin login. I have made some efforts until I understand that "-" are not supported at admin username. After fixing this issue I am getting the following error while trying to create the database.

"An unexpected error occured while processing the request. Tracking ID: XXXX"

StackTrace      :    at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate_Call(HttpRequestMessage request, Func`3 onOk, Func`3 onDefault, IEventListener eventListener, ISendAsync sender)
                     at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate_Call(HttpRequestMessage request, Func`3 onOk, Func`3 onDefault, IEventListener eventListener, ISendAsync sender)
                     at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate(String subscriptionId, String resourceGroupName, String serverName, IServerAutoGenerated body, Func`3 onOk, Func`3 onDefault, IEventListener eventList 
                  ener, ISendAsync sender)
                     at Microsoft.Azure.PowerShell.Cmdlets.MySql.Cmdlets.NewAzMySqlFlexibleServer_CreateExpanded.ProcessRecordAsync()

Any Ideas?

Rich Matheisen 44,776 Reputation points

2023-02-05T22:12:42.8+00:00

A stack trace isn't much help without the accompanying error and the script that produces the error.

Is this any help? https://learn.microsoft.com/en-us/answers/questions/520226/(internalservererror)-an-unexpected-error-occured

Mike Sarafidis 1

I am trying to create a new MySQL flex server with the following powershell script


    New-AzMySqlFlexibleServer -Name $dbname -ResourceGroupName $ResourceGroupName -Location $Location `
    -AdministratorUserName $adminname -AdministratorLoginPassword $password `
    -Sku Standard_B1s -SkuTier Burstable -Version "5.7" -StorageInMb 20480 -Zone 1 -BackupRetentionDay 7 -StorageAutogrow Enabled `
    -Vnet $vnet.Name -Subnet $MysqlSubnet.Name -PrivateDnsZone $Zone.ResourceId

and this is the complete error outcome

New-AzMySqlFlexibleServer_CreateExpanded: C:\Users\mike\Documents\PowerShell\Modules\Az.MySql\1.0.0\custom\New-AzMySqlFlexibleServer.ps1:376:9
Line |
 376 |          $Server = Az.MySql.internal\New-AzMySqlFlexibleServer @PSBoun …
     |          ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | An unexpected error occured while processing the request. Tracking ID: 'dd05c1dc-7f55-4dde-99e5-7d1571fcaf21'
Creating database flexibleserverdb...
WARNING: New-AzMySqlFlexibleServerDatabase_Create is not found. The most similar Azure PowerShell command is:
        New-AzMySqlFlexibleServerDatabase
WARNING: The intelligent recommendation feature is in preview. Help us improve it by sharing your experience: https://go.microsoft.com/fwlink/?linkid=2202436
New-AzMySqlFlexibleServerDatabase_Create: C:\Users\mike\Documents\PowerShell\Modules\Az.MySql\1.0.0\custom\New-AzMySqlFlexibleServer.ps1:384:9
Line |
 384 |          $null = New-AzMySqlFlexibleServerDatabase -Name $DEFAULT_DB_N …
     |          ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | The server 'theka-mysql-flex-production' does not exist or in unexpected status.

Exception: C:\Users\mike\Documents\PowerShell\Modules\Az.MySql\1.0.0\custom\New-AzMySqlFlexibleServer.ps1:391:9
Line |
 391 |          $Server.DatabaseName = $DEFAULT_DB_NAME
     |          ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | The property 'DatabaseName' cannot be found on this object. Verify that the property exists and can be set.



ErrorRecord                 : The property 'DatabaseName' cannot be found on this object. Verify that the property exists and can be set.
WasThrownFromThrowStatement : True
TargetSite                  : Void CheckActionPreference(System.Management.Automation.Language.FunctionContext, System.Exception)
Message                     : The property 'DatabaseName' cannot be found on this object. Verify that the property exists and can be set.
Data                        : {[System.Management.Automation.Interpreter.InterpretedFrameInfo, System.Management.Automation.Interpreter.InterpretedFrameInfo[]]}
InnerException              : 
HelpLink                    : 
Source                      : System.Management.Automation
HResult                     : -2146233087
StackTrace                  :    at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
                                 at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
                                 at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
                                 at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)

TargetSite     : 
Message        : [ServerNotExist] : The server 'theka-mysql-flex-production' does not exist or in unexpected status.
Data           : {}
InnerException : 
HelpLink       : 
Source         : 
HResult        : -2146233088
StackTrace     : 

StatusCode      : OK
Code            : InternalServerError
RequestMessage  : Method: GET, RequestUri: 'https://management.azure.com/subscriptions/xxxxxxxxxxxxxxxx/providers/Microsoft.DBforMySQL/locations/francecentral/azureAsyncOperation/94035ce9-7a0d-4fca-8991-3966436d08f7?api-ver 
                  sion=2021-05-01', Version: 1.1, Content: <null>, Headers:
                  {
                    Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyIsImtpZCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyJ9.eyJhdWQiOiJodHRwczovL21hbmFnZW1lbnQuY29yZS53aW5kb3dzLm5ldC8iLCJpc3Mi 
             
                  GtCdXF0SmRRcGd6dU9XSzFUcHNIelNDL3BlNEVLM1FNVHRwdUZNK1VDalhGZ1R3eHBDTC9RNlBJc2ZrYlVNY2FyeTJ0L252V094SGFPbXpEV2JFPSIsImFtciI6WyJwd2QiLCJyc2EiLCJtZmEiXSwiYXBwaWQiOiIxOTUwYTI1OC0yMjdiLTRlMzEtYTljZi03MTc0OTU5NDVmYzIiLCJhcHBpZGFjci 
                  I6IjAiLCJkZXZpY2VpZCI6IjE2ZDFjZmQyLTNkOGYtNDRkYy04YjBhLTFmNjFlYWM0OTdjMCIsImZhbWlseV9uYW1lIjoiU2FyYWZpZGlzIiwiZ2l2ZW5fbmFtZSI6Ik1pa2UiLCJncm91cHMiOlsiZDg0MDAwYzYtOWVhMy00ZDI3LWFlOGItNDBmZjYyNGVmZWU3IiwiNzMwZGI0MTItMzNkNi00Y2I 
                  xLThlMGQtNDE5MDk2NDQxNzg3IiwiYjBjMDMwM2UtYmVkNS00NTMwLWJmNmQtMmVlODczYzgxZTRhIiwiNTU5NmUwNGEtNWNjZi00NTUwLTlmZDctZjBjNjZmMWMwMTRiIiwiYjM2MTM3ODgtOTliYS00ZGU5LWI4MmQtM2I2NzllMTY5NDhiIiwiMTc1NDE4YzAtODQ2MS00OGUyLTk1ZTktMTA2Y2I5 
                  YzYzZWIwIl0sImlwYWRkciI6IjEwOS4yNDIuNzYuMjU0IiwibmFtZSI6Ik1pa2UgU2FyYWZpZGlzIiwib2lkIjoiMGU4NDQyN2MtNWEwNC00NTVhLTg1ZTgtNDU5Y2EwODEyZGMxIiwicHVpZCI6IjEwMDNCRkZEQUIxRTRBN0IiLCJyaCI6IjAuQVY0QUJSRU9QS3VTUTAyZzFDaDU2c05SVUVaSWYza 
                  0F1dGRQdWtQYXdmajJNQk5lQUZvLiIsInNjcCI6InVzZXJfaW1wZXJzb25hdGlvbiIsInN1YiI6Imt6WDByQ1VYMUc2OF9YNFZ0MWFac01QRWN1cGxmQ2hkQlNrS3l0Q0JaMlEiLCJ0aWQiOiIzYzBlMTEwNS05MmFiLTRkNDMtYTBkNC0yODc5ZWFjMzUxNTAiLCJ1bmlxdWVfbmFtZSI6InNhcmFmaW 
                  Rpc0BzZW1pdHJvbi5nciIsInVwbiI6InNhcmFmaWRpc0BzZW1pdHJvbi5nciIsInV0aSI6IkdIQWU2VmV0aVVteXpQX1JGNERyQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMjE3NzE0NWUxMCIsImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU 
                  4NTUwOSJdLCJ4bXNfY2MiOlsiQ1AxIl0sInhtc190Y2R0IjoxNDIyMTEwMDQwfQ.p8kYrPCIrsCyF3-DAuaU3UByihPZMgXwAZGol6qzubhGf6NSpKE_DyLgRFQJ2JmDSQSWXgkG7houB-s09Vpvbjo5YxkEqbQNF0qAZ2DLf42eyuz4mj-B-_kHqG3YmJqi57GYE2NK32O2Oesc63Qt8UokIHxsfY0wu 
              
                  }
ResponseHeaders : {[Cache-Control, System.String[]], [Pragma, System.String[]], [Retry-After, System.String[]], [X-Content-Type-Options, System.String[]]…}
ResponseBody    : {"name":"94035ce9-7a0d-4fca-8991-3966436d08f7","status":"Failed","startTime":"2023-02-06T05:48:47.55Z","error":{"code":"InternalServerError","message":"An unexpected error occured while processing the request. Tracking ID: 'd 
                  d05c1dc-7f55-4dde-99e5-7d1571fcaf21'"}}
ClientRequestId :
RequestId       : dd05c1dc-7f55-4dde-99e5-7d1571fcaf21
Message         : An unexpected error occured while processing the request. Tracking ID: 'dd05c1dc-7f55-4dde-99e5-7d1571fcaf21'
Action          :
TargetSite      : Void MoveNext()
Data            : {}
InnerException  :
HelpLink        :
Source          : Az.MySql.private
HResult         : -2146233088
StackTrace      :    at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate_Call(HttpRequestMessage request, Func`3 onOk, Func`3 onDefault, IEventListener eventListener, ISendAsync sender)
                     at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate_Call(HttpRequestMessage request, Func`3 onOk, Func`3 onDefault, IEventListener eventListener, ISendAsync sender)
                     at Microsoft.Azure.PowerShell.Cmdlets.MySql.MySql.FlexibleServersCreate(String subscriptionId, String resourceGroupName, String serverName, IServerAutoGenerated body, Func`3 onOk, Func`3 onDefault, IEventListener eventList 
                  ener, ISendAsync sender)
                     at Microsoft.Azure.PowerShell.Cmdlets.MySql.Cmdlets.NewAzMySqlFlexibleServer_CreateExpanded.ProcessRecordAsync()

Mike Sarafidis 1 Reputation point

2023-02-06T06:30:55.54+00:00

@Rich Matheisen Regarding your provided link, I have tried to delete the whole resource group and recreate all the resources from the scratch and it always stops at the above error.