Unable to preview the file in Azure Data Factory - Failure

Question

Hi,

I have created a pipeline in Azure Data Factory to migrate a table from MS SQL Server and loaded the table in Azure Data Factory. But unable to preview the table and getting the below error. Please look into this and help me to get this fixed.

'Type=Newtonsoft.Json.JsonSerializationException,Message=Error getting value from 'Value' on 'System.Data.SqlTypes.SqlDouble'.,Source=Newtonsoft.Json,'

'Type=System.Data.SqlTypes.SqlNullValueException,Message=Data is Null. This method or property cannot be called on Null values.,Source=System.Data,'

Thanks and Regards,

R. Sivakumar

Answer 1

Hi @Sivakumar Rajabather

Thank you for reaching out with your issue.

The first error you mentioned seems to be related to a null value in the data being migrated. It appears that the pipeline is trying to deserialize a null value into a non-nullable data type, which is causing the error. To fix this, you can try modifying the source query to exclude any rows with null values in the columns being migrated. Alternatively, you can modify the target table to allow null values in the columns being migrated.

Regarding the error code 9518, it seems to be related to the integration runtime being busy. To fix this, you can try waiting for some time and then retrying the operation later. You can also try increasing the number of integration runtime nodes or scaling up the integration runtime to handle more concurrent operations.

If the issue persists, please provide more details about your pipeline and the data being migrated, including the source and target data types, and any transformations being applied in the pipeline. This will help me provide more specific guidance on how to resolve the issues.

I hope this helps. Let me know if you have any further questions or concerns.

Answer 2

Hello Sivakumar,

Glad you fixed the issue, and also for sharing the resolution with the community. I am reposting your answer here and requesting you to accept it, so that community with same issue will find it helpful.

Problem: While running the pipeline with a self hosted IR being used in a copy activity, and during preview, encountering the below error. Error Code: 9518 The integration runtime is busy now. Please retry the operation later. Resolution: I have resolved this issue by installing JRE in my system and restarted the self hosted IR.

Thanks.