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>") 

This error can be seen in the application server log file.  This error will cause the node in the process instance to fail creating an alert.

Cause

This is an error thrown by the Oracle database when you trying 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 Entities' 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.