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.
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, perform one of the following two options.
This article applies to all versions of Appian using Oracle as a business data source.
Last Reviewed: February 2018
© 2020 Appian. All rights reserved.