Error with deploy.ps1 -> SQLSprocCleanupPipeline' failed with message 'The resource operation completed with terminal provisioning state 'Failed'.'

Question

Error with deploy.ps1 -> SQLSprocCleanupPipeline' failed with message 'The resource operation completed with terminal provisioning state 'Failed'.'

PeterSterk opened this issue 8 years ago · 9 comments

During running deploy.ps1, I end up with the following error message:

New-AzureRmResourceGroupDeployment : 10:18:16 - Resource Microsoft.DataFactory/datafactories/datapipelines 'mydriving-dfbjokizo7zoahc/SQLSprocCleanupPipeline' failed with message 'The resource operation completed with terminal p
rovisioning state 'Failed'.'
At C:\Data\MyDriving-master\scripts\PowerShell\deploy.ps1:144 char:16

... ployment2 = New-AzureRmResourceGroupDeployment -Name "$DeploymentName ...
```
            ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
```
- CategoryInfo : NotSpecified: (:) [New-AzureRmResourceGroupDeployment], Exception
- FullyQualifiedErrorId : Microsoft.Azure.Commands.Resources.NewAzureResourceGroupDeploymentCommand

Not sure what to do next?

Thanks, Peter

Answer 1 · 2016-06-14T17:28:50.000Z

do you have src\HDInsight\hivescripts*.hql scripts at correct destination?
as first step of deploy they are uploaded to storage account
you must have same value of baseName property in scenario_complete.json and prerequisites.json if you changed it

Answer 2 · 2016-06-14T18:12:27.000Z

Yes, I have 6 items in that folder and they upload successfully at the beginning. I haven't changed the baseName property in either files (keeping all defaults). The thing is, 2-3 weeks ago I was able to successfully deploy using the same scripts...

Answer 3 · 2016-06-14T19:59:10.000Z

try pls this: find Data factory in azure portal and look for this pipeline - Pipelines Tile, there could be some error visible

I will try add later VS2015 solution to project with DataFactory as project to easily edit and publish it

Answer 4 · 2016-06-14T20:55:19.000Z

reproduced, will try to fix it

Found at place I suggested to you: The Stored Procedure Activity Linked Service 'AzureStorageLinkedService' is of an unsupported type.

Answer 5 · 2016-06-14T20:57:13.000Z

Great, looking forward to that fix. Thanks in advance!
I missed that suggestion?

Answer 6 · 2016-06-14T21:08:29.000Z

it will take some time (testing takes time), if you wanna deploy without HDInsight, delete it form json script - try to find /* Create Data Factory */

Answer 7 · 2016-06-14T21:13:21.000Z

I have seen your comment in issue #525, not sure where I can change that and to what value?

Answer 8 · 2016-06-14T21:32:30.000Z

it's old comment/issue before I joined team, I will clean old issues
it's fixed in \src\DataFactory\ - you need add FinalTempDataSet-Sql dataset and link it to this dataset
but it's not fixed in ARM json file
I'm working on it

Answer 9 · 2016-06-14T22:12:45.000Z

fixed deployment of Data Factory (fixed and tested deployment not if DF is working)
another issues for DF exists - will work on it later