Oracle Commerce Service Center (CSC): When Creating SRCH_SEARCH_* Indexes Encountering DRG-10700: Preference Does Not Exist: Specifying ATGSEARCHLEXER

(Doc ID 1911347.1)

Last updated on AUGUST 26, 2015

Applies to:

Oracle Commerce Service Center - Version 11.0 and later
Information in this document applies to any platform.

Symptoms

Beginning in Oracle Commerce Service Center (CSC) version 11 and later, profile and order search uses a full text search as described in
Note 1909996.1 - Oracle Commerce Version 11.1 What's New Reference

This article describes a problem in which the full text search indexes SRCH_SEARCH_ORDER_IDX and SRCH_SEARCH_PROFILE_IDX were dropped.
Then they were recreated with the script:

<ATGDIR>/DAF/TextSearch/Index/sql/install/oracle/search_post_install.sql

The creation failed with these errors:

Changes

Upgraded to Oracle Commerce 11. Due to issues with SRCH_ORDER_TOKENS and SRCH_PROFILE_TOKENS it was decided to drop and recreate the SRCH_SEARCH_ORDER_IDX and SRCH_SEARCH_PROFILE_IDX.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms