2022-01-04T07:30:33.9055515Z ##[debug]Evaluating condition for step: 'Deploy model Smart Cleaning' 2022-01-04T07:30:33.9057998Z ##[debug]Evaluating: succeeded() 2022-01-04T07:30:33.9058811Z ##[debug]Evaluating succeeded: 2022-01-04T07:30:33.9061608Z ##[debug]=> True 2022-01-04T07:30:33.9062544Z ##[debug]Result: True 2022-01-04T07:30:33.9063384Z ##[section]Starting: Deploy model Smart Cleaning 2022-01-04T07:30:33.9392907Z ============================================================================== 2022-01-04T07:30:33.9393442Z Task : Tabular Database Deployment 2022-01-04T07:30:33.9394584Z Description : Deploy tabular databases to Azure Analysis Services or Power BI Premium 2022-01-04T07:30:33.9395061Z Version : 1.5.2 2022-01-04T07:30:33.9395438Z Author : Jan Pieter Posthuma 2022-01-04T07:30:33.9397810Z Help : [More Information](https://github.com/liprec/vsts-release-aas) 2022-01-04T07:30:33.9398500Z ============================================================================== 2022-01-04T07:30:39.1508481Z ##[debug]VstsTaskSdk 0.11.0 commit 7ff27a3e0bdd6f7b06690ae5f5b63cb84d0f23f4 2022-01-04T07:30:39.7431994Z ##[debug]Entering D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\deploy-aas-db.ps1. 2022-01-04T07:30:39.7957408Z ##[debug]INPUT_CONNECTEDSERVICENAMESELECTOR: 'ConnectedServiceNameARM' 2022-01-04T07:30:39.7996620Z ##[debug]INPUT_CONNECTEDSERVICENAMEARM: 'a8c785f4-3c77-49ba-9c23-642ca0238d9d' 2022-01-04T07:30:39.8513221Z ##[debug]ENDPOINT_URL_a8c785f4-3c77-49ba-9c23-642ca0238d9d: 'https://management.azure.com/' 2022-01-04T07:30:39.8601979Z ##[debug]ENDPOINT_AUTH_a8c785f4-3c77-49ba-9c23-642ca0238d9d: '********' 2022-01-04T07:30:39.8658587Z ##[debug]ENDPOINT_DATA_a8c785f4-3c77-49ba-9c23-642ca0238d9d: '{"subscriptionId":"xxxxxxxxxxxxxxxxxxxxxxxxx" 2022-01-04T07:30:39.8806374Z ##[debug]INPUT_AASSERVER: '***' 2022-01-04T07:30:39.8842689Z ##[debug]INPUT_DATABASENAME: 'Smart Cleaning' 2022-01-04T07:30:39.8884091Z ##[debug]INPUT_MODELNAME (empty) 2022-01-04T07:30:39.9036532Z ##[debug]INPUT_LOGINTYPE: 'spn' 2022-01-04T07:30:39.9131775Z ##[debug]INPUT_PATHTOMODEL: 'D:\a\r1\a\Vebego Azure DWH\Vebego Azure DWH\Smart Cleaning\Model.bim' 2022-01-04T07:30:39.9136095Z ##[debug]INPUT_SOURCESQLSERVER: '***' 2022-01-04T07:30:39.9138996Z ##[debug]INPUT_SOURCESQLDATABASE: '***' 2022-01-04T07:30:39.9177689Z ##[debug]INPUT_SOURCESQLUSERNAME: '***' 2022-01-04T07:30:39.9232936Z ##[debug]INPUT_SOURCESQLPASSWORD: '***' 2022-01-04T07:30:39.9290285Z ##[debug]INPUT_DATASOURCES: '[ 2022-01-04T07:30:39.9322776Z ##[debug] { 2022-01-04T07:30:39.9397752Z ##[debug] "name": "", 2022-01-04T07:30:39.9444542Z ##[debug] "authenticationKind": "UsernamePassword", 2022-01-04T07:30:39.9452581Z ##[debug] "connectionDetails": { 2022-01-04T07:30:39.9482670Z ##[debug] "address": { 2022-01-04T07:30:39.9506524Z ##[debug] "server": "", 2022-01-04T07:30:39.9536091Z ##[debug] "database": "" 2022-01-04T07:30:39.9556346Z ##[debug] } 2022-01-04T07:30:39.9585581Z ##[debug] }, 2022-01-04T07:30:39.9646576Z ##[debug] "credential": { 2022-01-04T07:30:39.9673374Z ##[debug] "Username": "", 2022-01-04T07:30:39.9704162Z ##[debug] "Password": "" 2022-01-04T07:30:39.9759696Z ##[debug] } 2022-01-04T07:30:39.9786750Z ##[debug] } 2022-01-04T07:30:39.9817760Z ##[debug]]' 2022-01-04T07:30:40.0218148Z ##[debug]INPUT_OVERWRITE: 'true' 2022-01-04T07:30:40.0221921Z ##[debug] Converted to bool: True 2022-01-04T07:30:40.0622453Z ##[debug]INPUT_REMOVE: 'false' 2022-01-04T07:30:40.0630868Z ##[debug] Converted to bool: False 2022-01-04T07:30:40.0633831Z ##[debug]INPUT_PARTITIONDEPLOYMENT: 'deploypartitions' 2022-01-04T07:30:40.0639261Z ##[debug]INPUT_ROLEDEPLOYMENT: 'retainroles' 2022-01-04T07:30:40.0645536Z ##[debug]INPUT_IPDETECTIONMETHOD: 'autoDetect' 2022-01-04T07:30:40.0655787Z ##[debug]INPUT_DELETEFIREWALLRULE: 'true' 2022-01-04T07:30:40.0658838Z ##[debug] Converted to bool: True 2022-01-04T07:30:40.0824738Z ##[debug]Loading module from path 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\ps_modules\VstsAzureRestHelpers_\VstsAzureRestHelpers_.psm1'. 2022-01-04T07:30:40.1156004Z ##[debug]$OVERRIDING $global:DebugPreference from 'Continue' to 'SilentlyContinue'. 2022-01-04T07:30:40.1190612Z ##[debug]Loading resource strings from: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\ps_modules\VstsAzureRestHelpers_/module.json 2022-01-04T07:30:40.1564257Z ##[debug]Loaded 11 strings. 2022-01-04T07:30:40.1627393Z ##[debug]SYSTEM_CULTURE: 'en-US' 2022-01-04T07:30:40.1659385Z ##[debug]Loading resource strings from: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\ps_modules\VstsAzureRestHelpers_\Strings\resources.resjson\en-US\resources.resjson 2022-01-04T07:30:40.2260374Z ##[debug]Loaded 11 strings. 2022-01-04T07:30:40.2265020Z ##[debug]Loading module from path 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\ps_modules\TlsHelper_\TlsHelper_.psm1'. 2022-01-04T07:30:40.2274191Z ##[debug]Loading resource strings from: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\ps_modules\TlsHelper_/module.json 2022-01-04T07:30:40.2292758Z ##[debug]Loaded 3 strings. 2022-01-04T07:30:40.2340021Z ##[debug]SYSTEM_CULTURE: 'en-US' 2022-01-04T07:30:40.2371804Z ##[debug]Loading resource strings from: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\ps_modules\TlsHelper_\Strings\resources.resjson\en-US\resources.resjson 2022-01-04T07:30:40.2484217Z ##[debug]Loaded 3 strings. 2022-01-04T07:30:40.2513609Z ##[debug]Exporting function 'Add-Tls12InSession'. 2022-01-04T07:30:40.2538783Z ##[debug]Exporting function 'Assert-TlsError'. 2022-01-04T07:30:40.2567584Z ##[debug]Importing function 'Add-Tls12InSession'. 2022-01-04T07:30:40.2603237Z ##[debug]Importing function 'Assert-TlsError'. 2022-01-04T07:30:40.6959982Z ##[debug]TLS 1.2 already present in session. 2022-01-04T07:30:40.6989261Z ##[debug]Exporting function 'Add-AzureSqlDatabaseServerFirewallRule'. 2022-01-04T07:30:40.7104091Z ##[debug]Exporting function 'Remove-AzureSqlDatabaseServerFirewallRule'. 2022-01-04T07:30:40.7105887Z ##[debug]Exporting function 'Get-AzStorageKeys'. 2022-01-04T07:30:40.7107325Z ##[debug]Exporting function 'Get-AzRMStorageKeys'. 2022-01-04T07:30:40.7140299Z ##[debug]Exporting function 'Get-AzRmVmCustomScriptExtension'. 2022-01-04T07:30:40.7167944Z ##[debug]Exporting function 'Remove-AzRmVmCustomScriptExtension'. 2022-01-04T07:30:40.7198553Z ##[debug]Exporting function 'Get-AzStorageAccount'. 2022-01-04T07:30:40.7260038Z ##[debug]Exporting function 'Get-AzRmStorageAccount'. 2022-01-04T07:30:40.7293053Z ##[debug]Exporting function 'Get-AzRmResourceGroup'. 2022-01-04T07:30:40.7321149Z ##[debug]Exporting function 'Get-AzureNetworkInterfaceDetails'. 2022-01-04T07:30:40.7362312Z ##[debug]Exporting function 'Get-AzurePublicIpAddressDetails'. 2022-01-04T07:30:40.7389130Z ##[debug]Exporting function 'Get-AzureLoadBalancersDetails'. 2022-01-04T07:30:40.7424008Z ##[debug]Exporting function 'Get-AzureLoadBalancerDetails'. 2022-01-04T07:30:40.7480513Z ##[debug]Exporting function 'Get-AzureRMLoadBalancerFrontendIpConfigDetails'. 2022-01-04T07:30:40.7482655Z ##[debug]Exporting function 'Get-AzureRMLoadBalancerInboundNatRuleConfigDetails'. 2022-01-04T07:30:40.7519333Z ##[debug]Exporting function 'Get-AzureRMAccessToken'. 2022-01-04T07:30:40.7576440Z ##[debug]Exporting function 'Get-ExceptionMessage'. 2022-01-04T07:30:40.7624480Z ##[debug]Exporting function 'Get-ConnectionType'. 2022-01-04T07:30:40.7669055Z ##[debug]Exporting function 'IsAzureRmConnection'. 2022-01-04T07:30:40.7699725Z ##[debug]Importing function 'Add-AzureSqlDatabaseServerFirewallRule'. 2022-01-04T07:30:40.7732837Z ##[debug]Importing function 'Get-AzRmResourceGroup'. 2022-01-04T07:30:40.7770484Z ##[debug]Importing function 'Get-AzRmStorageAccount'. 2022-01-04T07:30:40.7801247Z ##[debug]Importing function 'Get-AzRMStorageKeys'. 2022-01-04T07:30:40.7840371Z ##[debug]Importing function 'Get-AzRmVmCustomScriptExtension'. 2022-01-04T07:30:40.7891917Z ##[debug]Importing function 'Get-AzStorageAccount'. 2022-01-04T07:30:40.7928081Z ##[debug]Importing function 'Get-AzStorageKeys'. 2022-01-04T07:30:40.7960748Z ##[debug]Importing function 'Get-AzureLoadBalancerDetails'. 2022-01-04T07:30:40.8007272Z ##[debug]Importing function 'Get-AzureLoadBalancersDetails'. 2022-01-04T07:30:40.8031013Z ##[debug]Importing function 'Get-AzureNetworkInterfaceDetails'. 2022-01-04T07:30:40.8086541Z ##[debug]Importing function 'Get-AzurePublicIpAddressDetails'. 2022-01-04T07:30:40.8114345Z ##[debug]Importing function 'Get-AzureRMAccessToken'. 2022-01-04T07:30:40.8150685Z ##[debug]Importing function 'Get-AzureRMLoadBalancerFrontendIpConfigDetails'. 2022-01-04T07:30:40.8198501Z ##[debug]Importing function 'Get-AzureRMLoadBalancerInboundNatRuleConfigDetails'. 2022-01-04T07:30:40.8286661Z ##[debug]Importing function 'Get-ConnectionType'. 2022-01-04T07:30:40.8341206Z ##[debug]Importing function 'Get-ExceptionMessage'. 2022-01-04T07:30:40.8409823Z ##[debug]Importing function 'IsAzureRmConnection'. 2022-01-04T07:30:40.8437062Z ##[debug]Importing function 'Remove-AzRmVmCustomScriptExtension'. 2022-01-04T07:30:40.8477175Z ##[debug]Importing function 'Remove-AzureSqlDatabaseServerFirewallRule'. 2022-01-04T07:30:40.8536912Z ##[debug]Loading module from path 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\VstsAzureRestHelperExtra_.psm1'. 2022-01-04T07:30:40.8701967Z ##[debug]Loading resource strings from: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2/ps_modules/VstsAzureRestHelpers_/module.json 2022-01-04T07:30:40.8816115Z ##[debug]Loaded 11 strings. 2022-01-04T07:30:40.8858029Z ##[debug]SYSTEM_CULTURE: 'en-US' 2022-01-04T07:30:40.8946574Z ##[debug]Loading resource strings from: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\ps_modules\VstsAzureRestHelpers_\Strings\resources.resjson\en-US\resources.resjson 2022-01-04T07:30:40.8999296Z ##[debug]Loaded 11 strings. 2022-01-04T07:30:40.9047617Z ##[debug]Importing function 'Add-Tls12InSession'. 2022-01-04T07:30:40.9099190Z ##[debug]Importing function 'Assert-TlsError'. 2022-01-04T07:30:40.9140592Z ##[debug]TLS 1.2 already present in session. 2022-01-04T07:30:40.9187842Z ##[debug]Importing function 'Add-AzureSqlDatabaseServerFirewallRule'. 2022-01-04T07:30:40.9214140Z ##[debug]Importing function 'Get-AzRmResourceGroup'. 2022-01-04T07:30:40.9242878Z ##[debug]Importing function 'Get-AzRmStorageAccount'. 2022-01-04T07:30:40.9270309Z ##[debug]Importing function 'Get-AzRMStorageKeys'. 2022-01-04T07:30:40.9313568Z ##[debug]Importing function 'Get-AzRmVmCustomScriptExtension'. 2022-01-04T07:30:40.9342956Z ##[debug]Importing function 'Get-AzStorageAccount'. 2022-01-04T07:30:40.9369596Z ##[debug]Importing function 'Get-AzStorageKeys'. 2022-01-04T07:30:40.9399292Z ##[debug]Importing function 'Get-AzureLoadBalancerDetails'. 2022-01-04T07:30:40.9470197Z ##[debug]Importing function 'Get-AzureLoadBalancersDetails'. 2022-01-04T07:30:41.0258694Z ##[debug]Importing function 'Get-AzureNetworkInterfaceDetails'. 2022-01-04T07:30:41.0313047Z ##[debug]Importing function 'Get-AzurePublicIpAddressDetails'. 2022-01-04T07:30:41.0365300Z ##[debug]Importing function 'Get-AzureRMAccessToken'. 2022-01-04T07:30:41.0436397Z ##[debug]Importing function 'Get-AzureRMLoadBalancerFrontendIpConfigDetails'. 2022-01-04T07:30:41.0467119Z ##[debug]Importing function 'Get-AzureRMLoadBalancerInboundNatRuleConfigDetails'. 2022-01-04T07:30:41.0544248Z ##[debug]Importing function 'Get-ConnectionType'. 2022-01-04T07:30:41.0568605Z ##[debug]Importing function 'Get-ExceptionMessage'. 2022-01-04T07:30:41.0596936Z ##[debug]Importing function 'IsAzureRmConnection'. 2022-01-04T07:30:41.0660549Z ##[debug]Importing function 'Remove-AzRmVmCustomScriptExtension'. 2022-01-04T07:30:41.0693512Z ##[debug]Importing function 'Remove-AzureSqlDatabaseServerFirewallRule'. 2022-01-04T07:30:41.0755232Z ##[debug]Exporting function 'Add-AzureAnalysisServicesFirewallRule'. 2022-01-04T07:30:41.0780206Z ##[debug]Exporting function 'Remove-AzureAnalysisServicesFirewallRule'. 2022-01-04T07:30:41.0807373Z ##[debug]Exporting function 'Get-AzureAnalysisServicesStatus'. 2022-01-04T07:30:41.0834839Z ##[debug]Importing function 'Add-AzureAnalysisServicesFirewallRule'. 2022-01-04T07:30:41.0928993Z ##[debug]Importing function 'Get-AzureAnalysisServicesStatus'. 2022-01-04T07:30:41.0989703Z ##[debug]Importing function 'Remove-AzureAnalysisServicesFirewallRule'. 2022-01-04T07:30:41.1028277Z ##[debug]Loading module from path 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\deploy-aas-db.psm1'. 2022-01-04T07:30:41.1122793Z ##[debug]Exporting function 'LoadDlls'. 2022-01-04T07:30:41.1148455Z ##[debug]Exporting function 'LoadTabularDatabaseFromFile'. 2022-01-04T07:30:41.1192186Z ##[debug]Exporting function 'LoadTabularDatabaseFromServer'. 2022-01-04T07:30:41.1228968Z ##[debug]Exporting function 'MergeDatabases'. 2022-01-04T07:30:41.1286682Z ##[debug]Exporting function 'Get-AgentIpAddress'. 2022-01-04T07:30:41.1382805Z ##[debug]Exporting function 'ProcessMessages'. 2022-01-04T07:30:41.1422046Z ##[debug]Importing function 'Get-AgentIpAddress'. 2022-01-04T07:30:41.1449100Z ##[debug]Importing function 'LoadDlls'. 2022-01-04T07:30:41.1492024Z ##[debug]Importing function 'LoadTabularDatabaseFromFile'. 2022-01-04T07:30:41.1522296Z ##[debug]Importing function 'LoadTabularDatabaseFromServer'. 2022-01-04T07:30:41.1550899Z ##[debug]Importing function 'MergeDatabases'. 2022-01-04T07:30:41.1581603Z ##[debug]Importing function 'ProcessMessages'. 2022-01-04T07:30:41.1766861Z ##[debug]Loading assembly: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\assemblies\Microsoft.AnalysisServices.Core.dll 2022-01-04T07:30:41.2656774Z ##[debug]Loading assembly: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\assemblies\Microsoft.AnalysisServices.dll 2022-01-04T07:30:41.3671837Z ##[debug]Loading assembly: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\assemblies\Microsoft.AnalysisServices.Tabular.dll 2022-01-04T07:30:41.5196088Z ##[debug]Loading assembly: D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\assemblies\Microsoft.AnalysisServices.Tabular.Json.dll 2022-01-04T07:30:41.6012582Z ##[warning]The 'overwrite' option will be deprecated in a future version. 2022-01-04T07:30:41.6026150Z ##[debug]Processed: ##vso[task.logissue type=warning]The 'overwrite' option will be deprecated in a future version. 2022-01-04T07:30:41.6032646Z ##[debug]Retrieving service principal 2022-01-04T07:30:41.6072855Z ##[debug]INPUT_APPID: '***' 2022-01-04T07:30:41.6107162Z ##[debug]INPUT_TENANTID: '***' 2022-01-04T07:30:41.6138898Z ##[debug]INPUT_APPKEY: '***' 2022-01-04T07:30:41.6809704Z ##[debug]Entering Get-AzureAnalysisServicesStatus. 2022-01-04T07:30:41.7110478Z ##[debug] endpoint: '@{Url=https://management.azure.com/; Data=; Auth=}' 2022-01-04T07:30:41.7139417Z ##[debug] serverName: 'ascorpnl***dwh' 2022-01-04T07:30:41.7201189Z ##[debug]Getting running status of azure analysis services server: ascorpnl***dwh 2022-01-04T07:30:41.7355178Z ##[debug]Connection type used is ServicePrincipal 2022-01-04T07:30:41.7399928Z ##[debug]Connection type used is ServicePrincipal 2022-01-04T07:30:41.7503786Z ##[debug]Getting azure analysis service properties: 'ascorpnl***dwh' 2022-01-04T07:30:41.7906549Z ##[debug]Fetching Access Token (spn) 2022-01-04T07:30:41.9979930Z ##[debug]POST https://login.windows.net/***/oauth2/v2.0/token with -1-byte payload 2022-01-04T07:30:42.2078765Z ##[debug]received 1368-byte response of content type application/json; charset=utf-8 2022-01-04T07:30:42.2531654Z ##[debug]Get Resource Groups 2022-01-04T07:30:42.2695581Z ##[debug]Fetching Resources from https://management.azure.com//subscriptions/xxxxxxxxxxxxxxxxxxxxx/resources?api-version=2014-04-01 2022-01-04T07:30:42.2763773Z ##[debug]GET https://management.azure.com//subscriptions/xxxxxxxxxxxxxxxxxxxxxxxxx/resources?api-version=2014-04-01 with 0-byte payload 2022-01-04T07:30:42.3958750Z ##[debug]received 23381-byte response of content type application/json; charset=utf-8 2022-01-04T07:30:42.4144824Z ##[debug]Fetching properties from https://management.azure.com//subscriptions/xxxxxxxxxxxxxxxxxxxxxxxxx/resourceGroups/RG-xxxxxxxxxxxxxxxxxxxxxxxxx-DEV-BI/providers/Microsoft.AnalysisServices/servers/ascorpnl***dwh?api-version=2017-08-01 2022-01-04T07:30:42.4197710Z ##[debug]GET https://management.azure.com//subscriptions/xxxxxxxxxxxxxxxxxxxxxxxxx/resourceGroups/RG-xxxxxxxxxxxxxxxxxxxxxxxxx-DEV-BI/providers/Microsoft.AnalysisServices/servers/ascorpnl***dwh?api-version=2017-08-01 with 0-byte payload 2022-01-04T07:30:42.4900277Z ##[debug]received 1073-byte response of content type application/json; charset=utf-8 2022-01-04T07:30:42.4973570Z ##[debug]Remove leftover firewall rule 2022-01-04T07:30:42.5166044Z ##[debug]Entering Remove-AzureAnalysisServicesFirewallRule. 2022-01-04T07:30:42.5200531Z ##[debug] endpoint: '@{Url=https://management.azure.com/; Data=; Auth=}' 2022-01-04T07:30:42.5296674Z ##[debug] serverName: 'ascorpnl***dwh' 2022-01-04T07:30:42.5298560Z ##[debug] firewallRuleName: 'vsts-release-aas-rule' 2022-01-04T07:30:42.5300290Z ##[debug]Removing firewall rule 'vsts-release-aas-rule' on azure analysis services server: ascorpnl***dwh 2022-01-04T07:30:42.5324771Z ##[debug]Connection type used is ServicePrincipal 2022-01-04T07:30:42.5383160Z ##[debug]Connection type used is ServicePrincipal 2022-01-04T07:30:42.5415069Z ##[debug]Getting azure analysis service properties: 'ascorpnl***dwh' 2022-01-04T07:30:42.5449044Z ##[debug]Fetching Access Token (spn) 2022-01-04T07:30:42.5564247Z ##[debug]POST https://login.windows.net/***/oauth2/v2.0/token with -1-byte payload 2022-01-04T07:30:42.6392409Z ##[debug]received 1368-byte response of content type application/json; charset=utf-8 2022-01-04T07:30:42.6449397Z ##[debug]Get Resource Groups 2022-01-04T07:30:42.6532699Z ##[debug]Fetching Resources from https://management.azure.com//subscriptions/xxxxxxxxxxxxxxxxxxxxx/resources?api-version=2014-04-01 2022-01-04T07:30:42.6579425Z ##[debug]GET https://management.azure.com//subscriptions/xxxxxxxxxxxxxxxxxxxxx/resources?api-version=2014-04-01 with 0-byte payload 2022-01-04T07:30:42.6922125Z ##[debug]received 23381-byte response of content type application/json; charset=utf-8 2022-01-04T07:30:42.6990155Z ##[debug]Fetching properties from https://management.azure.com//subscriptions/xxxxxxxxxxxxxxxxxxxxx/resourceGroups/RG-xxxxxxxxxxxxxxx-DEV-BI/providers/Microsoft.AnalysisServices/servers/ascorpnl***dwh?api-version=2017-08-01 2022-01-04T07:30:42.7033497Z ##[debug]GET https://management.azure.com//subscriptions/xxxxxxxxxxxxxxxxxxxxx/resourceGroups/RG-xxxxxxxxxxxxxxx-DEV-BI/providers/Microsoft.AnalysisServices/servers/ascorpnl***dwh?api-version=2017-08-01 with 0-byte payload 2022-01-04T07:30:42.7342738Z ##[debug]received 1073-byte response of content type application/json; charset=utf-8 2022-01-04T07:30:42.7443626Z ##[debug]Removed firewall rule 'vsts-release-aas-rule' on azure database server: ascorpnl***dwh 2022-01-04T07:30:42.7553169Z ##[debug]Get agent IP address 2022-01-04T07:30:43.9580602Z ##[debug]Loading database from 'D:\a\r1\a\Vebego Azure DWH\Vebego Azure DWH\Smart Cleaning\Model.bim' 2022-01-04T07:30:43.9743445Z ##[debug]Loading tabular database from file 2022-01-04T07:30:44.6328501Z ##[debug]Loading database 'Smart Cleaning' from '***' 2022-01-04T07:30:44.6396010Z ##[debug]Loading tabular database from server 2022-01-04T07:30:44.8503262Z ##[debug]Applying datasouce credentials for '' 2022-01-04T07:30:44.8654379Z ##[debug]Merge database with the following options: DeployPartitions, RetainRoles 2022-01-04T07:30:44.9132110Z ##[debug]Overwriting target partitions 2022-01-04T07:30:44.9209328Z ##[debug]Copying target roles to source 2022-01-04T07:30:45.4507443Z ##[debug]Copying role: 'Reader' 2022-01-04T07:30:45.8267713Z ##[debug]Deploying database to *** 2022-01-04T07:30:47.0555456Z Deploying database ('Smart Cleaning') to '***' complete 2022-01-04T07:30:47.0957914Z ##[debug]Leaving D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.2\deploy-aas-db.ps1. 2022-01-04T07:30:47.1941095Z ##[section]Finishing: Deploy model Smart Cleaning