Running Baseline Indexing Intermittently Fails with java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined (Doc ID 2073504.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle Commerce Platform - Version 10.2 and later
Information in this document applies to any platform.

Symptoms

The following exception is seen intermittently during indexing:

Running the baseline again succeeds.

Steps to reproduce:
A. In dyn/admin go to component /atg/commerce/endeca/index/ProductCatalogSimpleIndexingAdmin/
B. Click the Baseline Index button. Intermittently the error will appear.
C. Clicking the Baseline Index button again the baseline will succeed.

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