locked
v2 - simple copy data fails - Expected data type: DECIMAL(15,0), Offending value: \u0000\u0000\u0 RRS feed

  • Question

  • I'm using data factory 2.0. 

    When I use the portal to create a simple copy data, the activity fails for certain tables with the following error:

        "errorCode": "2200",
        "message": "ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error happened when loading data into SQL Data Warehouse.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Query aborted-- the maximum reject threshold (0 rows) was reached while reading from an external source: 1 rows rejected out of total 1 rows processed.\n(/65125c65-1116-4767-bf5d-8c93e564b9e7/[MERCHANT].[TBL_SALE_UNIT].txt)Column ordinal: 12, Expected data type: DECIMAL(15,0), Offending value: \u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u00.......and lot of these

    Source=.Net SqlClient Data Provider,SqlErrorNumber=107090,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=107090,State=1,Message=Query aborted-- the maximum reject threshold (0 rows) was reached while reading from an external source: 1 rows rejected out of total 1 rows processed.\n(/65125c65-1116-4767-bf5d-8c93e564b9e7/[MERCHANT].[TBL_SALE_UNIT].txt)Column ordinal: 12, Expected data type: DECIMAL(15,0), Offending value: \u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u00....and a lot these.

    The source and destination schema looks like this:

    CREATE TABLE [merchant].[TBL_SALE_UNIT_staging]
    (
    [SALE_UNIT_ID] [numeric](15, 0) NOT NULL,
    [PROFILE_ID] [numeric](15, 0) NOT NULL,
    [SALE_UNIT_TYPE_ID] [numeric](8, 0) NOT NULL,
    [STATUS_IN] [numeric](1, 0) NOT NULL,
    [SALE_UNIT_SUB_TYPE_ID] [numeric](8, 0) NULL,
    [PAYMENT_MODEL_TYPE_ID] [numeric](15, 0) NULL,
    [PAYMENT_PROCESS_TYPE] [numeric](15, 0) NOT NULL,
    [CREATED_DT] [datetime2](6) NOT NULL,
    [CREATED_BY] [varchar](50) NOT NULL,
    [SALE_UNIT_NM] [varchar](200) NOT NULL,
    [ADDRESS_ID] [numeric](15, 0) NOT NULL,
    [LOGO_ID] [numeric](15, 0) NULL,
    [SUPER_MERCHANT_PROFILE_ID] [numeric](15, 0) NULL,
    [SERIAL_NO] [varchar](15) NULL,
    [UPDATED_DT] [datetime2](6) NULL,
    [UPDATED_BY] [varchar](50) NULL,
    [SALE_UNIT_EMAIL_ID] [varchar](255) NULL,
    [INVOICE_PARTNER_ID] [varchar](15) NULL

    }

    The source is AzureDB, destination is Azure SQL Data warehouse.

    Any advice?


    "errorCode": "2200", "message": "ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error happened when loading data into SQL Data Warehouse.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Query aborted-- the maximum reject threshold (0 rows) was reached while reading from an external source: 1 rows rejected out of total 1 rows processed.\n(/65125c65-1116-4767-bf5d-8c93e564b9e7/[MERCHANT].[TBL_SALE_UNIT].txt)Column ordinal: 12, Expected data type: DECIMAL(15,0), Offending value: \u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u00
    "errorCode": "2200", "message": "ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error happened when loading data into SQL Data Warehouse.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Query aborted-- the maximum reject threshold (0 rows) was reached while reading from an external source: 1 rows rejected out of total 1 rows processed.\n(/65125c65-1116-4767-bf5d-8c93e564b9e7/[MERCHANT].[TBL_SALE_UNIT].txt)Column ordinal: 12, Expected data type: DECIMAL(15,0), Offending value: \u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u00
    Wednesday, January 17, 2018 2:56 PM