question

AndyMitchell avatar image
0 Votes"
AndyMitchell asked SalendraDhanush-7983 published

ADF Global Parameters Error

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

azure-data-factory
· 8
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Where exactly the expression is being used? Could you share a screenshot

0 Votes 0 ·

I have since removed the _ 's from the parameters but here are the expressions being used
19102-annotation-2020-08-20-103453png.jpg
these were selected from Add dynamic content
19020-annotation-2020-08-20-103453-2png.jpg

and relate to the global parameters
19073-annotation-2020-08-20-103759-3.jpg

Regards
Andy


0 Votes 0 ·

Just had someone else here try it and it only fails when you try and preview the data

0 Votes 0 ·

Also confirmed that test connection fails too

0 Votes 0 ·

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.


0 Votes 0 ·
Show more comments

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

0 Votes 0 ·

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

0 Votes 0 ·
HarithaMaddi-MSFT avatar image
0 Votes"
HarithaMaddi-MSFT answered HarithaMaddi-MSFT commented

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.

19128-usingglobalparameterslinkedserviceadf.gif



· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

19482-annotation-2020-08-21-095244.jpg

Regards
Andy


0 Votes 0 ·

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:

19483-testconnection.png


0 Votes 0 ·
testconnection.png (73.4 KiB)

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

0 Votes 0 ·
Show more comments

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.
22195-image.png


22129-image.png


0 Votes 0 ·
image.png (51.3 KiB)
image.png (20.0 KiB)

Hi @MichelleKempen,

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:

0 Votes 0 ·
MarcinDbrowski-9345 avatar image
0 Votes"
MarcinDbrowski-9345 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.