You are currently reviewing an older revision of this page.
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.
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.
To remediate this error do one of the following two options.
This article applies to all versions of Appian using Oracle as a business data source.