I am getting the below error when I try to insert into a azure data lake table. "Type=System.IO.FileNotFoundException,Message=Could not load file or assembly 'System.Text.Json"

Beebi Thasleem M 20

I am getting the below error when I try to insert into a azure data lake table from adf pipeline

. "The type initializer for 'Azure.Core.Serialization.JsonObjectSerializer' threw an exception.,Source=Azure.Data.Tables,''Type=System.IO.FileNotFoundException" "Could not load file or assembly 'System.Text.Json, Version=4.0.1.

AnnuKumari-MSFT 33,981 Reputation points Microsoft Employee

2024-12-30T03:49:39.42+00:00

Hi Beebi Thasleem M ,

Just checking if you got a chance to look at the previous response. Kindly do let us know. Thankyou

1 answer

AnnuKumari-MSFT 33,981 Reputation points Microsoft Employee

2024-12-27T17:06:25.06+00:00

Hi Beebi Thasleem M ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

"when I try to insert into a azure data lake table from adf pipeline"
Could you please elaborate what exactly are you doing? Are you using copy activity and trying to copy data from source to ADLS? What do you mean by datalake table?

Please share your code or pipeline screenshot for better clarity. Thankyou
Please sign in to rate this answer.
Beebi Thasleem M 20 Reputation points

2025-01-02T05:07:20.5966667+00:00

hi @AnnuKumari-MSFT ,

Sorry for the delayed response.

By datalake table , I mean azure delta lake table in azure table storage.

Yes I am using copy activity to copy into the table.

Thank you,

Thasleem

AnnuKumari-MSFT 33,981 Reputation points Microsoft Employee

2025-01-03T07:24:46.0566667+00:00

Hi Beebi Thasleem M ,

Looks like it is an error related to SDK. Is the ADF instance or ADF pipeline created using dotnet SDK?

This problem generally occurs when the runtime is unable to load the needed set of dependencies. Normally, this is due to a version mismatch due to an application reference that pins an older version either directly or as a transitive dependency. Most often, this can be mitigated by adding an explicit reference to the application that hosts the version.

Here are some references I found for the error resolution:

https://community.dynamics.com/forums/thread/details/?threadid=7108dda4-70f9-457c-8f2b-c050ed98e7f1

https://github.com/Azure/azure-sdk-for-net/issues/43629

Kindly review and see if it helps. Thankyou

AnnuKumari-MSFT 33,981 Reputation points Microsoft Employee

2025-01-06T07:39:25.1733333+00:00

Hi Beebi Thasleem M ,

Just checking in to see if the above answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

I am getting the below error when I try to insert into a azure data lake table. "Type=System.IO.FileNotFoundException,Message=Could not load file or assembly 'System.Text.Json"

1 answer

Your answer