E1: TDA: Index Generation Fails with the Error: "Failed to drop primary key from a table" (Doc ID 2782128.1)

Last updated on JUNE 09, 2021

Applies to:

Symptoms

When trying to generate index for some tables (Eg: F0101), it is failing with "Create Index Failed" on-screen message and the below entries are captured in the jde log:

Steps to replicate:

• Login to FAT client
• Access OMW from fastpath
• Add F0101 to a project and perform Get
• Click on the Design Button
• Click on Generate Indexes button available under the Table Operations tab
• Select the correct Data Source, provide the Password and click OK

Changes

Cause

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