search

DrJohnT / AzureDevOpsExtensionsForSqlServer

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

Error on Update SSAS tabular cube data source #2

Closed indiefunda closed 3 years ago

indiefunda commented 5 years ago

Hey,

thanks for your contribution, you have done an amazing job, I am trying to deploy a tabular cube 1400 model with your Azure addon and it succeeds but when I am using the task "Update SSAS tabular cube data source" in order to change connection string of the data source (we have many environments as you guess) I get the following error

"Cannot bind argument to parameter 'InputObject' because it is null."

It doesn't help much debugging the error but I would be glad if you have some ideas on that.

Thanks, Achilles

DrJohnT commented 5 years ago

Hey Achilles, glad you like the extension. Took some time to create and document this plus the underpinning PowerShell module DeployCube. How many data source connections does your model have? My code finds the first one and replaces that. I did consider providing a field to enter the name of the data source in the model, but the new 1400 model seems to auto-generate the name, so the developer may now know what the name of data source is.

To debug, try doing the deployment using Update-TabularCubeDataSource in my DeployCube PowerShell module. See Update-TabularCubeDataSource

My DeployCube repository has a whole test suite, so you should be able to simply change the tests for Update-TabularCubeDataSource with your own model and server names. Run the tests using Invoke-Pester.

If you do not manage to debug, please post the DataSource section of the model's JSON here and I will take a look.

indiefunda commented 5 years ago

Hello John,

actually we have just one data source but even though it is a 1400 model we are using the legacy mode of inserting data into our model. I guess this is where it gets complicated. I will try to see what you are suggesting.

Thanks :)

DrJohnT commented 3 years ago

@indiefunda I have recently done a lot of work on the Update Tabular Cube Data Source Task within the Deploy Tabular Model extension. Please check it out.