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

Soumya Brata Batabyal 1

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'.

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-03-25T01:41:57.533+00:00

Hi anonymous user,

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.
Soumya Brata Batabyal 1 Reputation point

2021-03-25T04:25:25.777+00:00

![81300-copydata-1.png][1] [1]: /api/attachments/81300-copydata-1.png?platform=QnA 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.
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-03-25T23:40:06.61+00:00

Hi anonymous user ,

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
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-03-30T01:33:00.43+00:00

Hi anonymous user ,

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
TAHSEEN FATIMA 0 Reputation points

2023-02-09T11:36:13.35+00:00

I have been facing a similar error

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

where "@CATEGORY' is a source column and mapping dynamically to target table.