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 ("<SCHEMA>"."<TABLE>"."<COLUMN>") 
as seen in the application server log file.  This will also cause the node in the process instance to fail creating an alert. The alert will also contain this error.

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',  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.

Affected Versions

This article applies to all versions of Appian using Oracle as a business data source.