The server sent an unrecognizable response

[franciscomenezes]

Hi,

We are using the on Azure devops for the last 1year and so far everything was working good.

Now we are adding a new model\database, and its has an strange behavior. Some times works and other times show the error:

[error]Error during deploying the model (The server sent an unrecognizable response.)

The strange thing its on the server side, Model is deployed and looks good. but on the release it shows error and does not allow the process to go on.

We are using the model version 1500. But we are using for another models and they are working fine. I guess its a problem on the model, but working on the server side and not showing anything else than a message with only "Error during deploying the model (The server sent an unrecognizable response.)" its very frustrating.

Hope you guys can help

Thank you Francisco Menezes

[liprec]

@franciscomenezes currently I haven't tested the deployment task with the compat level 1500. I know that the model files are different between the compat levels and this could cause this error. Are you only getting it with the 1500 models?

[joanteixi]

Hi,

I'm getting same error in same scenario, deploying model in Azure Analysis Services 1500. Sometimes it fails, with the error:

Error during deploying the model (The server sent an unrecognizable response.). In my scenario, I deploy a model (works perfect) and the process the model. This is the step when sometime I get the error.

I'm deploying in three diferents models (with three different pipelines) and happens in all three...

Do you know If It's possible to get more info of the error?

2021-02-10T21:40:38.1354368Z ##[command]Import-Module -Name C:\Modules\azurerm_2.1.0\AzureRM\2.1.0\AzureRM.psd1 -Global
2021-02-10T21:40:42.1944495Z ##[warning]The names of some imported commands from the module 'AzureRM.Websites' include unapproved verbs that might make them less discoverable. To find the commands with unapproved verbs, run the Import-Module command again with the Verbose parameter. For a list of approved verbs, type Get-Verb.
2021-02-10T21:40:42.2297989Z ##[command]Clear-AzureRmContext -Scope Process
2021-02-10T21:40:42.5810649Z ##[command]Disable-AzureRmContextAutosave -ErrorAction Stop
2021-02-10T21:40:43.2375841Z ##[command]Add-AzureRMAccount -ServicePrincipal -Tenant *** -Credential System.Management.Automation.PSCredential -Environment AzureCloud @processScope
2021-02-10T21:40:43.7692186Z ##[command] Select-AzureRMSubscription -SubscriptionId 73db703b-b14f-4929-93c1-9561744bb5b0 -TenantId ***
2021-02-10T21:42:53.7751768Z ##[error]Error during deploying the model (The server sent an unrecognizable response.)
2021-02-10T21:42:53.8432383Z ##[section]Finishing: Process SSAS

Maybe, with more info, we can figure otut wich is the problem!

(and congratulations for this vsts-release!)

[joanteixi]

Hi! I found the issue... I run the process script directly from SSMS:

{  
  "refresh": {  
    "type": "full",  
    "objects": [  
      {  
        "database": "databse_name"  
      }  
    ]  
  }  
} 

And get a warning error:

   <Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception">
      <Warning WarningCode="1094320150" Description="The end of the input was reached." Source="Microsoft Analysis Services" HelpFile="">
        <Location xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100="http://schemas.microsoft.com/analysisservices/2008/engine/100" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400" xmlns:ddl410="http://schemas.microsoft.com/analysisservices/2012/engine/410" xmlns:ddl410_410="http://schemas.microsoft.com/analysisservices/2012/engine/410/410" xmlns:ddl500="http://schemas.microsoft.com/analysisservices/2013/engine/500" xmlns:ddl500_500="http://schemas.microsoft.com/analysisservices/2013/engine/500/500" xmlns:ddl600="http://schemas.microsoft.com/analysisservices/2013/engine/600" xmlns:ddl600_600="http://schemas.microsoft.com/analysisservices/2013/engine/600/600" xmlns:ddl700="http://schemas.microsoft.com/analysisservices/2018/engine/700" xmlns:ddl700_700="http://schemas.microsoft.com/analysisservices/2018/engine/700/700" xmlns:ddl800="http://schemas.microsoft.com/analysisservices/2018/engine/800" xmlns:ddl800_800="http://schemas.microsoft.com/analysisservices/2018/engine/800/800" xmlns:ddl900="http://schemas.microsoft.com/analysisservices/2019/engine/900" xmlns:ddl900_900="http://schemas.microsoft.com/analysisservices/2019/engine/900/900" xmlns:ddl910="http://schemas.microsoft.com/analysisservices/2020/engine/910" xmlns:ddl910_910="http://schemas.microsoft.com/analysisservices/2020/engine/910/910" xmlns:ddl920="http://schemas.microsoft.com/analysisservices/2020/engine/920" xmlns:ddl920_920="http://schemas.microsoft.com/analysisservices/2020/engine/920/920">
          <Start>
            <Line>0</Line>
            <Column>0</Column>
          </Start>
          <End>
            <Line>0</Line>
            <Column>0</Column>
          </End>
          <LineOffset>0</LineOffset>
          <TextLength>0</TextLength>
          <ddl200:SourceObject>
            <ddl500_500:TableName>Ind_Ventas Rango</ddl500_500:TableName>
            <ddl500_500:CalculationItemName>Ingresos/TN</ddl500_500:CalculationItemName>
          </ddl200:SourceObject>
        </Location>
      </Warning>
    </Messages>
  </root>
</return>

That is the reason why the pipeline throws an "unrecognizable response". Should be nice to fix this and show the "real" error from SSAS.

Thanks!

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.