Sequence <name>.NEXTVAL exceeds MAXVALUE (Doc ID 437752.1)

Last updated on OCTOBER 14, 2014

Applies to:

Oracle Healthcare Transaction Base - Version: 5.2

Symptoms

After loading millions of messages into HTB, it seems that one internal sequence has been reached the max value.

When trying to log in into HTB or send a message the following exception is raised:

MESSAGE_PARAM = oracle.jbo.SQLStmtException: JBO-27120: Error SQL durante la ejecución de la consulta. Sentencia: select <name>.nextval from dual


Originating Stacktrace:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE.
Tokens: MESSAGE = oracle.jbo.SQLStmtException: JBO-27120: Error SQL durante la ejecución de la consulta. Sentencia: select <name>.nextval from dual;

java.sql.SQLException: ORA-08004: sequence <name>.NEXTVAL exceeds MAXVALUE and cannot be instantiated

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms