FAILED: file perzzlookup00760.ldt on worker 1

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: ATTENTION: All workers either have failed or are waiting:FAILED: file perzzlookup00760.ldt on worker 1
On Applications 12.0.6 :
Facing errors while applying patch E-Business Suite 12.0.4 Release update pack (Rup 4)patch (6435000).


-- Error
************ Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Thu Dec 10 2009 08:24:46
APPL_TOP is set to /d03/appltest/ADTST/apps/apps_st/appl
Done.
ATTENTION: All workers either have failed or are waiting:
FAILED: file perzzlookup00760.ldt on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.


Log files:
LOG FILE
-----------------------
Filename =US_perzzlookup00760_ldt.log
See the following error:
Current system time is Wed Dec 9 14:23:30 2009


Uploading from the data file /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt
Missing closing quotes from quote started at line 4
Altering database NLS_LANGUAGE environment to AMERICAN
Missing closing quotes from quote started at line 4
Missing closing quotes from quote started at line 4
Dumping from LCT/LDT files (/d03/appltest/ADTST/apps/apps_st/appl/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.0.12000000.1), /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt) to staging tables
Dumping LCT file /d03/appltest/ADTST/apps/apps_st/appl/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.0.12000000.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt into FND_SEED_STAGE_ENTITY
Missing closing quotes from quote started at line 4
Uploading from staging tables


Concurrent request completed


Solution:

The cause for this data has been determined as syntax errors in the file perzzlookup00760.ldt version 120.0.12000000.4.

You have file perzzlookup00760.ldt and version 120.0.12000000.4 which is higher than the version that comes with patch 6435000 (ORACLE E-BUSINESS SUITE 12.0.4 RELEASE UPDATE PACK (RUP4)).

However checking file perzzlookup00760.ldt version 120.0.12000000.4 I've found the following line:

LANGUAGE = "US

please note the missing closing quotes (").
The line should be

LANGUAGE = "US"

Correct syntax error in /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt file and then skip the failed worker using adctrl.
Content of perzzlookup00760.ldt 120.0.12000000.4 has been stubbed as per comment in the file:


# Obsoleted for bug 7277065


Therefore there is no need to run this file.


To implement the solution, please execute the following steps:

1. Correct syntax error in /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt file.

replace the following line
LANGUAGE = "US
with
LANGUAGE = "US"

2. Use adctrl executable from a different Unix session and use hidden option "8" to skip the worker that has failed.

3. Continue with patch application

4. Migrate the solution as appropriate to other environments.

Get Oracle Certifications for all Exams
Free Online Exams.com