Skip to main content
August 8, 2023
Question

error during inserting data in table

  • August 8, 2023
  • 5 replies
  • 0 views

what should i do

    5 replies

    csteward
    August 8, 2023

    You should update your data source to allow null values, or populate the data point before writing to the DS.

    August 8, 2023

    how aaply default here in db

    mikes0011
    Brainy
    August 8, 2023

    you will need to populate a proper value before inserting, and if you can't do that, you'll need to modify the column in the DB table to accept null values.  There's no automatic way to make Appian insert the default value as defined in the DB, nor should there be any reason to.

    The error message tells us pretty plainly (after you get used to reading through the clutter) which column this error is in reference to, BTW.

    August 9, 2023

    Hi, 

    please open your table structure and select the field which is not accepting null values and mark the checkbox as null.