DrJohnT / AzureDevOpsExtensionsForSqlServer

Microsoft SQL Server deployment extensions for Azure DevOps Pipelines
MIT License
20 stars 14 forks source link

Deploy SSAS tabular cube model Version : 1.1.8 error #24

Closed vmihay closed 3 years ago

vmihay commented 3 years ago

Component: DeployTabularModel

Description: The component has been running ok at Version 1.1.7. However, since it was auto updated to version : 1.1.8 the task stared to fail with the following error message:

2021-01-07T07:29:19.6200982Z ##[section]Starting: Deploy SSAS tabular model 2021-01-07T07:29:19.6300444Z ============================================================================== 2021-01-07T07:29:19.6300759Z Task : Deploy SSAS tabular cube model 2021-01-07T07:29:19.6301020Z Description : Publish a tabular cube model to an SSAS instance 2021-01-07T07:29:19.6301217Z Version : 1.1.8 2021-01-07T07:29:19.6301387Z Author : Dr. John Tunnicliffe 2021-01-07T07:29:19.6302268Z Help : More Information 2021-01-07T07:29:19.6302650Z ============================================================================== 2021-01-07T07:29:20.5999847Z ##[error]Cannot convert value "System.String" to type "System.Boolean". Boolean parameters accept only Boolean values and numbers, such as $True, $False, 1 or 0. 2021-01-07T07:29:20.6255362Z ##[section]Finishing: Deploy SSAS tabular model

Azure DevOps Agent In-house hosted Agent version 2.179.0

Additional information

Existing pipelines (set to run with the older ver 1.17) had to be updated image

image

This warning disappeared when I updated the relevant Deployment option Version of Microsoft.AnalysisServices.Deployment.exe to use for the deployment image

Then I saved the pipeline and re-run the deployment pipeline with the updated task, which fails with the following error message: [error]Cannot convert value "System.String" to type "System.Boolean". Boolean parameters accept only Boolean values and numbers, such as $True, $False, 1 or 0.

vmihay commented 3 years ago

Complements to the author for the speedy fix, which is much appreciated. The task now works. I tested it with Version: 1.1.10

DrJohnT commented 3 years ago

No problem :-)