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:

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

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