You are currently reviewing an older revision of this page.

DRAFT KB-XXXX Cannot Insert NULL Into DB Table Error

Symptom

Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("APPIANDEV"."TEST_DATA"."DATA")

Cause

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. 

Action

The resolution is to either perform input validation on the value in Appian to ensure you do not attempt to write a null value to the database, or to update your table definition in Oracle to allow the column to contain null values.