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

Symptom

The following error is thrown in the application server log:

Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("<SCHEMA>"."<TABLE>"."<COLUMN>") 

Additionally, the process instance that is attempting to insert the data will fail on the node and an alert will be created.

Cause

This is an error thrown by the Oracle database when trying to insert a null value into a column that does not allow nulls. The error can occur when using the 'Write to Data Store Entity', the 'Write to Multiple Data Store Entities', or the 'Query Database' smart services.

Action

To remediate this error, perform one of the following two options.

• Perform input validation on the process variable in the process to ensure the value is not null.
• Update the database table definition in Oracle to allow null values on the column. Please consult your Oracle DBA for more information on this option.

Affected Versions

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

Last Reviewed: February 2018