Sev1: Upgrade patch driver (6678700) failed with: file xdpconf.odf on worker1
Hi,
Run the American English upgrade patch driver (6678700) failed with: file xdpconf.odf on worker1
Problem Description
---------------------------------------------------
while checking adworker001.log i found:
CREATE UNIQUE INDEX XDP.XDP_WI_PARAMETERS_U1 ON XDP.XDP_WI_PARAMETERS
(WORKITEM_ID, PARAMETER_NAME) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS
4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_SEED
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 WORKITEM_ID, PARAMETER_NAME, count(*)
FROM XDP.XDP_WI_PARAMETERS
GROUP BY WORKITEM_ID, PARAMETER_NAME
HAVING count(*)>1
Run the American English upgrade patch driver (6678700) failed with: file xdpconf.odf on worker1
Problem Description
---------------------------------------------------
while checking adworker001.log i found:
CREATE UNIQUE INDEX XDP.XDP_WI_PARAMETERS_U1 ON XDP.XDP_WI_PARAMETERS
(WORKITEM_ID, PARAMETER_NAME) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS
4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_SEED
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 WORKITEM_ID, PARAMETER_NAME, count(*)
FROM XDP.XDP_WI_PARAMETERS
GROUP BY WORKITEM_ID, PARAMETER_NAME
HAVING count(*)>1
Tagged:
0