Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-4233

ORA-01400: cannot insert NULL into table, SQL Error: 1400, SQLState: 23000

    XMLWordPrintable

Details

    • Bug
    • Resolution: Invalid
    • High
    • None
    • None
    • Database, Deployment
    • Acceptance

    Description

      2015-02-04 09:50:07,573 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000
      [main] 2015-02-04 09:50:07,573 ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01400: cannot insert NULL into ("CFREVGEAR"."SELECTED_CLM_FILE"."CLM_FILE_FLTR_CRITA_ID")

      [main] 2015-02-04 09:50:07,573 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000
      [main] 2015-02-04 09:50:07,573 ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01400: cannot insert NULL into ("CFREVGEAR"."SELECTED_CLM_FILE"."CLM_FILE_FLTR_CRITA_ID")

      [main] 2015-02-04 09:50:07,574 ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
      org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
      at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
      at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
      at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
      at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
      at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
      at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:657)
      at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)
      at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)
      at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)
      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:124)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      at $Proxy25.processFileGeneratorRuns(Unknown Source)
      at com.amfam.icscfrs.batch.launch.FileGeneratorFinalizeBatch.execute(FileGeneratorFinalizeBatch.java:29)
      at com.amfam.coregear.common.batch.BatchSupport.execute(BatchSupport.java:53)
      at com.amfam.icscfrs.batch.launch.FileGeneratorFinalizeBatch.main(FileGeneratorFinalizeBatch.java:16)
      Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("CFREVGEAR"."SELECTED_CLM_FILE"."CLM_FILE_FLTR_CRITA_ID")

      Attachments

        Activity

          People

            Unassigned Unassigned
            7051f9f5da33 Naveen Kumar Garimidi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: