Cannot Insert NULL Into DB Table Error

deeptip

Certified Senior Developer

over 9 years ago

While trying to import a patch on 7.10 oracle I get the following error:
An error occurred while updating content [id=3477 uuid=_a-0000d925-a467-8000-4594-010000010000_13518]: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update (APNX-1-4071-008)
com.appiancorp.ix.ConsumerException: type=content, srcId=_a-0000d925-a467-8000-4594-010000010000_13518, dstId=3477, cause=org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException:

The patch was created on the same version and yet fails to import back in. Any inputs?
Thanks

Discussion posts and replies are publicly visible

Parents

0 Tom Ryan
Appian Employee
over 9 years ago

The relevant line appears to be:

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

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. The resolution is to either not use a null value or to update your table definition to allow it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tom Ryan
Appian Employee
over 9 years ago

The relevant line appears to be:

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

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. The resolution is to either not use a null value or to update your table definition to allow it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data