E1: TDA: Index Generation on a Co-Existence AS/400 Table (Releases Xe/ERP 8) (Doc ID 626477.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
IBM i on POWER Systems
Reviewed for relevance Oct-19-2010


Symptoms

I am performing an Index Generation on a Co-Existence AS/400 table after new indexes have been added to the table in Table Design Aid in Object Management Workbench (OMW).  I receive an error of "Index Generation - Create Index Failed"; however the Indexes have been created.

The ALTER TABLE command has failed with SQL error SQL7008 below.  The following displays in the logs.

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