Unable to preview the file in Azure Data Factory - Failure

Sivakumar Rajabather 65 Reputation points
2024-03-16T15:57:23.7833333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,584 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,444 questions
{count} votes

Accepted answer
  1. Smaran Thoomu 8,885 Reputation points Microsoft Vendor
    2024-03-18T11:28:26.32+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Suba Balaji 11,186 Reputation points
    2024-03-19T02:54:01.83+00:00

    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.

    1 person found this answer helpful.