Work with Us!
Your bugs help others
We want to create amazing apps without being stopped by crashes. Join us to help others who have the same bug.

java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("AVSYS"."EVENT_LOG_TEMP"."ALERT_RAISED")

Oracle Community | Santosh Pradhan | 3 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Collector unable to start

    Oracle Community | 3 years ago | Santosh Pradhan
    java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("AVSYS"."EVENT_LOG_TEMP"."ALERT_RAISED")
    find similars
    Oracle jdbc Java RT oracle.ucp.jdbc com.sun.proxy oracle.av.platform
    0
  2. 0

    ODI 12.1.3 Import Error

    Oracle Community | 2 years ago | AK26
    com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10036: Importing object SNP_USRPREFERENCE : null (with global id: 84e4f134-7a98-4e6e-858c-0de654ddfd49 and internal id: null) failed.
    find similars
    Oracle jdbc Java RT oracle.ucp.jdbc com.sun.proxy Java RT
    0
  3. 0

    URGENT - unique constraint (ODI_WORK.PK_EXP_TXT) violated in ODI 11g

    Oracle Community | 6 years ago | 811595
    java.sql.BatchUpdateException: ORA-00001: unique constraint (ODI_WORK.PK_EXP_TXT) violated
    find similars
    Oracle jdbc Java RT oracle.ucp.jdbc Unknown Component Java RT
    0

  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-01438 when executing a JDBC batch

    Oracle Community | 8 years ago | 610216
    java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column
    find similars
    Oracle jdbc Java RT oracle.ucp.jdbc Unknown Component com.sqlstress.test
    0
  6. 0

    We noticed that our portal (version 4.4.0-snapshot) no longer was aggregating portal events. Looking in the portal-event.log the exception stack trace shown below indicated that a search term the portal was trying to aggregate was too long for the column I solved the problem (I hope) by increasing the size of the search_term column in table UP_SEARCH_REQ_AGGR form 255 to 500. After the change the portal started to aggregate events again. ERROR [uP-TaskExec-891-aggregateRawEvents] o.j.p.e.a.PortalEventProcessingManagerImpl 2016-10-06 08:55:03,496 - aggregateRawEvents failed org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into UP_SEARCH_REQ_AGGR (AGGR_GROUP_ID, DATE_DIMENSION_ID, DURATION, AGGR_INTERVAL, TIME_DIMENSION_ID, STATS_COMPLETE, SEARCH_COUNT, SEARCH_TERM, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [12899]; could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:651) ~[spring-orm-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:106) ~[spring-orm-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517) ~[spring-orm-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:148) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.jasig.portal.events.aggr.PortalRawEventsAggregatorImpl.doAggregateRawEvents(PortalRawEventsAggregatorImpl.java:217) ~[classes/:4.4.0-SNAPSHOT] at sun.reflect.GeneratedMethodAccessor1001.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) ~[spring-aop-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) ~[spring-aop-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) ~[spring-aop-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) ~[spring-tx-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[spring-aop-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) ~[spring-aop-3.2.9.RELEASE.jar:3.2.9.RELEASE] at com.sun.proxy.$Proxy226.doAggregateRawEvents(Unknown Source) ~[na:na] at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl$3.apply(PortalEventProcessingManagerImpl.java:204) ~[classes/:4.4.0-SNAPSHOT] at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl$3.apply(PortalEventProcessingManagerImpl.java:201) ~[classes/:4.4.0-SNAPSHOT] at org.jasig.portal.concurrency.locking.ClusterLockServiceImpl.doInTryLock(ClusterLockServiceImpl.java:200) ~[classes/:4.4.0-SNAPSHOT] at org.jasig.portal.events.aggr.PortalEventProcessingManagerImpl.aggregateRawEvents(PortalEventProcessingManagerImpl.java:199) ~[classes/:4.4.0-SNAPSHOT] at sun.reflect.GeneratedMethodAccessor835.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91] at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64) [spring-context-3.2.9.RELEASE.jar:3.2.9.RELEASE] at org.jasig.portal.utils.threading.ThreadNamingRunnable.run(ThreadNamingRunnable.java:41) [classes/:4.4.0-SNAPSHOT] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_91] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91] Caused by: org.hibernate.exception.GenericJDBCException: could not execute batch at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:122) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:196) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3057) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75) ~[hibernate-entitymanager-4.2.19.Final.jar:4.2.19.Final] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:513) ~[spring-orm-3.2.9.RELEASE.jar:3.2.9.RELEASE] ... 30 common frames omitted Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "UPORTAL43"."UP_SEARCH_REQ_AGGR"."SEARCH_TERM" (actual: 264, maximum: 255) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11190) ~[ojdbc7-12.1.0.1.jar:12.1.0.1.0] at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244) ~[ojdbc7-12.1.0.1.jar:12.1.0.1.0] at sun.reflect.GeneratedMethodAccessor589.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91] at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) ~[tomcat-jdbc-7.0.37.jar:na] at com.sun.proxy.$Proxy49.executeBatch(Unknown Source) ~[na:na] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:113) ~[hibernate-core-4.2.19.Final.jar:4.2.19.Final] ... 47 common frames omitted

    Apereo Issues | 8 months ago | Bruce Phillips
    org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into UP_SEARCH_REQ_AGGR (AGGR_GROUP_ID, DATE_DIMENSION_ID, DURATION, AGGR_INTERVAL, TIME_DIMENSION_ID, STATS_COMPLETE, SEARCH_COUNT, SEARCH_TERM, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [12899]; could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch
    find similars
    Oracle jdbc Java RT org.apache.tomcat com.sun.proxy Hibernate
    0

  1. treefolk
    Oracle jdbc Java RT oracle.ucp.jdbc com.sun.proxy oracle.av.platform
    2 times, last 5 months ago
  2. r1chjames
    Oracle jdbc Java RT oracle.ucp.jdbc com.sun.proxy oracle.av.platform
    10 times, last 11 months ago
12 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.BatchUpdateException

    ORA-01400: cannot insert NULL into ("AVSYS"."EVENT_LOG_TEMP"."ALERT_RAISED")

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch()
  2. Oracle jdbc
    OracleStatementWrapper.executeBatch
    1. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
    2. oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
    56 similar
    2 frames
  3. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    63 similar
    4 frames
  4. oracle.ucp.jdbc
    PreparedStatementProxyFactory.invoke
    1. oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)
    2. oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)
    3 similar
    2 frames
  5. com.sun.proxy
    $Proxy42.executeBatch
    1. com.sun.proxy.$Proxy42.executeBatch(Unknown Source)
    1 similar
    1 frame
  6. oracle.av.platform
    CollectionController.run
    1. oracle.av.platform.agent.collfwk.impl.batch.JDBCBatchingFlush.flush(JDBCBatchingFlush.java:147)
    2. oracle.av.platform.agent.collfwk.impl.batch.ArrayBasedBatch.flush(ArrayBasedBatch.java:174)
    3. oracle.av.platform.agent.collfwk.impl.controller.CollectionController.release(CollectionController.java:753)
    4. oracle.av.platform.agent.collfwk.impl.controller.CollectionController.run(CollectionController.java:373)
    1 similar
    4 frames
  7. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:744)
    87 similar
    1 frame