Getting Error when publishing Synapse pipelines which is linked to Azure DevOps git.

Shailendra Kad 11

I am trying to publish the synapse pipelines from master branch. And I am getting an error and it does not point it to any details or any specific pipeline or Data flow.

Error is below:-

Error code: OK
Inner error code: BadRequest
Message: Missing parameter definition for Env

I am using Env parameter for a linked service. And I have added parameter to all pipelines ,Datasets and Dataflows. Everything is working fine , no error when running the pipelines.
Please help me. I am not getting anything on the internet.
I have also raised the issue with Microsoft support team but no help yet.

Pratik Somaiya 4,201 Reputation points

2022-06-18T15:26:33.717+00:00

Hello @Anonymous , can you try exporting the ARM template and see if env parameter is present?
Shailendra Kad 11 Reputation points

2022-06-19T20:40:47.367+00:00

Hi Pratik,
Tanks a lot for your response.
My pipelines are not published yet as I am getting error when publishing.
How can I extract ARM template before publishing? I am also new at it so not aware of this.
heta desai 247 Reputation points

2022-09-14T07:46:57.067+00:00

Please provide solution for this I am getting same error

2 answers

Pratik Somaiya 4,201 Reputation points

2022-06-20T05:03:25.493+00:00

Hello @Anonymous

You can export ARM template from ADF by clicking Manage tab as below

But as you said you are getting an error while publishing from ADF portal itself, then ARM template won't show the env parameter

Are you running pipeline via Debug mode? That is why you might be passing parameter during runtime. To publish a pipeline you will have to provide a default value or a dynamic value
Please sign in to rate this answer.
Shailendra Kad 11 Reputation points

2022-06-20T07:49:40.393+00:00

Hi Pratik,

Yes, I am providing the default values in all the pipelines and Dataflow.
I have raised this issue with Microsoft support team and they also told me to provide default value.
But it also not working. Also , it is Synapse and not ADF (although it is same but just for clarification).

Also, I have passed the value dynamic way. You can see in the attachment as well.
If possible , is it okay to have a small call where I can show you?

Pratik Somaiya 4,201 Reputation points

2022-06-20T08:40:00.667+00:00

Sure @Anonymous We can speak post 7 PM IST, does that work for you? You can reach out to me at pratiksomaiya123@Karima ben .com

Shailendra Kad 11 Reputation points

2022-06-20T09:07:09.837+00:00

Yes , it works for me too. Thanks already.
Let me know how can I schedule a call or any ID where I can send the request?

AnnuKumari-MSFT 31,151 Reputation points Microsoft Employee

2022-06-20T10:09:02.107+00:00

Hi @Anonymous ,
Just checking in to see if the above answer by @Pratik Somaiya helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

Pratik Somaiya 4,201 Reputation points

2022-06-20T11:00:03.167+00:00

@Anonymous : Can you email me your number, we can discuss more in detail as to how to connect then we can share the solution here with the community so that everyone can get a benefit from it :)

Quentin Fisher 6 Reputation points

2022-08-03T23:30:06.763+00:00

@Pratik Somaiya @Anonymous Can you please tell me the resolution of this issue, I am also getting the error.
Sign in to comment
TheNerd-0042 40 Reputation points

2023-11-30T12:13:52.9566667+00:00

@Shailendra Kad @Pratik Somaiya can you please provide the solution which has been offered to you from Microsoft Team? I am also facing the same problem
Please sign in to rate this answer.

0 comments No comments
Sign in to comment