none
SQL elastic pool has error initializing due to missing parameters? RRS feed

  • Question

  • During the exercise of Microsoft Azure (scale-sql-databases-elastic-pools/3-exercise-create-elastic-pool) to create a SQL elastic pool, Azure Portal returns an error when configuring the elastic pool.

    Specifically when creating the new resource: "Create SQL Elastic pool" and while clicking on Configure elastic pool it returns the error below in Azure Portal:

    Summary
    Session ID
    3b5c385df0784ea8b04f882ff8e2cee1
    Resource ID
    Not available
    Extension
    SqlAzureExtension
    Content
    ConfigureElasticPoolPerformanceBlade
    Error code
    --
    Error reason
    ErrorInitializing
    Details
    The blade Extension/SqlAzureExtension/Blade/CreateElasticPoolFromGalleryBlade failed to supply all the required parameters. The missing the required parameter(s) 'poolConfiguration, regionId, subscriptionId'.

    Did other people get same error whilst doing the exercise to create SQL Elastic Pool in Azure?

    Saturday, September 7, 2019 3:33 PM

All replies

  • During the exercise of Microsoft Azure (scale-sql-databases-elastic-pools/3-exercise-create-elastic-pool) to create a SQL elastic pool, Azure Portal returns an error when configuring the elastic pool.

    Specifically when creating the new resource: "Create SQL Elastic pool" and while clicking on Configure elastic pool it returns the error below in Azure Portal:

    Summary
    Session ID
    3b5c385df0784ea8b04f882ff8e2cee1
    Resource ID
    Not available
    Extension
    SqlAzureExtension
    Content
    ConfigureElasticPoolPerformanceBlade
    Error code
    --
    Error reason
    ErrorInitializing
    Details
    The blade Extension/SqlAzureExtension/Blade/CreateElasticPoolFromGalleryBlade failed to supply all the required parameters. The missing the required parameter(s) 'poolConfiguration, regionId, subscriptionId'.

    Did other people get same error whilst doing the exercise to create SQL Elastic Pool in Azure?

    Good day David,

    >> failed to supply all the required parameters. The missing the required parameter(s) 'poolConfiguration, regionId, subscriptionId'.

    According to the error details it seems like you did not filled all the parameters which are required. Try again, and make sure that you go step by step and in the form you fill all the fields including the poolConfiguration, regionId, subscriptionId


    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    Saturday, September 7, 2019 10:46 PM
    Moderator
  • Hi David,

    Can you please provide the full URL for the tutorial you are attempting to follow? Specific to the error message, the following three required parameters are missing:

    The missing the required parameter(s) 'poolConfiguration, regionId, subscriptionId'.

    So, are these steps completed in a previous section of the tutorial and you returned to the Azure Portal to complete the next steps (need to re-authenticate in the portal)? Or this could be a bug. I would like to attempt to replicate your issue.

    Thank you,

    Mike

    Tuesday, September 10, 2019 2:28 AM
    Moderator
  • David is referring to this Microsoft Learn lab "Scale multiple Azure SQL Databases with SQL elastic pools" exercise 3 https://docs.microsoft.com/en-in/learn/modules/scale-sql-databases-elastic-pools/3-exercise-create-elastic-pool.

    I can confirm that it's the issue when doing it from the Sandbox. @David12321, unfortunately there's nothing much that can be done here, seems like an issue with the Sandbox.

    Tuesday, September 10, 2019 6:24 AM
  • Thank you for this additional detail.

    At the bottom of the page is the ability to report an issue:

    Please leverage this communication channel to report this issue or any other issue you might experience with the lab.

    Regards,

    Mike

    Tuesday, September 10, 2019 11:00 PM
    Moderator
  • Thanks Sangram Rath for confirming
    +5

    I also tested and you are right. There is a bug in the learning account



    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    Wednesday, September 11, 2019 2:19 AM
    Moderator