Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,271 questions
Azure Devops error invalid parameters
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
1,370
Reputation points
Hi,
Invalid parameters error in ADF azure devops armtemplate deployment what can be issue in armtemplate
{
"$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentParameters.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"factoryName": {
"value": "adf-uat-01"
},
"AzureSqlBDC_password": {
"value": ""
},
"Lnk_ACP_ADF_SQL_WindowsAuth_password": {
"value": ""
},
"Lnk_ACP_MongoDbAtlas_ACPSCVDEVDBM42_connectionString": {
"value": ""
},
"Lnk_Memberdatavalidator_SCV_functionKey": {
"value": ""
},
"Lnk_SQL_DataPlatform_password": {
"value": ""
},
"Lnk_memberdatavalidator_functionKey": {
"value": ""
},
"Sangam_functionKey": {
"value": ""
},
"SqlServer1_password": {
"value": ""
},
"SqlServer2_password": {
"value": ""
},
"AzureSqlBDC_properties_typeProperties_server": {
"value": "jhj-dev-sql.database.windows.net"
},
"AzureSqlBDC_properties_typeProperties_database": {
"value": "Operational"
},
"AzureSqlBDC_properties_typeProperties_userName": {
"value": "SCV"
},
"BDC_SCV_TableStorage_properties_typeProperties_serviceEndpoint": {
"value": "https://stscvintdvshrd.table.core.windows.net/"
},
"Lnk_ACP_ADF_SQL_properties_typeProperties_server": {
"value": "@{linkedService().SCVstagingserver}"
},
"Lnk_ACP_ADF_SQL_properties_typeProperties_database": {
"value": "@{linkedService().SCVstagingdatabase}"
},
"Lnk_ACP_ADF_SQL_properties_typeProperties_userName": {
"value": "@{linkedService().SCVstagingusername}"
},
"Lnk_ACP_ADF_SQL_WindowsAuth_properties_typeProperties_server": {
"value": "10.1.1.1,2211"
},
"Lnk_ACP_ADF_SQL_WindowsAuth_properties_typeProperties_database": {
"value": "STAGINGDEV"
},
"Lnk_ACP_ADF_SQL_WindowsAuth_properties_typeProperties_userName": {
"value": "******@abc.com"
},
"Lnk_ACP_MongoDbAtlas_ACPSCVDEVDBM42_properties_typeProperties_database": {
"value": "MultiVue"
},
"Lnk_APIsourceRestService_properties_typeProperties_url": {
"value": "@{linkedService().RestAPIBaseURL}"
},
"Lnk_AzuresqlBDC_properties_typeProperties_server": {
"value": "@{linkedService().ODCDWHserver}"
},
"Lnk_AzuresqlBDC_properties_typeProperties_database": {
"value": "@{linkedService().ODCDWHdatabase}"
},
"Lnk_AzuresqlBDC_properties_typeProperties_userName": {
"value": "@{linkedService().ODCDWHusername}"
},
"Lnk_Memberdatavalidator_SCV_properties_typeProperties_functionAppUrl": {
"value": "https://fapp-ukin-scv-customer-adf-intdev02.azurewebsites.net"
},
"Lnk_SQL_DataPlatform_properties_typeProperties_server": {
"value": "jks-dev-sql.database.windows.net"
},
"Lnk_SQL_DataPlatform_properties_typeProperties_database": {
"value": "OperationalDW"
},
"Lnk_SQL_DataPlatform_properties_typeProperties_userName": {
"value": "scvdev"
},
"Lnk_memberdatavalidator_properties_typeProperties_functionAppUrl": {
"value": "https://lapp-ukin-ami-ukmscvprocessor-dev.azurewebsites.net"
},
"Sangam_properties_typeProperties_functionAppUrl": {
"value": "https://fkin-scv-customer-adf-intdev02.azurewebsites.net"
},
"SqlServer1_properties_typeProperties_server": {
"value": "-dev-sql.database.windows.net"
},
"SqlServer1_properties_typeProperties_database": {
"value": "OperationalDW"
},
"SqlServer1_properties_typeProperties_userName": {
"value": "scvdev"
},
"SqlServer2_properties_typeProperties_server": {
"value": "10.1.1.1,2211"
},
"SqlServer2_properties_typeProperties_database": {
"value": "STAGINGDEV"
},
"SqlServer2_properties_typeProperties_userName": {
"value": "******@bupa.com"
}
}
}
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 99%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
J N S S Kasyap 80 Reputation points Microsoft Vendor2025-02-20T09:57:03.6633333+00:00 Hi @Vineet S
Thanks for posting your query!
Based on the provided ARM template, here are a few common areas to check that might be causing the issue:
Parameters like
AzureSqlBDC_passwordandLnk_ACP_ADF_SQL_WindowsAuth_passwordare empty, which can cause deployment failures since they are likely sensitive data (e.g., passwords or API keys). To resolve this, provide valid values for these parameters, ideally by using Azure Key Vault or another secure method to inject secrets during deploymentParameters reference linked services dynamically
(e.g., {linkedService().SCVstagingserver}), which may cause deployment failures if the linked services are not defined or properly configured in the environment. To fix this, ensure the referenced linked services (like SCVstagingserver, SCVstagingdatabase) exist and are correctly configured in your ADF instance.The SQL server address contains an invalid character, such as the negative sign in
"-dev-sql.database.windows.net", which may be a typo. To resolve this, remove the erroneous character and ensure the server addresses are fully qualified and correct.Double-check the correctness of these server and database names and verify that they exist and are accessible in your environment. If using different environments, ensure these are consistent across all parameters
Verify that the correct usernames are used for each connection and ensure they are valid within the target systems (SQL Server, MongoDB). Consistency in usernames across environments is crucial.
Ensure that all function keys and URLs are properly defined or securely retrieved from a vault or other secret management system.
Syntax errors in the JSON structure of your parameters file can also lead to deployment issues. Ensure that the JSON syntax is correct, with no missing commas, braces, or incorrect nesting. Using a JSON validator tool can help identify and correct any syntax errors in your parameters file.
Please refer the following links for useful insights:
https://learn.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-resource-manager-templateI hope this information helps. Please do let us know if you have any further queries.
Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Thank you.
-
J N S S Kasyap 80 Reputation points Microsoft Vendor
2025-02-21T01:40:15.8733333+00:00 @Vineet S
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer