search

kromerm / adflab

Azure Data Factory hands-on lab, self-paced. Learn how to lift & shift SSIS packages to the Cloud with ADF. Build new ETL pipelines in ADF, transform data at scale, load Azure Data Warehouse data marts. Also walks through operationalizing ADF pipelines with scheduling and monitoring modules.
http://aka.ms/adflab2
137 stars 129 forks source link

Deployment fails: Gen1 Data Warehouse deprecated #27

Open matepolsps opened 4 years ago

matepolsps commented 4 years ago

Initial PS deployment fails with this as follows: \Deployment> $ARMOutput = New-AzureRmResourceGroupDeployment -ResourceGroupName $resourceGroupName -TemplateFile LabARM.json -labNamePrefix $labNamePrefix -sqlUsername $sqlUsername -sqlPassword $sqlPassword -logicAppEmail $logicAppEmail New-AzureRmResourceGroupDeployment : 23:01:59 - Resource Microsoft.Sql/servers/databases 'xxxxxxxlwfnhc/AirlinePerform ance-DW' failed with message '{ "code": "45122", "message": "'Gen1 Data Warehouse has been deprecated in this region. Please leverage Gen2 Data Warehouse.'", "target": null, "details": [ { "code": "45122", "message": "'Gen1 Data Warehouse has been deprecated in this region. Please leverage Gen2 Data Warehouse.'", "target": null, "severity": "16" } ], "innererror": [] }' At line:1 char:14

New-AzureRmResourceGroupDeployment : 23:02:46 - Template output evaluation skipped: at least one resource deployment op eration failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage det ails. At line:1 char:14

New-AzureRmResourceGroupDeployment : 23:02:46 - Template output evaluation skipped: at least one resource deployment op eration failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage det ails. At line:1 char:14

matepolsps commented 4 years ago

I have been able to solve this by adding a "c" to line 144 in LabARM.json so that it is like this: "requestedServiceObjectiveName": "DW100c" Originally, it had "DW100", so it looks like the "c" makes the difference between gen1 and gen2.