Skip to main content
C
carlosp5114
July 12, 2023
Question

Error Write records

  • July 12, 2023
  • 3 replies
  • 0 views

Hi! I have a write records smart service but it gives me the following error:

Unable to write to the source because the data source did not respond. Error Details: Field 'a_id' doesn't have a default value

What is causing this trouble?

    3 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 12, 2023

    Seems like you forgot to define the primary key. Or forgot it initially and added it later on.

    shankark0002
    shankark0002
    July 13, 2023

    It could definitely be an issue with the primary key configuration. Non-null value to be defined in this field.

    harshm4411
    harshm4411
    July 26, 2023

    This occurs when the auto-increment option is not enabled for the 'id' field (i.e., the Primary Key) in database. Please refer to the attached image for details. If you do not wish to use auto-increment, you must manually provide a value for the 'id' field from an external source.

    Terms & ConditionsAccessibility statement