ADF Global Parameters Error

Question

ADF Global Parameters Error

Andrew Mitchell 1

I have deployed a global parameter for a connection string and am receiving the following error when I try and test the connection

The parameters and expression cannot be resolved for schema operations. Error Message: { "Message": "ErrorCode=InvalidTemplate, ErrorMessage=The expression 'pipeline().globalParameters.gp_SQLDW_Server' cannot be evaluated because property 'globalParameters' doesn't exist, available properties are ''.." }

I am not currently deploying this with CICD

Regards
Andy

Vaibhav Chaudhari 38,916 Reputation points Volunteer Moderator

2020-08-20T09:17:13.597+00:00

Where exactly the expression is being used? Could you share a screenshot
Andrew Mitchell 1 Reputation point

2020-08-20T09:38:53.407+00:00

I have since removed the _ 's from the parameters but here are the expressions being used

these were selected from Add dynamic content

and relate to the global parameters

Regards
Andy
Andrew Mitchell 1 Reputation point

2020-08-20T09:45:07.683+00:00

Just had someone else here try it and it only fails when you try and preview the data
Andrew Mitchell 1 Reputation point

2020-08-20T09:51:54.527+00:00

Also confirmed that test connection fails too
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-20T10:44:27.227+00:00

Hi anonymous userMitchell,

Welcome to Microsoft Q&A Platform.

Thanks for posting the query. Linked Services can be parameterized only using this approach. Global Parameters are supported only in the following expressions as listed in MS Docs and this does not include Linked Services. I also posted the confirmation query to internal teams and will update you as soon as I hear from them.
Andrew Mitchell 1 Reputation point

2020-08-20T10:54:39.667+00:00

Apologies if it is unclear but the global parameters are used in the pipeline and passed through to the linked service via parameters.

The documentation states Global parameters can be used in any pipeline expression.
as detailed Here
Salendra Dhanush 1 Reputation point

2021-05-14T07:23:02.597+00:00

hello anonymous userMitchell was the parameters error resolved for you , im facing the same problem now
Salendra Dhanush 1 Reputation point

2021-05-14T07:23:10.277+00:00

hello anonymous userMitchell was the parameters error resolved for you , im facing the same problem now

2 answers

Your answer

Vaibhav Chaudhari 38,916 Reputation points Volunteer Moderator

2020-08-20T09:17:13.597+00:00

Where exactly the expression is being used? Could you share a screenshot
Andrew Mitchell 1 Reputation point

2020-08-20T09:38:53.407+00:00

I have since removed the _ 's from the parameters but here are the expressions being used

these were selected from Add dynamic content

and relate to the global parameters

Regards
Andy
Andrew Mitchell 1 Reputation point

2020-08-20T09:45:07.683+00:00

Just had someone else here try it and it only fails when you try and preview the data
Andrew Mitchell 1 Reputation point

2020-08-20T09:51:54.527+00:00

Also confirmed that test connection fails too
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-20T10:44:27.227+00:00

Hi anonymous userMitchell,

Welcome to Microsoft Q&A Platform.

Thanks for posting the query. Linked Services can be parameterized only using this approach. Global Parameters are supported only in the following expressions as listed in MS Docs and this does not include Linked Services. I also posted the confirmation query to internal teams and will update you as soon as I hear from them.
Andrew Mitchell 1 Reputation point

2020-08-20T10:54:39.667+00:00

Apologies if it is unclear but the global parameters are used in the pipeline and passed through to the linked service via parameters.

The documentation states Global parameters can be used in any pipeline expression.
as detailed Here
Salendra Dhanush 1 Reputation point

2021-05-14T07:23:02.597+00:00

hello anonymous userMitchell was the parameters error resolved for you , im facing the same problem now
Salendra Dhanush 1 Reputation point

2021-05-14T07:23:10.277+00:00

hello anonymous userMitchell was the parameters error resolved for you , im facing the same problem now

Answer 1

HarithaMaddi-MSFT 10,146

Hi anonymous userMitchell,

Thanks for posting the query. As per documentation, Global parameters can only been referenced in pipelines, and, you can pass them through a dataset and then to the linked service. I confirmed the same with Product team and below is an approach I followed to parameterize username, please check if this helps to resolve the issue. Kindly let me know for further questions and I will be glad to assist further.

Andrew Mitchell 1 Reputation point

2020-08-21T08:53:52.217+00:00

Hi Thanks for the update, what you have done there is exactly as I have done, except that you have not pressed the test connection or preview data buttons which is where the error is generated

Regards
Andy
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-21T09:07:14.22+00:00

Hi anonymous userMitchell,

Thanks. As mentioned, Global parameters cannot be referenced directly in the Linked Service and hence I created Linked Service Parameter and passed Global Parameter to it using dataset. Please find below snap where it worked for me. From the error message, it seems you are referring to global parameters in the linked service. Can you please recheck the GIF, modify the approach and confirm if you are seeing the issue.

If you are still facing the issue, kindly send a mail to AzCommunity[at]Microsoft[.]com with below details

Subject: "Attn: Haritha"
Thread URL:
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-24T05:22:29.733+00:00

Hi anonymous userMitchell,

We still have not heard response from you. Please suggest if above answer helped, if not, can you please share more details to engage more with the issue.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-26T05:29:36.083+00:00

Hi anonymous userMitchell,

Checking to see if above answer clarified the question. Please let us know for further queries and we will be glad to assist.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Michelle Kempen 1 Reputation point

2020-09-02T12:03:37.977+00:00

Hi, I'm having the same issue,
In a pipeline I'm using a dataset which needs a username that stays the same.
So I thought I'd make it into a global parameter.
The preview data button gives me the same exact error as anonymous userMitchell.
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-02T12:51:52.753+00:00

Hi @Michelle Kempen ,

Thanks for sharing the details. We are unable to reproduce the issue as stated above. Please send a mail to AzCommunity[at]microsoft[dot]com with below details to work with you closely in understanding the issue.

Subject: "Attn: Haritha - ADF Global Parameters Error"
Thread URL:

Answer 2

Marcin Dąbrowski 1

Hi, I have exactly the same issue.
I think the problem is connected with git integration.
I have Azure DevOps connected to the Data Factory.
When I change something in development branch and then published it, I'm getting this issue.
All pipelines are working OK in GIT mode, but the failure is in Data Factory mode.
Only disconnecting from DevOps, removing adf_publish branch, connecting again, and publishing again helps.

Please try to reproduce it.

Regards,
Marcin

Share via

ADF Global Parameters Error

2 answers

Your answer