Facing Error in copy activity while try to data preview before data load.

Lokesh Rajpoot 36 Reputation points
2022-09-01T07:25:01.147+00:00

The function convertFromUtc is currently not supported for schema operations. Activity ID: b20ca41c-0ef3-4f8d-8e0d-07996890811b

The scenario is that i am load data from SAP to ADLS and at the load time i had used addition column feature at source end in copy activity
Column_name=Insert_date

value=>@formatDateTime(convertFromUtc(utcnow(), 'India Standard Time') ,'yyyy-MM-dd')

In this when i trigger or debug the pipeline then its execute smoothly but if i tried to do preview data then its raised error please find attached screenshot for more details.236824-error-message.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,444 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 37,656 Reputation points Microsoft Employee
    2022-09-02T06:38:20.677+00:00

    Hi @Lokesh Rajpoot ,

    Thank you for posting query in Microsoft Q&A Platform.

    When we click on preview button from source tab of Copy activity, then its actually a schema operation to consider additional column as well to show in preview. And at this moment the function which you used @convertFromUtc not supports schema operations. Hence you are seeing that error.

    But still when we run the pipeline in debug mode or trigger more additional column data will get correctly in sink location. If your intention is only to take date in format yyyy-MM-dd then you can consider using expressions as @formatDateTime(utcNow(),'yyyy-MM-dd')

    Hope this helps. Please let us know if any further queries.

    --------------

    Please consider hitting Accept Answer button. Accepted answers help community as well.

    1 person found this answer helpful.