question

SoumyaBrataBatabyal-6246 avatar image
0 Votes"
SoumyaBrataBatabyal-6246 asked KranthiPakala-MSFT commented

I have been facing problem using ADF copy data activity.Unable to parse expression 'AGREEMNT': expected token 'LeftParenthesis' and actual 'EndOfData'

The parameters and expression cannot be resolved for schema operations. Error Message: { "Message": "ErrorCode=InvalidTemplate, ErrorMessage=Unable to parse expression 'AGREEMNT': expected token 'LeftParenthesis' and actual 'EndOfData'.

azure-data-factory
· 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.

Hi @soumyabratabatabyal-6246,

Welcome to Microsoft Q&A forum and thanks for reaching out.

To better assist on your query, could you please share the expression that you are using in your pipeline/activity? And few additional steps on how to reproduce it would help the community to understand the problem better.

We look forward to your response.

0 Votes 0 ·

81300-copydata-1.png



I'm using copydata activity by using Self-Hosted IR. and the IR is working perfectly. even though the pipe line also working but if we can preview or create a new pipeline by using IR then this error code arising.

0 Votes 0 ·
copydata-1.png (38.1 KiB)
KranthiPakala-MSFT avatar image KranthiPakala-MSFT SoumyaBrataBatabyal-6246 ·

Hi @SoumyaBrataBatabyal-6246 ,

Thanks for your response. Could you please confirm if you are using any dynamic expressions in your pipeline? If so could you please share the complete expression? From error message I can see that the issue is with expression "AGREEMENT", please elaborate what is it and how you are using it in your pipeline. It would be great if you can share the pipeline support files to us (AzCommunity[at]microsoft[dot]com) with subject as "Attn-KranthiPakala-ThreadTitle" so that we can get a better understanding of the JSON payload of your pipeline and identify the root cause.

Do let me know how you would want to proceed on this.

Thank you

0 Votes 0 ·

Hi @SoumyaBrataBatabyal-6246 ,


We still have not heard back from you. Just wanted to check if you are still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know the above details requested and we will continue to engage with you on the issue.

Thanks

0 Votes 0 ·

0 Answers