You are currently reviewing an older revision of this page.
Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("<SCHEMA>"."<TABLE>"."<COLUMN>") as seen in the application server log file. This will also cause the node in the process instance to fail creating an alert. The alert will also contain this error.
This is an error thrown by the Oracle database when you try 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 entity' 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.