Could not load file or assembly Microsoft.IO.RecyclableMemoryStream

[Master]

does anyone have this error in a copy activity (copy from sql server to KQL database).
it still worked until Monday noon without any modification on our part !!!

ErrorCode=KustoWriteFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Write to Kusto failed with following error: 'An error occurred for source: 'DataReader'. Error: 'Could not load file or assembly 'Microsoft.IO.RecyclableMemoryStream, Version=2.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.''.,Source=Microsoft.DataTransfer.Runtime.KustoConnector,''Type=Kusto.Ingest.Exceptions.IngestClientException,Message=An error occurred for source: 'DataReader'. Error: 'Could not load file or assembly 'Microsoft.IO.RecyclableMemoryStream, Version=2.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.',Source=Kusto.Ingest,''Type=System.IO.FileNotFoundException,Message=Could not load file or assembly 'Microsoft.IO.RecyclableMemoryStream, Version=2.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.,Source=Kusto.Cloud.Platform,'

[Master · Accepted solution]

OK, we found the problem: Data Gateway of august 2024.
we went back to the July version and everything is OK

[Anonymous]

Hi @Master ,

As you can see from your reported error message, the issue is related to a missing dependency in the replication activity from SQL Server to a KQL database. This particular error indicates that the Microsoft.IO.RecyclableMemoryStream assembly is missing or cannot be found.

So I think you can try the following to resolve this issue:

1. Make sure that the Microsoft.IO.RecyclableMemoryStream assembly is properly installed and accessible. You may need to reinstall or update this package.

2. Double-check your replication activity configuration to ensure that all settings are correct and that no recent changes have occurred that could affect the process.

3. You can also refer to these two links for more information: Configure KQL Database in a copy activity - Microsoft Fabric | Microsoft Learn and Solved: Re: Pipeline to Kusto error - Microsoft Fabric Community

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Master]

This is a pipeline in Fabric, I can't install libraries! I don't think your answer is relevant unfortunately. Thanks anyway.