DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, September 10, 2015

Issues handled while upgrading EBS R12.1.1 to R12.1.3

Error No : 1

Upgrade Patch 9239090 Fails Running in Some AR xdf Files

ATTENTION: All workers either have failed or are waiting:FAILED: file AR_CREATE_RECEIPTS_GT.xdf on worker 1.
FAILED: file ar_crh_app_gt.xdf on worker 6.
FAILED: file ar_line_app_detail_gt.xdf on worker 8.
FAILED: file HZ_EBI_CUST_LOAD_LOG.xdf on worker 10.

The adworker log file will show an error message as mentioned below:

Reading language information from applUS.txt ...
Temporarily resetting CLASSPATH to:  "/d01/oracle/Vdoy/apps/apps_st/appl/ad/12.0.0/java/adjava.zip:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/d01/oracle/Vdoy/apps/apps_st/comn/java/lib/appsborg.zip:/d01/oracle/Vdoy/apps/tech_st/10.1.2/forms/java:/d01/oracle/Vdoy/apps/tech_st/10.1.2/forms/java/frmall.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.2/jlib/ewt3.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/d01/oracle/Vdoy/apps/apps_st/comn/java/classes"
  Calling /d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ... 
Exception in thread "main" java.sql.SQLException: Socket read timed out
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at oracle.apps.ad.worker.AdJavaWorker.getAppsConnection(AdJavaWorker.java:1041)
        at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:276)
Caused by: oracle.net.ns.NetException: Socket read timed out
        at oracle.net.ns.Packet.receive(Packet.java:320)
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
Variable CLASSPATH is incorrectly set.

Solution : 

1) Include $AU_TOP/java/appsborg2.zip in the CLASSPATH and retest.

2) vi /d01/oracle/Vdoy/inst/apps/Vdoy_vdoy/appl/admin/adovars_Vdoy_vdoy.env
    
   Add this in the CLASSPATH

[applmgr@vdoy log]$ env | grep CLASSPATH

PY_CLASSPATH=/d01/oracle/Vdoy/apps/apps_st/comn/java/classes:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/d01/oracle/Vdoy/apps/apps_st/comn/java/lib/appsborg2.zip:/d01/oracle/Vdoy/apps/apps_st/comn/java/classes
REPORTS_CLASSPATH=/d01/oracle/Vdoy/apps/tech_st/10.1.2/reports/jlib/rwbuilder.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.2/reports/jlib/rwrun.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.2/jlib/zrclient.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.2/j2ee/home/oc4j.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.2/j2ee/home/lib/ojsp.jar
AF_CLASSPATH=/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/d01/oracle/Vdoy/apps/apps_st/comn/java/lib/appsborg2.zip:/d01/oracle/Vdoy/apps/apps_st/comn/java/classes
CLASSPATH=/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/d01/oracle/Vdoy/apps/apps_st/comn/java/lib/appsborg.zip:/d01/oracle/Vdoy/apps/tech_st/10.1.2/forms/java:/d01/oracle/Vdoy/apps/tech_st/10.1.2/forms/java/frmall.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.2/jlib/ewt3.jar:/d01/oracle/Vdoy/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/d01/oracle/Vdoy/apps/apps_st/comn/java/classes:/d01/oracle/Vdoy/apps/apps_st/appl/au/12.0.0/java/appsborg2.zip

3) The marked location was not available. Add the location and restart the patch.
4) stop the patch
5) Run the Application env.
6) Restart the patch(continue the patch)
7)  Hope the Solution will work.



ERROR No:2 ( This error will occur, if we are running the patch for the second time)

FAILED: file mth_pre_upgrade.sql on worker 15 for product mth username MTH.
sqlplus -s MTH/***** @/u01/app/oracle/EBS/apps/apps_st/appl/mth/12.0.0/patch/115/sql/mth_pre_upgrade.sql
Connected.
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 Apr 09 2012 00:28:06
"adwork002.log" 234201L, 8356714C         
Cause : As we have already started this patch. It created the table MTH_RESOURCES_D_TEMP. Hence we have to rename this as MTH_RESOURCES_D_TEMP_OLD.


SQL> conn mth/mth
Connected.
SQL> rename MTH_RESOURCES_D_TEMP to MTH_RESOURCES_D_TEMP_OLD;

Table renamed.

SQL> exit
1) Then, restart the worker using adctrl utility.

No comments: