Forum Discussion

fmdf's avatar
fmdf
New Contributor III
5 years ago
Solved

Right Truncation on column

Without any changes to target or source, I’m now getting this error: Failed loading record, reason=#@ Row 2346, Column 9: String data, right truncation @# Questions: Column 9 is not the actua...
  • SpiroTaleski's avatar
    SpiroTaleski
    6 years ago

    Hi @Tommy

    I have tried the same approach using the Salesforce Read Snap and get the same error message. It looks like a SnapLogic bug that does not allow to get the value from the input schema for that field.

    If you are using the Salesforce Read Snap you can specify the Object type from the pipeline parameters(ex : _SFObject).

    If you are using the Saleforce SOQL Snap then you can specify the object type dynamically from the input schema in the SOQL query section of the Snap:

    Regards,
    Spiro

fmdf's avatar
fmdf
New Contributor III
5 years ago
Copy LinkReport

I found the issue today.

We had initially been using AWS Data Migration Services for the table in question. It auto created a column of Numeric(38,10). DMS did this for ALL Oracle columns with a data type of NUMBER. We did analysis on the source data (which is just Oracle NUMBER with no precision) and didn’t see any examples of non-integer data. We converted that column to a numeric(18,0).

Job ran for days with no issue and then suddenly failed…column 9, row x was truncating.

I opened up SSMS and did a generate create table script. Column 9 in the list was Numeric (18,0) as mentioned.

I queried the source table and found 1 row with decimal data. I modified my target column and now the job works.

I wish it was easier and we got better error messaging. It would have made things quicker.

mbowen's avatar
mbowen
Employee
5 years ago
Copy LinkReport

We’ve added a debug view to some of our snaps, for example, the SOAP snap, and plan to do similar for more snaps. Hopefully, we’ll be able to make hunting down these kinds of problems easier in the future. Good job on identifying and fixing this.

  • M