drjohnt / deploycube Goto Github PK

I'm getting the following error in Publish-Cube even though the PreferredVersion passed in is 140 (which IS in the list).

Error: Cannot validate argument on parameter 'Version'. The argument "" does not belong to the set "150,140,130,120,110,latest"

Here is the section that shows what is set as the PreferredVersion:

2019-06-25T22:17:09.7708205Z Invoking Publish-Cube from DeployCube module with the following parameters:
2019-06-25T22:17:09.7712494Z AsDatabasePath: D:\AzureDevOpsAgent_work\3\s\xxx\bin\Development\xxx.asdatabase
2019-06-25T22:17:09.7716702Z AsServer: xxx
2019-06-25T22:17:09.7720932Z CubeDatabaseName: xxx Data Mart
2019-06-25T22:17:09.7724964Z PreferredVersion: 140

Calling the Publish-Cube

The term 'Get-SsasSourceConnectionString' is not recognized as a name of a cmdlet, function, script
| file, or executable program. Check the spelling of the name, or if a path was included, verify that
| the path is correct and try again.

Looks it is only being called on Update-AnalysisServicesConfig.ps1, should this reference be something else?

Hi, we use this task to deploy database schema. This started failing recently with the following error,

2021-01-11T21:10:49.7014850Z ##[error]Error: Cannot validate argument on parameter 'Version'. The argument "" does not belong to the set "150,140,130,120,110,15,14,13,12,11" specified by the ValidateSet attribute. Supply an argument that is in the set and then try the command again.

I confirmed that the sqlpackage.exe is on the deployment server. Please help us identify the actual issue and resolving it.

Thank you.

I'm trying to utilize this script as part of a Github Action but the runners that are used to come installed with Microsoft.AnalysisServices.Deployment.exe. When attempting to install it on the VM I get an error saying " The specified executable is
| not a valid application for this OS platform". Is there a workaround to this issue?

Hello,

We have a need to update data sources on a SSAS cube. The cube has multiple data sources that need to be updated:

• SSAS_Cube
  • Connections
    • Data Source 1 (Windows)
    • Data Source 2 (SQL)

I attempted to implement this using the Update-TabularCubeDataSource cmdlet but I found that only the first data source was updated.

I reviewed the code in Update-TabularCubeDataSource.ps1 and found when more than one row is returned for $rows, only the first row is affected. I'm wondering if you want to resolve this issue in your module yourself, or perhaps would be open to me doing a pull request. Or perhaps you don't want to handle this problem at all.

Please let me know.

Regards,
Tyler

The Microsoft.AnaylsisServices.Deployment.exe is installed with Microsoft SQL server Management Studio
I have tried installing different version of SSMS but none of them are installing the EXE file to the location

Location of Microsoft.AnaylsisServices.Deployment.exe.




Please advise how you would like to proceed?

Please help me to resolve. As it is higher blocker for me..need to resolve this ASAP. I am using self-hosted agent..

Hi,
Trying to use you Publish-Cube command with psexec, give me this error "Invalid SSAS Server" with the right name of destination SSAS server.

There is my powershell script

param ( [Parameter(Position=0,Mandatory=$true)] [string]$cubename, [Parameter(Position=1,Mandatory=$true)] [string]$cubenameprod, [Parameter(Position=2,Mandatory=$true)] [string]$dest ) $cubenamefull=Get-ChildItem -Path D: -Include *.asdatabase -recurse -File -Name | Select-String -pattern "bin" | Select-String -pattern $cubename $cubefullpath="D:\"+$cubenamefull copy $cubefullpath $cubefullpath-ori (Get-Content $cubefullpath) | ForEach-Object {$_ -replace 'lolo','loulou'} | Out-File $cubefullpath Publish-Cube -asDatabasePath $cubefullpath -Server $dest -CubeDatabase $cubenameprod copy $cubefullpath-ori $cubefullpath rm $cubefullpath-ori

Can you help me around this problem please?

Dear Mr John,
First of all I would like to truly thank you for your contribution on the custom tasks you created for the pipelines.
For now I have two environments Acceptance and Test.
In both environments:

• I am able to publish successfully the Tabular cube.
• I setup the self hosted agent under 'Network Service', which this login has sysadmin role in both SQL Servers.
• The 'Network Service' is a server administrator on the Cube.
• Configuration-> SSAS Server Name or IP address: localhost, Impersonation mode to be used by the data source: Use the SSAS service account(default) (The only different between environments is the SourceSqlServer)
  The issue that I am facing is that I cannot update the SSAS tabular cube data source on Acceptance, where in Test it succeeds.
  ##[error]SSAS Server localhost not found
  Am I missing/forgot something? Do you have any clue what may causing that?