Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 3460000 fails with pvxseqns.odf

edited Sep 2, 2012 11:17PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓
VPC created this thread for customer.

ATTENTION: All workers either have failed or are waiting:

          FAILED: file pvxseqns.odf on worker  1.

in adworker log:

The sequence PV_SEARCH_ATTR_VALUES_S in the database is defined as:
MINVALUE = 1 MAXVALUE = 2000000000 INCREMENT BY = 1
CYCLE = YES ORDER = NO CACHE = 1000

which should be defined as:
MINVALUE = 10000 MAXVALUE = 2000000000 INCREMENT BY = 1
CYCLE = YES ORDER = NO CACHE = 1000
(Note: The cache value for sequence PV_SEARCH_ATTR_VALUES_S is 100000 in the ODF file. The value 1000 is being used instead because this provides better performance when selecting from the sequence.)

Alter the sequence with :


Start time for statement below is: Fri Aug 31 2012 19:49:10

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center