Tag Archives: adworker

mth_pre_upgrade.sql Failed While Rerunning Patch 9239090

Posted by on January 30, 2012 No comments

Problem:

When rerunning patch 9239090, the following error appears:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file mth_pre_upgrade.sql on worker  1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checked worker log file:
C:oracleTEST1appsapps_stappladminTEST1logadwork001.log

The following errors appeared:

Time when worker started job: Mon Jan 30 2012 09:42:06

Start time for file is: Mon Jan 30 2012 09:42:06

sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql 

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this operating system.DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59

Time when worker failed: Mon Jan 30 2012 09:42:06

Time when worker started job: Mon Jan 30 2012 09:42:06

Start time for file is: Mon Jan 30 2012 09:42:06

sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql 

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this operating system.DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59

Time when worker failed: Mon Jan 30 2012 09:42:06

Solution:

1. Edit C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql  and uncomment SQL code for Exception. Then restart worker (did not try this solution).

2. Use adctrl (option 8) to skip and restart this step (tried this solution).

Reference:

https://forums.oracle.com/forums/thread.jspa?messageID=9224027

[amazon asin=0070077290&template=iframe image&chan=default]     [amazon asin=1453742735&template=iframe image&chan=default]     [amazon asin=0615238440&template=iframe image&chan=default]

Invalid responsibility running patch 3262159

Posted by on September 10, 2008 1 comment

Problem:

When running patch 3262159, the following message appears:

ATTENTION: All workers either have failed or are waiting:
FAILED: file FNDLIBR      on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Checked adwork001.log:
/u0/oracle/prodappl/fnd/11.5.0/bin/FNDLIBR FND FNDCPBWV &ui_apps SYSADMIN 'System Administrator' SYSADMIN
List of errors encountered:
.......................................................................
_ 1 _
Please enter a valid responsibility.  The responsibility System
Administrator does not exist or is not active.  Check that the correct
application short name is specified for your responsibility.
(ROUTINE=AFPSSC)
.......................................................................
AD Worker error:
The above program failed with error code 1.
See the AD Worker log file and/or the program log file for details.

Solution:

In adctrl, used option 8 to skip the worker. Needed to disable, then enable maintenance mode. Then sourced the environment and ran:

/u0/oracle/prodappl/fnd/11.5.0/bin/FNDLIBR FND FNDCPBWV apps/apps SYSADMIN ‘System Administrator’ SYSADMIN

Reference:

Note 259319.1 – Adpatch Fails With Sysadmin Does Not Exist Or Not Active