question

RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 asked nasreen-akter answered

Pipeline Issue

Till Yesterday i pipeline was working on fine.But today suddenly got issue :

78881-image.png



Not able to run the pipeline ..Please advise

Regards
RK

azure-data-factory
image.png (44.2 KiB)
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.

nasreen-akter avatar image
0 Votes"
nasreen-akter answered

@RohitKulkarni-3496,

I think you probably need this:

Conatiner: @pipeline().parameters.RawContainer

Folder: @{pipeline().parameters.RawFolder}/@{item()}/Tables/@{pipeline().parameters.TableName}

FileName :@{pipeline().parameters.TableName}_@{item()}.@{pipeline().parameters.RawFileFormat}

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.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered VaibhavChaudhari edited

Is there any reason behind using array type for Company Name parameter?

You could try make it as String and it will form the right path

Edit #1 - Also as suggested by Nasreen -

instead of
pipeline().parameters.CompanyName
try
pipeline().parameters.CompanyName[0]



Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

· 1
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.

Yes In foreach Activity what i need to mention :

78904-image.png


0 Votes 0 ·
image.png (35.5 KiB)
nasreen-akter avatar image
0 Votes"
nasreen-akter answered nasreen-akter edited

Hi @RohitKulkarni-3496,

As the CompnyName is an Array, you could try the following:

 Conatiner: @pipeline().parameters.RawContainer
    
 Folder: @{pipeline().parameters.RawFolder}/item().CompanyName[0]/Tables/item().TableName
    
 FileName :@{pipeline().parameters.TableName}_{item().CompanyName[0]}.pipeline().parameters.RawFileFormat

Hope this helps! Thanks! :)


· 4
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.

I got an error :

78776-image.png


0 Votes 0 ·
image.png (60.5 KiB)

@RohitKulkarni-3496, if values for CompanyName are coming from pipeline parameters, then try to use pipeline().parameters.CompanyName[0] instead of item()

0 Votes 0 ·

Thas is what i am passing :


Folder :@{pipeline().parameters.RawFolder}/@{pipeline().parameters.CompanyName}/Tables/@{pipeline().parameters.TableName}


FilaName :

@{pipeline().parameters.TableName}_@{pipeline().parameters.CompanyName}.@{pipeline().parameters.RawFileFormat}


78898-image.png



I need to remove [] and display only Group O

0 Votes 0 ·
image.png (60.5 KiB)
Show more comments
RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 answered

Guys i am near to the issue but i am getting error Please advise me how to remove [] .I need to display only Group O from the path :

78829-image.png




Thanks in Advance
RK


image.png (51.8 KiB)
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.

RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 answered RohitKulkarni-3496 edited

I have made some changes in the parameter. But still i am getting error. I think some where in the syntax is getting error :

78794-image.png

78845-image.png


Conatiner :@pipeline().parameters.RawContainer

Folder :@{pipeline().parameters.RawFolder}/item().CompanyName/Tables/item().TableName

FileName :@{pipeline().parameters.TableName}_{item().CompanyName}.pipeline().parameters.RawFileFormat

Please advise

Thanks in advance
RK



image.png (49.4 KiB)
image.png (67.8 KiB)
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.