Pipeline Name not available in system variables, even though it shows it should be available

[thijsvdv]

Since a couple of weeks, the system variable Pipeline Name (@pipeline().PipelineName) is no longer available. It shows that it is available in the system variables overview: 

However, when I try to reference the variable in a pipeline activity I get the following error: 

I suspect this is a bug, can someone confirm this?

Thanks!

[thijsvdv]

An update from my side, it looks like the bug is partially fixed. If I run the complete pipeline the variable can be used, however it still returns an error when you try to preview the data and the variable is used in the query. 

[NandanHegde]

Can you please provide screenshot of your activity where you are using this system variable? And which region this factroy pipeline is being used?

Because the below variable is working for us

[thijsvdv]

Hi Nandan, 

Thank you for your quick response. I can confirm that the error doesn't occur when setting a variable, I have just tested that as well. I encounter the error when using the system variable in a copy activity. I've tried this with different sources, but no difference there. The region the factory is used in is West Europe.

As you can see in this screenshot below, through this way I can easily reproduce the error by trying to preview the data: 

[v-yilong-msft]

Hi @thijsvdv ,

I have also created a Copy data in the Pipeline of Data Factory.

You can clearly see here that the error is caused by not finding the PipelineName when you output the result you want.

The reason for the error is that the PipelineName is not found, so I don't think you need to use this step here at all. You can directly choose not to check Enter manually for the next step.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[thijsvdv]

Hi Yilong,

Thank you for your response. I have only used the enter manually option for demonstration purposes. It does not matter whether the table exists or not, the error says that the variable is not available when using the preview data option.

To be more clear, you can also test it in a select statement in a query box as seen below. But you can also test it when dynamically trying to create a new table with the pipelinename as dynamic name using the variable in the sink options. And to be more clear, this is not limited to the preview data option, it also fails when trying to run the pipeline.

In addition, to be even more clear, this select statement does not work: 

But this select statement does work: