12.2.12 Upgrade Fails On Jtfrs.odf While Creating Index JTF."JTF~RS~RESOURCE~EXTNS~U3" ON JTF.JTF_RS_RESOURCE_EXTNS (Doc ID 3048370.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

Symptoms

While upgrading E-Business Application to 12.2.12 by applying Patch 33527700 (ORACLE E-BUSINESS SUITE 12.2.12 RELEASE UPDATE PACK),it fails on job - jtfrs.odf with following error


ERROR
-----------------------

ATTENTION: All workers either have failed or are waiting:
FAILED: file jtfrs.odf on worker n.


The table is missing the index JTF_RS_RESOURCE_EXTNS_U3
or index JTF_RS_RESOURCE_EXTNS_U3 exists on another table.
Create it with the statement:




CREATE UNIQUE INDEX JTF."JTF~RS~RESOURCE~EXTNS~U3" ON
JTF.JTF_RS_RESOURCE_EXTNS (USER_ID) LOGGING STORAGE (FREELIST GROUPS 4
FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
ONLINE TABLESPACE APPS_TS_TX_IDX

Statement executed.

AD Worker error:
The index cannot be created as the table has duplicate keys.


Use the following SQL statement to identify the duplicate keys:

SELECT USER_ID, count(*)
FROM JTF.JTF_RS_RESOURCE_EXTNS
GROUP BY USER_ID
HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply RUP Patch 33527700
2. Verify the worker log

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.