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

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

      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")

            [CWD-4233] ORA-01400: cannot insert NULL into table, SQL Error: 1400, SQLState: 23000

            This doesn't look like a Crowd exception. Closing as invalid.

            Please feel free to correct me if I'm wrong, and provide some context to reproduce the issue (Crowd version? Oracle version? steps to reproduce?).

            Diego Berrueta added a comment - This doesn't look like a Crowd exception. Closing as invalid. Please feel free to correct me if I'm wrong, and provide some context to reproduce the issue (Crowd version? Oracle version? steps to reproduce?).

              Unassigned Unassigned
              7051f9f5da33 Naveen Kumar Garimidi
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: