CODEWITHSUNDEEP
azure-data-factory
Patterson
Patterson

Reputation: 2757

Azure Data Factory: ErrorCode=TypeConversionFailure,Exception occurred when converting value : ErrorCode: 2200

Can somoene let me know why Azure Data Factory is trying to convert a value from String to type Double.

I am getting the error:

{
    "errorCode": "2200",
    "message": "ErrorCode=TypeConversionFailure,Exception occurred when converting value '+44 07878 44444' for column name 'telephone2' from type 'String' (precision:255, scale:255) to type 'Double' (precision:15, scale:255). Additional info: Input string was not in a correct format.",
    "failureType": "UserError",
    "target": "Copy Table to EnrDB",
    "details": [
        {
            "errorCode": 0,
            "message": "'Type=System.FormatException,Message=Input string was not in a correct format.,Source=mscorlib,'",
            "details": []
        }
    ]
}

My Sink looks like the following:

enter image description here

I don't have any mapping set

enter image description here

The column setting for the the field 'telephone2' is as follows:

enter image description here

I changed the 'table option' to none, however I got the following error:

{
    "errorCode": "2200",
    "message": "Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Internal system error occurred.\r\nStatement ID: {C2C38377-5A14-4BB7-9298-28C3C351A40E} | Query hash: 0x2C885D2041993FFA | Distributed request ID: {6556701C-BA76-4D0F-8976-52695BBFE6A7}. Total size of data scanned is 134 megabytes, total size of data moved is 102 megabytes, total size of data written is 0 megabytes.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Internal system error occurred.\r\nStatement ID: {C2C38377-5A14-4BB7-9298-28C3C351A40E} | Query hash: 0x2C885D2041993FFA | Distributed request ID: {6556701C-BA76-4D0F-8976-52695BBFE6A7}. Total size of data scanned is 134 megabytes, total size of data moved is 102 megabytes, total size of data written is 0 megabytes.,Source=.Net SqlClient Data Provider,SqlErrorNumber=75000,Class=17,ErrorCode=-2146232060,State=1,Errors=[{Class=17,Number=75000,State=1,Message=Internal system error occurred.,},{Class=0,Number=15885,State=1,Message=Statement ID: {C2C38377-5A14-4BB7-9298-28C3C351A40E} | Query hash: 0x2C885D2041993FFA | Distributed request ID: {6556701C-BA76-4D0F-8976-52695BBFE6A7}. Total size of data scanned is 134 megabytes, total size of data moved is 102 megabytes, total size of data written is 0 megabytes.,},],'",
    "failureType": "UserError",
    "target": "Copy Table to EnrDB",
    "details": []
}

Any more thoughts

Upvotes: 0

Views: 848

Answers (1)

Patterson
Patterson

Reputation: 2757

The issue was resolved by changing the column DataType on the database to match the DataType recorded in Azure Data Factory i.e StringType

Upvotes: 1

Related Questions