Skip to main content
Known Participant
Jul 12, 2023 4:56 PM UTC
Question

Error Write records

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
    Brainy
    Jul 12, 2023 5:16 PM UTC

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

    shankark0002
    New Participant
    Jul 13, 2023 3:31 AM UTC

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

    harshm4411
    Participating Frequently
    Jul 26, 2023 12:16 PM UTC

    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.