Get Data Moving 1
Results 1 to 3 of 3

Thread: 'String Qualifier for .csv created in Blob Storage by the Attunity Replicate'

  1. #1
    akanksha.1787 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    22
    Rep Power
    0

    'String Qualifier for .csv created in Blob Storage by the Attunity Replicate'

    Hi Experts,

    We have a scenario where we were loading data from an Oracle source into Azure SQL Datawarehouse.
    The task failed after loading about 1 million records.

    Below is the error message from the log .

    RetCode: SQL_ERROR SqlState: 42000 NativeError: 107090 Message: [Microsoft][SQL Server Native Client 11.0]
    [SQL Server]Query aborted-- the maximum reject threshold (0 rows) was reached while reading from an external source:
    1 rows rejected out of total 305 rows processed.
    (/stagingzone/T_ORA_SQLDW_PROD_WARRANTY/6/LOAD00000CC6.csv)Column ordinal: 56, Expected data type: VARCHAR(12)
    collate SQL_Latin1_General_CP1_CI_AS, Offending value: # REGARDS H BEUKES (Column Conversion Error),
    Error: String or binary data would be truncated. Line: 1 Column: -1
    error me

    Our Analysis:
    Our understanding is that, there is a problem with the column no# 56.
    In our case the column no# 56 is 'STORY' which also contains special characters and its datatype is varchar(2000) and column no. 57 has a datatype of
    varchar(12).

    We believe that the .csv file which gets created on the Blob storage has a 'Delimiter' which is same as one of the special characters in the data for column no.#56 . The data is after the delimiter is "REGARDS H BEUKES " which gets pushed to the column no.# 57 and gets truncated as the column has a length of
    varchar(12).

    Information Seeked:

    Could you let us know if there is anyway we could set up a string qualifier such as (" double quotes ") in the attuntiy replicate tool to be applied on the .csv file.

    Your response would be valuable to us.

    Regards,
    Akanksha

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6

  3. #3
    akanksha.1787 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    22
    Rep Power
    0
    Quote Originally Posted by stevenguyen View Post

    Thank you for your response steve.

    Regards,
    Akanksha

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •