My Oracle Support Banner

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

Last updated on OCTOBER 13, 2022

Applies to:

Oracle Trading Community - Version and later
Information in this document applies to any platform.
ARHDQM module: DQM Staging Program
ARHDQMCR module: DQM Index Creation Program


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
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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.