ORA-04007 Error When Altering Email Center Sequences (Doc ID 1140115.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Email Center - Version 12.1.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 27-May-2014 ***

Email Center Sequences:
IEM_ACCOUNT_TAG_KEYS_S1
IEM_TAG_KEYS_S1
IEM_ENCRYPTED_TAGS_S1
IEM_ENCRYPTED_TAG_DTLS_S1

Symptoms

Adpatch reports the following error:

ALTER SEQUENCE IEM.IEM_ENCRYPTED_TAGS_S1 MINVALUE 10000

AD Worker error:
The following ORACLE error:

ORA-04007: MINVALUE cannot be made to exceed the current value occurred while executing the SQL statement:

ALTER SEQUENCE IEM.IEM_ENCRYPTED_TAGS_S1 MINVALUE 10000

AD Worker error:
Unable to compare or correct sequences because of the error above



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