ADF Errors - "No value provided for Parameter" and more

Question

We have 2 Pipelines.

1. Pipeline 1 - PL_1 is time based which Pulls data from On Prem SQL Server and create Parquet file in ADLS with the data. This blob creation triggers Pipeline 2 - PL_2.
2. We are using Azure Devops and Bitbucket for CICD.
3. We are using Global Parameters for all/most connections along with ADLS Path etc.

Issues:
In Dev Environment:

1. When I trigger pipeline 1, it is successful but (instead of/after) triggering pipeline 2, I get error “No value provided for Parameter 'Param_LS_IM_PACT_DB'”
2. Since Parquet file was there, I went ahead and triggered Pipeline 2 using Trigger Now in Authoring and it is successful. At least no error message.
3. I could also use debug to run the pipeline 2.

In Test environment:

1. When I trigger pipeline 1, it is successful but (instead of/after) triggering pipeline 2 I get error “No value provided for Parameter 'Param_LS_IM_PACT_DB”
2. When I try to debug Activity 2 – I get “{"code":"BadRequest","message":null,"target":"pipeline//runid/PLACEHOLDER","details":null,"error":null}”
3. I go to pipeline 1 and try triggering it using Trigger Now then I get “{"error":{"code":"BadRequest","message":"No value provided for Parameter 'Param_LS_IM_PACT_DB'","target":"pipeline/PL_2/runid/PLACEHOLDER","details":null}}”.

I already have sent Support files to azcommunity at microsoft.com email.

Answer 1

Hello @Darpan Patel ,
Thanks for the ask and using the Microsoft Q&A platform .
I looked in the file whcih you have sent and while looking into the file & corelating the error message , there is NO parameter with the name "Param_LS_IM_PACT_DB" and the closest I can get is "Param_LS_IMPACT_DB" . I am very sure that the changes which you have made ( and the JSON which you have shared ) and not yet published . Can you please check that and give it a try . The "trigger now" always triggers the pipleline which was last published .

More over you check for the the Param_LS_IM_PACT_DB in the published code .

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members