Dqm Index Creation Program Fails with preference does not exist: HZ_DQM_STORAGE (Doc ID 375006.1)

Last updated on OCTOBER 13, 2022

Applies to:

Symptoms

When attempting to Stage All Data the request
fails with the following error.
**Starts**22-JUN-2006 15:50:37
**Ends**22-JUN-2006 15:50:37
Error encountered when running Staging Worker request (ID: 351123). Please
examine request in the log file for more information.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Starting Concurrent Program 'Create DQM indexes'
Start Time 06-22-06 15:31:37

Waiting for workers to complete
Error:
Error User-Defined Exception
Error encountered when running Staging Worker request (ID: 351123). Please
examine request in the log file for more information.
Aborting concurrent program execution
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Concurrent Program 'Create DQM indexes' is erroring
The ARHDQMCR module: DQM Index Creation Program has the following errors:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: HZ_DQM_STORAGE

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

Trading Community Manager -->Control -->Request
-->Run -->Single Request -->DQM Staging Program

Changes

Cause

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