My Oracle Support Banner

Oracle iStore Search Insert Concurrent Program Error: "DRG-10502: index IBE_CT_IMEDIA_SEARCH_IM does not exist" (Doc ID 834840.1)

Last updated on SEPTEMBER 03, 2018

Applies to:

Oracle iStore - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
*** Checked for relevance on 02-May-2011 ***


Symptoms

When attempting to run the iStore Search Insert concurrent program the following error occurs:

Error

  
IBESERINS module: iStore Search Insert

ORACLE error 29855 in FDPSTP

Cause: FDPSTP failed due to ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index IBE_CT_IMEDIA_SEARCH_IM does not exist

ORA-06512: at "CTXSYS.DR
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
DB VErsion =10.2.0.3.0
Intermedia index exists , dropping intermedia index
deleting data from Search table
Populating search table IBE_CT_IMEDIA_SEARCH
This may take a while depending on how many rows
you have in mtl_system_items_tl table
IBE_USE_CATEGORY_SEARCH =
IBE_FUZZY_SEARCH = N
IBE_SEARCH_CATEGORY_SET =
IBE_SEARCH_WEB_STATUS = PUBLISHED
Creating GLobal Lexer
Creating intermedia index on IBE_CT_IMEDIA_SEARCH table
This may take a while
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


 

Steps To Reproduce

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
Cause
Solution
References

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