Numeric Overflow Error getting next sequence in the JBoss ON Server Log

Solution Verified - Updated -

Issue

  • Seeing below error in JBoss ON Server log:
2015-11-03 13:01:14,430 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 17026, SQLState: 99999
2015-11-03 13:01:14,430 ERROR [org.hibernate.util.JDBCExceptionReporter] Numeric Overflow

Environment

  • Red Hat JBoss Operations Network (ON) 3.1.2
  • Oracle Database
  • Full error in log:
org.hibernate.exception.GenericJDBCException: could not get next sequence value
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
    at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)
    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)
    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38)
    at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:618)
    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:592)
    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:596)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:212)
    ... 133 more
Caused by: java.sql.SQLException: Numeric Overflow
    at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4381)
    at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:132)
    at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
    at org.jboss.resource.adapter.jdbc.WrappedResultSet.getInt(WrappedResultSet.java:685)
    at org.hibernate.id.IdentifierGeneratorFactory.get(IdentifierGeneratorFactory.java:84)
    at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:78)
    ... 141 more
2015-11-03 13:32:52,279 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 17026, SQLState: 99999
2015-11-03 13:32:52,281 ERROR [org.hibernate.util.JDBCExceptionReporter] Numeric Overflow

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.