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?
Discussion posts and replies are publicly visible
Seems like you forgot to define the primary key. Or forgot it initially and added it later on.
It could definitely be an issue with the primary key configuration. Non-null value to be defined in this field.
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.