Forum Discussion

wwilbur's avatar
wwilbur
Occasional Contributor
3 years ago

java.sql.DataTruncation: Data truncation error

I am able to update and insert into a DB2 schema and table using DBeaver but when I try to do these in ReadyAPI I get the error message java.sql.DataTruncation: Data truncation error   Here is the ...
  • richie's avatar
    richie
    3 years ago

    Hey wwilbur 

     

    In that case there's some problem with the propertyexpansion I'm guessing.

     

    Only thing I can suggest to diagnose is try doing the simplest INSERT and repeatedly swap out expanded values across the different table attributes to identify the problematic attribute value (I'm assuming here that the problem isn't EVERY single attribute).

     

    So - I'd do the following:

    Step1: hardcode all the values excepting 1 attribute (where you expand), run the steps and check the results

    Step2: move to the next attribute value and repeat Step1 process

    Step3: continue until you've covered off all the attributes

     

    Cheers,

     

    Rich