")" error thrown when writing to an Oracle database

Symptom

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

The error will be in the application server log. 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 do 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.

Affected Version

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