Synapse Deployment failed with error Failed to parse package: TypeError: Cannot read property 'length' of undefined

Question

Hi,
I am trying to create a linked service in synapse workspace through arm template . I am deploying through task: Synapse workspace deployment@2

Under Resource below arm code I am executing

{
"name": "LS_AzureSynapseAnalytics",
"type": "Microsoft.Synapse/workspaces/linkedServices",
"apiVersion": "2017-09-01-preview",
"properties": {
"annotations": [],
"type": "AzureSqlDW",
"typeProperties": {
"connectionString": {
"type": "AzureKeyVaultSecret",
"store": {
"referenceName": "ls_keyVault_XX",
"type": "LinkedServiceReference"
},
"secretName": "SqlDwGCS"
}
},
"connectVia": {
"referenceName": "AutoResolveIntegrationRuntime",
"type": "IntegrationRuntimeReference"
}
}
}

Deploying through yml , after build when its deploying this script failing with below error message. This is the only script I am deploying, not understand where the length property came in ARM.

Any help on fixing this would be highly appreciated.

Begin getting Artifacts From Template
deploy operation failed
An error occurred during execution: Error: Failed to parse package: TypeError: Cannot read property 'length' of undefined

[error]Encountered with exception:Error: Failed to parse package: TypeError: Cannot read property 'length' of undefined

Finishing: Synapseworkspacedeployment

Regards
Sanjeev

Answer 1

Hello @Sanjeev Nayak ,

Welcome to the MS Q&A platform.

As per the public doc: https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#use-the-synapse-workspace-deployment-task

In Azure Synapse, unlike in Data Factory, some artifacts aren't Resource Manager resources. You can't use the ARM template deployment task to deploy Azure Synapse artifacts. Instead, use the Synapse workspace deployment task.

And this should be regardless of using ADO(pipelines or release pipelines) or Github (Actions).

You can set up git integration for the artifacts deployment using the synapse deployment task or You may use the Synapse REST API or PowerShell.

Refer to the below document that provides guidance on how to use the API.

https://learn.microsoft.com/en-us/powershell/module/az.synapse/set-azsynapselinkedservice?view=azps-7.1.0

CICD documentation: https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#azure-synapse-analytics

Other prerequisites: https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#other-prerequisites

Please do follow the below blogs:
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/azure-synapse-studio-cicd-using-yaml-pipelines/ba-p/3045553
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/how-to-use-ci-cd-integration-to-automate-the-deploy-of-a-synapse/ba-p/2248060
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/automating-the-publishing-of-workspace-artifacts-in-synapse-cicd/ba-p/3603042

I see the below feedback request submitted for this feature. Please consider upvote and commenting on these feedback requests.

https://feedback.azure.com/d365community/idea/05e41bf1-0925-ec11-b6e6-000d3a4f07b8
https://feedback.azure.com/d365community/idea/48f1bf78-2985-ec11-a81b-6045bd7956bb

All the feedback shared in this forum is actively monitored and reviewed by the product team which will prioritize them accordingly based on the number of requests.
Hope this info helps.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators