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