My Oracle Support Banner

E1: TDA: Generate Indexes Operation Fails with Error: "The primary key constraint 'FXXXX_PK' on table 'FXXXX' cannot be dropped because change tracking is enabled on the table." in the jde.log (Doc ID 2982494.1)

Last updated on OCTOBER 25, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When trying to generate indexs for some tables, it is failing with below errors in the jde.log. The example given below is for table F03B11 but it can happen with other tables as well.

7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.189000 jdbodbc.c8125
                        ODB0000163 - wSQLExecute failure. rc=-1
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.189001 jdbodbc.c8125
                        ODB0000164 - STMT:00 [42000][3735][2] [Microsoft][SQL Server Native Client 11.0][SQL Server]The primary key constraint 'F03B11_PK' on table 'F03B11' cannot be dropped because change tracking is enabled on the table. Change tracking requires a primary key constraint on the table. Disable chang
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.190000 jdbodbc.c8125
                        ODB0000164 - STMT:01 [42000][3727][2] [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not drop constraint. See previous errors.
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.190001 jdb_drvm.c1000
                        JDB9900401 - Failed to execute db request
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.190002 jdb_exem.c3527
                        JDB2100066 - Failed to drop primary key from a table
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.604000 jdbodbc.c8125
                        ODB0000163 - wSQLExecute failure. rc=-1
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.604001 jdbodbc.c8125
                        ODB0000164 - STMT:00 [42000][5074][2] [Microsoft][SQL Server Native Client 11.0][SQL Server]The object 'F03B11_PK' is dependent on column 'RPDOC'.
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.604002 jdbodbc.c8125
                        ODB0000164 - STMT:01 [42000][4922][2] [Microsoft][SQL Server Native Client 11.0][SQL Server]ALTER TABLE ALTER COLUMN RPDOC failed because one or more objects access this column.
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.604003 jdb_exem.c2522
                        JDB2100050 - Failed to change column property of RPDOC for table F03B11 in data source Business Data - TEST
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.689000 jdb_exem.c2724
                        JDB2100069 - Failed to drop index number 1 for table F03B11
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.689001 jdb_exem.c3157
                        JDB2100074 - Failed to drop index in order to create primary key for table F03B11 in data source Business Data - TEST
 
7896/8056 WRK:Starting jdeCallObject                           Fri Oct 20 09:41:01.689002 jdb_exem.c1490
                        JDB2100042 - Failed to add primary key

Steps to replicate:

  1. Access OMW from fastpath
  2. Move F03B11 to a project and perform a Get
  3. Click on Design --> Table Operations --> Generate Indexes
  4. Select the required Data Source, enter the Password and click OK

Changes

 

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


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