Issue# 25:
While applying main upgrade merged patch
ATTENTION: All workers either have failed or are waiting:
FAILED: file cnsca.odf on worker 5.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker log:
Start time for statement below is: Sun Apr 23 2017 11:18:36
CREATE UNIQUE INDEX CN."CN_SCA_RULE_ATTRIB_ALL_TL_U2" ON
CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL (SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE)
LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11
MAXTRANS 225 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 SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE, count(*)
FROM CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL
GROUP BY SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE
HAVING count(*)>1
AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above
Solution:
Doc ID 1674721.1
SQL> set pages 1000 lin 300
SELECT SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE, count(*)
FROM CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL
GROUP BY SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE
HAVING count(*)>1 ;
SQL> 2 3 4
SCA_RULE_ATTRIBUTE_ID ORG_ID LANG COUNT(*)
--------------------- ---------- ---- ----------
-1017 AR 3
-1001 AR 3
-1000 AR 3
-1013 AR 3
-1012 AR 3
-1011 AR 3
-1007 AR 3
-1006 AR 3
-1023 AR 3
-1022 AR 3
-1016 AR 3
-1019 AR 3
-1015 AR 3
-1014 AR 3
-1010 AR 3
-1008 AR 3
-1018 AR 3
-1004 AR 3
-1003 AR 3
-1002 AR 3
-1009 AR 3
-1005 AR 3
-1021 AR 3
-1020 AR 3
24 rows selected.
SQL> CREATE table cn_sca_rule_attrib_all_tl_bkp AS
SELECT * FROM cn_sca_rule_attributes_all_tl;
2
Table created.
SQL> SELECT SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE, count(*)
FROM cn_sca_rule_attrib_all_tl_bkp
GROUP BY SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE
HAVING count(*)>1;
2 3 4
SCA_RULE_ATTRIBUTE_ID ORG_ID LANG COUNT(*)
--------------------- ---------- ---- ----------
-1017 AR 3
-1001 AR 3
-1000 AR 3
-1013 AR 3
-1012 AR 3
-1011 AR 3
-1007 AR 3
-1006 AR 3
-1023 AR 3
-1022 AR 3
-1016 AR 3
-1019 AR 3
-1015 AR 3
-1014 AR 3
-1010 AR 3
-1008 AR 3
-1018 AR 3
-1004 AR 3
-1003 AR 3
-1002 AR 3
-1009 AR 3
-1005 AR 3
-1021 AR 3
-1020 AR 3
24 rows selected.
SQL>
- ORG_ID is null
SQL> DELETE FROM cn_sca_rule_attributes_all_tl WHERE org_id IS NULL;
72 rows deleted.
SQL> commit;
Commit complete.
SQL>
- Restart failed worker
No comments:
Post a Comment