My Oracle Support Banner

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

Last updated on MAY 31, 2019

Applies to:

Oracle Trading Community - Version 11.5.9 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution


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