ATTENTION: All workers either have failed or are waiting:
FAILED: file cskbcat.ldt on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker log:
Time when worker restarted job: Sun Feb 19 2017 06:33:15
Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @CS:patch/115/import/cskbcat.lct @CS:patch/115/import/US/cskbcat.ldt -
Connecting to APPS......Connected successfully.
Calling FNDLOAD function.
Returned from FNDLOAD function.
Log file: /u01/oracle/TEST/fs1/EBSapps/appl/admin/TEST/log/US_cskbcat_ldt.log
Error calling FNDLOAD function.
Time when worker failed: Sun Feb 19 2017 06:33:16
Fndload log file:
Uploading from the data file /u01/oracle/TEST/fs1/EBSapps/appl/cs/12.0.0/patch/115/import/US/cskbcat.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01/oracle/TEST/fs1/EBSapps/appl/cs/12.0.0/patch/115/import/cskbcat.lct(120.1), /u01/oracle/TEST/fs1/EBSapps/appl/cs/12.0.0/patch/115/import/US/cskbcat.ldt) to staging tables
Dumping LCT file /u01/oracle/TEST/fs1/EBSapps/appl/cs/12.0.0/patch/115/import/cskbcat.lct(120.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u01/oracle/TEST/fs1/EBSapps/appl/cs/12.0.0/patch/115/import/US/cskbcat.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (CS_KB_SOLN_CATEGORIES_VL 1 , CS_KB_SOLN_CATEGORIES_VL 1 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for CS_KB_SOLN_CATEGORIES_VL: CATEGORY_ID = 1, ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10607: index meta data is not ready yet for queuing DML
DRG-13201: KOREAN_LEXER is desupported
ORA-30576: ConText Option dictionary loading error
Concurrent request completed
Current system time is Sun Feb 19 06:33:16 2017
Solution:
As per Applying The Patch 6678700 Worker 1 Failed: File Cskbcat.Ldt. ERRORS: ORA-20000: Oracle Text error: DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate, DRG-13201: KOREAN_LEXER is desupported (Doc ID 1333659.1)
{oratest@ruh01sm4k02: ~ $} sqlplus "/ as sysdba" @$ORACLE_HOME/ctx/sample/script/drkorean.sql
SQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 19 06:37:29 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
List of indexes that use KOREAN_LEXER as top level lexer:
List of indexes that use KOREAN_LEXER as a sub lexer:
"CS"."CS_FORUM_MESSAGES_TL_N4"
"CS"."CS_INCIDENTS_ALL_TL_N1"
"CS"."CS_KB_ELEMENTS_TL_N2"
"CS"."CS_KB_SETS_TL_N3"
"CS"."CS_KB_SOLN_CAT_TL_N1"
"ICX"."ICX_QUES_CTX"
Migrate KOREAN_LEXER to KOREAN_MORPH_LEXER
Rebuild all indexes that use korean lexer as top level lexer:
Reindex all documents that use KOREAN_LEXER as sub lexer
reindexing : "CS"."CS_FORUM_MESSAGES_TL" finished.
reindexing : "CS"."CS_INCIDENTS_ALL_TL" finished.
reindexing : "CS"."CS_KB_ELEMENTS_TL" finished.
reindexing : "CS"."CS_KB_SETS_TL" finished.
reindexing : "CS"."CS_KB_SOLN_CATEGORIES_TL" finished.
reindexing : "ICX"."ICX_QUESTIONS_TL" finished.
SQL>
a) Restart failed worker
No comments:
Post a Comment