• State Not Answered
  • Replies 5 replies
  • Subscribers 6 subscribers
  • Views 7717 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Administration

Cannot Insert NULL Into DB Table Error

deeptip
Certified Senior Developer

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

OriginalPostID-206606

OriginalPostID-206606

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    sorry, please ignore the above message.. I wanted to paste this one :
    Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("APPIANDEV"."TEST_DATA"."DATA")

              at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070)
              at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
              at org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1077)
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
              ... 443 more
Reply
  • 0
    Certified Senior Developer
    sorry, please ignore the above message.. I wanted to paste this one :
    Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("APPIANDEV"."TEST_DATA"."DATA")

              at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070)
              at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
              at org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1077)
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
              ... 443 more
Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.