错误:在模块"AzureRM.Sql"中找到了"Get-AzureRmSqlDatabase"命令 [英] Error: The 'Get-AzureRmSqlDatabase' command was found in the module 'AzureRM.Sql'

问题描述

我们今天已经观察到一个Azure自动化作业实例抛出了一个错误，详细信息如下所示

We have observed today that one of the Azure automation job instance threw an error with details as below

Get-AzureRmSqlDatabase : The 'Get-AzureRmSqlDatabase' command was found in the module 'AzureRM.Sql', but the module 
could not be loaded. For more information, run 'Import-Module AzureRM.Sql'.
At Set-AzureSqlDatabaseEdition:49 char:49
+ 
    + CategoryInfo          : ObjectNotFound: (Get-AzureRmSqlDatabase:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CouldNotAutoloadMatchingModule

现在有趣的是，还有其他自动化作业实例是通过调用非常相似的自动化Runbook来运行的，似乎运行良好.请注意，我们确实在webhooks的帮助下调用了这些作业，并且一次调用了8到10个作业，每个webhook 请求包含不同的参数值，这些参数值被馈送到运行手册.简而言之，可以说所有调用都运行良好，只是一次调用听起来不正确，因为底层运行手册是完全相同的.

Now interestingly, there are other automation job instances originated by invoking very same automation runbook seems to be running fine. Note that we do invoke these jobs with the help of webhooks and at a time 8 to 10 jobs are invoked and each webhook request contains different parameter values which are fed to the runbook. So in a nutshell, say all invocations ran fine except one which does not sound right since the underlying runbook is exactly the same. 

任何人都可以帮助您确定可能出了什么问题吗?可能是Azure停机问题吗?

Can anyone help in identifying what could have went wrong? Could it be an Azure outage issue?

谢谢.

Bhushan Gawale | RapidCircle

Bhushan Gawale | RapidCircle

推荐答案

您好，Bhushan，它看起来像导入模块AzureRM.Sql"；在调用"Get-AzureRmSqlDatabase"之前解决了受影响实例上的问题?

Hi Bhushan, it looks like AzureRM.Sql module did not load properly. Can you please check if adding "Import-Module AzureRM.Sql" before calling "Get-AzureRmSqlDatabase" solves the issue on the affected instance? 

这篇关于错误:在模块"AzureRM.Sql"中找到了"Get-AzureRmSqlDatabase"命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！