DQM Staging Errors With 'DRG-10754: Memory Size Must Be Between 1024 And 52428800' When Creating Indexes (Doc ID 420078.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 11.5.10.2 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.
ARHDQM module: DQM Staging Program
ARHDQMCR module: DQM Index Creation Program

Symptoms

The DQM Staging program fails with the following error in the log file when creating indexes:

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Starting Concurrent Program 'Create DQM indexes'
Start Time 02-21-07 12:16:06

Waiting for workers to complete
Workers have completed successfully
Index build type is CREATE for the INDEX Worker
Creating hz_stage_parties_t1 on hz_staged_parties.
Index Memory 4
Starting at 12:18:38
Error:
SQL Error ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10754: memory size must be between 1024 and 52428800

Aborting concurrent program execution
+---------------------------------------------------------------------------+


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