DRAFT KB-XXXX ORA-01400: cannot insert NULL into ("<SCHEMA>"."<TABLE>"."<COLUMN>")" error thrown when writing to an Oracle database

Symptom

Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("APPIANDEV"."TEST_DATA"."DATA")

Cause

This is an error thrown by the Oracle database when you try to insert a null value into a column that does not allow nulls. This error can occur when using the write to data store entity smart services, the write to multiple datastore entity or the query database smart services.

Action

Can do one of these two options:

• The resolution is to either perform input validation on the value in Appian to ensure you do not attempt to write a null value to the database
• To update your table definition in Oracle to allow the column to contain null values.