We are currently performing maintenance on Appian Community. As a result, discussions posts and replies are temporarily unavailable. We appreciate your patience.
  • State Not Answered
  • Replies 5 replies
  • Subscribers 10 subscribers
  • Views 7180 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
    Caused by: 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
              at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:321)
              at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)
              at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:516)
              at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
              at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
              at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:387)
              at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
              at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
              at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
              at com.sun.proxy.$Proxy263.saveTestData(Unknown Source)
              at com.appiancorp.object.test.TestDataService.saveTestData(TestDataService.java:69)
              at com.appiancorp.object.test.SecuredTestDataService.saveTestData(SecuredTestDataService.java:67)
              at com.appiancorp.object.test.SecuredTestDataService.saveTestData(SecuredTestDataService.java:56)
              at com.appiancorp.ix.data.SupportsTestData.saveTestData(SupportsTestData.java:56)
              at com.appiancorp.ix.data.ContentHaul.saveTestData(ContentHaul.java:428)
              at com.appiancorp.ix.data.ContentHaul.update(ContentHaul.java:296)
              at com.appiancorp.ix.data.ContentHaul.update(ContentHaul.java:73)
              at com.appiancorp.ix.HaulImportConsumer.update(HaulImportConsumer.java:53)
              at com.appiancorp.ix.HaulImportConsumer.update(HaulImportConsumer.java:21)
              at com.appiancorp.ix.ImportConsumer.consume(ImportConsumer.java:42)
              ... 413 more
    Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214)
              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147)
              at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:81)
              at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)
              ... 434 more
    Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
Reply
  • 0
    Certified Senior Developer
    Caused by: 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
              at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:321)
              at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)
              at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:516)
              at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
              at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
              at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:387)
              at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
              at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
              at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
              at com.sun.proxy.$Proxy263.saveTestData(Unknown Source)
              at com.appiancorp.object.test.TestDataService.saveTestData(TestDataService.java:69)
              at com.appiancorp.object.test.SecuredTestDataService.saveTestData(SecuredTestDataService.java:67)
              at com.appiancorp.object.test.SecuredTestDataService.saveTestData(SecuredTestDataService.java:56)
              at com.appiancorp.ix.data.SupportsTestData.saveTestData(SupportsTestData.java:56)
              at com.appiancorp.ix.data.ContentHaul.saveTestData(ContentHaul.java:428)
              at com.appiancorp.ix.data.ContentHaul.update(ContentHaul.java:296)
              at com.appiancorp.ix.data.ContentHaul.update(ContentHaul.java:73)
              at com.appiancorp.ix.HaulImportConsumer.update(HaulImportConsumer.java:53)
              at com.appiancorp.ix.HaulImportConsumer.update(HaulImportConsumer.java:21)
              at com.appiancorp.ix.ImportConsumer.consume(ImportConsumer.java:42)
              ... 413 more
    Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214)
              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147)
              at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:81)
              at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)
              ... 434 more
    Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.