This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Aug 2, 2013 3:24 AM by user12204755 RSS

Upgrade R12.1.1 to R12.1.3 disconnects with no errors

user12204755 Newbie
Currently Being Moderated


We are on 11.2.0.3 database on HP-UX

Apps have just been upgraded from 11.5.10.2 to R12.1.1 ok

 

We have applied 9239089 and are now applying 9239090.

 

The patch 9239090 (12.1.3)  runs for about 2 hours successfully, but then disconnects for no apparent reason.

  No errors in worker files, patch log files, db alert log files and syslog files, it just stops, doesnt update ad_bugs or have any of the messages indicating it has completed.

 

It always seems to bomb at the same point, here are the last few lines of the logfile:

STOP_TASK: [Compile invalid objects in DB] [] [Wed Jul 10 2013 15:26:28]
STRT_TASK: [Get final list of invalid objects in DB] [] [Wed Jul 10 2013 15:26:28]
Number of invalid objects: 107
Getting list of invalid objects in APPS schema.

Has anyone seen this before?  We have a SR open, but they havent been much help so far.  We have run utlrp mutliple times the invalids stay the same.

 

Anyone encountered this or have any suggestions on how to diagnose?

 

Thanks

  • 1. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    What is the status of the workers, are they running any jobs?


    Does it hang when you try to get the list of invalid objects using sqlplus?


    Is the information of the patch you are applying stored in AD_BUGS table?


    What is your SR#?


    How to Troubleshoot The "adpatch" Performance Issues: Slow, Hanging or Crashes [ID 756063.1]

    Compiling Apps Schema Through Adadmin ih Hanging [ID 1524645.1]


    Thanks,

    Hussein

  • 2. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    user12204755 Newbie
    Currently Being Moderated

    What is the status of the workers, are they running any jobs?
    >>>no workers are running

     

    Does it hang when you try to get the list of invalid objects using sqlplus?
    >>>no I can get the list in sqlplus and utlrp runs fine

     

    Is the information of the patch you are applying stored in AD_BUGS table?
    >>> ad_bugs does not have a record for 9239090 in

     

    What is your SR#?
    >> 3-7495457701

     


    How to Troubleshoot The "adpatch" Performance Issues: Slow, Hanging or Crashes [ID 756063.1]

    Compiling Apps Schema Through Adadmin ih Hanging [ID 1524645.1]

    Thanks


    Thanks,

    Hussein

  • 3. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    user12204755 Newbie
    Currently Being Moderated

    We also get:  No "&phase=" found for EXEC command: Defaulting to "&phase=last".  ealry on in the adpatch log:

     

    STRT_TASK: [Parse and load patch driver file] [] [Mon Jul 08 2013 17:01:45]


    Connecting to APPS......Connected successfully.

      Parsing and loading patch driver file...
        Processing line   10000.
        Processing line   20000.
        Processing line   30000.
        Processing line   40000.
        Processing line   50000.
        Processing line   60000.
        Processing line   70000.
        Processing line   80000.
        Processing line   90000.
        Processing line  100000.
        Processing line  110000.
        Processing line  120000.
        Processing line  130000.
        Processing line  140000.
        Processing line  150000.
        Processing line  160000.
        Processing line  170000.
        Processing line  180000.
        Processing line  190000.
        Processing line  200000.
        Processing line  210000.
        Processing line  220000.
        Processing line  230000.
        Processing line  240000.
        Processing line  250000.
        Processing line  260000.
        Processing line  270000.
        Processing line  280000.

    AutoPatch warning:
    adprdf(): At line 288506 in file u9239090.drv:
    No "&phase=" found for EXEC command: Defaulting to "&phase=last".
        Processing line  290000.
        Processing line  300000.
        Processing line  310000.
         314372 lines processed.

     

    Is this related to our patch finishing but not completing properly?

  • 4. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    adprdf(): At line 288506 in file u9239090.drv:

     

    What is line 288506 in file u9239090.drv?

     

    Thanks,

    Hussein

  • 5. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    user12204755 Newbie
    Currently Being Moderated

    288505       # file-version-parsed ar patch/115/publisher/templates/US ARSEPADNT.rtf 120.0.12010000.2

    288506       exec java oracle/apps/xdo/ UPLOAD -DB_USERNAME &un_apps -DB_PASSWORD &pw_apps -JDBC_CONNECTION &jdbc_db_addr -LOB_TYPE TE -APPS_SHORT_NAME

             AR -LOB_CODE ARSEPADNT -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF -TRANSLATE Y -FILE_NAME &fullpath:ar:patch/115/publisher/templates/US:ARSE

            PADNT.rtf

    288507

    then it just show a load of noexecs:

     

    288508       #

    288509       # Phase NOEXEC - These files are intentionally not executed.

    288510       #

    288511

    288512       # file-version-parsed ad admin/template adapperms.sh 120.0.12010000.1

    288513       # noexec ad admin/template adapperms.sh

    288514

    ...  all the way up to line:

    311875

    311876       # file-version-parsed zx patch/115/sql zxpotrxhotupd.sql 120.9.12010000.5

    311877       # noexec zx patch/115/sql zxpotrxhotupd.sql

    311878

    311879       #========================================#

    311880       # Actions for Generating Dependent Files #

    311881       #========================================#

    311882

     

    I have got ARSEPADNT.rtf from the patch dir - can I upload it here?  also I found a similar bug with an rtf file - metalink note 556866.1

     

    Thanks very much

  • 6. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    You can safely ignore this warning and continue with the patch.

     

    What's the status of the main issue you have? Have you managed to fix it?

     

    Thanks,

    Hussein

  • 7. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    user12204755 Newbie
    Currently Being Moderated

    Thanks Hussein.

     

    What happens is the patch just stops.  No processes running, no errors in the patch log or workers.  If I try to run the patch again it prompts us with:

    "Your previous AutoPatch session did not run to completion.

    Do you wish to continue with your previous AutoPatch session [Yes] ?"

     

    It has written about 13000 lines in the patch log

     

    I will post the last few lines:

     

     

    perl -x /ybs/u001/sw/dba/oracle/product/R12apps/r12patch/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/ojspCompile.pl --compile --quiet
    logfile set: /ybs/u001/sw/dba/oracle/product/R12apps/r12patch/inst/apps/r12patch_ybsxlx32/logs/appl/rgf/ojsp/ojspc_error.log
    starting...(compiling delta)
    using 10i internal ojsp ver: 10
    synchronizing dependency file:
      loading deplist...8095
      enumerating jsps...8095
      updating dependency...0
    initializing compilation:
      eliminating children...6024 (-2071)
      searching uncompiled...0
    No compilations needed.


    Done compiling JSP files.


    STOP_TASK: [Compile JSP files] [] [Mon Jul 08 2013 17:20:40]

     

    STOP_TASK: [Copy portion steps] [] [Mon Jul 08 2013 17:20:40]

     

    STRT_TASK: [Database portion steps] [] [Mon Jul 08 2013 17:20:40]

     

    STRT_TASK: [Get initial list of invalid objects in DB] [] [Mon Jul 08 2013 17:20:40]


    Number of invalid objects: 107

    Getting list of invalid objects in APPS schema.

  • 8. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    user12204755 Newbie
    Currently Being Moderated

    Here is the output from the screen - it looks like it is near the end - but just doesnt complete properly:

     

    There are now 9 jobs remaining (current phase=A2):
        0 running, 8 ready to run and 1 waiting.

    Assigned: file adinvrn2.pls on worker  1 for product ad  username APPLSYS.
    Assigned: file adinvrn2.pls on worker  2 for product ad  username APPLSYS.
    Assigned: file adinvrn2.pls on worker  3 for product ad  username APPLSYS.
    Assigned: file adinvrn2.pls on worker  4 for product ad  username APPLSYS.
    Assigned: file adinvrn2.pls on worker  5 for product ad  username APPLSYS.
    Assigned: file adinvrn2.pls on worker  6 for product ad  username APPLSYS.
    Assigned: file adinvrn2.pls on worker  7 for product ad  username APPLSYS.
    Assigned: file adinvrn2.pls on worker  8 for product ad  username APPLSYS.
    Completed: file adinvrn2.pls on worker  1 for product ad  username APPLSYS.
    Completed: file adinvrn2.pls on worker  2 for product ad  username APPLSYS.
    Completed: file adinvrn2.pls on worker  3 for product ad  username APPLSYS.
    Completed: file adinvrn2.pls on worker  5 for product ad  username APPLSYS.
    Completed: file adinvrn2.pls on worker  6 for product ad  username APPLSYS.
    Completed: file adinvrn2.pls on worker  4 for product ad  username APPLSYS.
    Completed: file adinvrn2.pls on worker  7 for product ad  username APPLSYS.
    Completed: file adinvrn2.pls on worker  8 for product ad  username APPLSYS.

    Starting phase 3 (A3): invoker+3


    There are now 1 jobs remaining (current phase=A3):
        0 running, 1 ready to run and 0 waiting.

    Assigned: file adinvcln.pls on worker  1 for product ad  username APPLSYS.
    Completed: file adinvcln.pls on worker  1 for product ad  username APPLSYS.

    Done with Invoker's Rights processing.


    Telling workers to quit...

    2 workers have quit.  Waiting for 6 more.

    All workers have quit.


    Dropping FND_INSTALL_PROCESSES table...


    FND_INSTALL_PROCESSES table dropped.


    Dropping AD_DEFERRED_JOBS table...


    AD_DEFERRED_JOBS table dropped.

      Updating the checkfile repository if necessary...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing a batch...
    Processing the last batch...
      Done updating the checkfile repository...

    Done running SQL scripts and EXEC commands.

    Compiling invalid objects...


    sqlplus -s APPS/***** @/ybs/u001/sw/dba/oracle/product/R12apps/r12patch/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS

    sqlplus -s APPS/***** @/ybs/u001/sw/dba/oracle/product/R12apps/r12patch/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS

    Number of invalid objects: 115

    Getting list of invalid objects in APPS schema.

     

    -----Thiis it no more output - it just stops!! ------

  • 9. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    user12204755 Newbie
    Currently Being Moderated

    HI Hussein,

     

    Have you seen anything like this before?  Is there anyway to identifiy which step it is failing on ?

     

    Thanks very much

  • 10. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    rrademak Explorer
    Currently Being Moderated

    Hi,

     

     

    Do you also have XLA Invalids? If it stuck at compiling an XLA invalid you can have issues like this.

     

    You can try the following:

     

     

     

    1 - First check if you have XLA invalids, If yes continue the next step

     

    2 - Exist the adpatch session and exit all workers

     

    3 - Bounce the Database.

     

    4 - sqlplus apps/apps

     

    SQL> alter session set plsql_optimize_level=1;

     

     

       Compile the XLA packages manually using command:

       alter package xla... compile;

     

     

    5 - Once compiled restart the Patch

     

    See also: R12 patch seems to hang in adobjcmp.sql or appostimportaad.sql or fapostimportaad.sql (Doc ID 748501.1)

     

    Ronald

  • 11. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Can you please provide the list of invalid objects under apps schema?

     

    Thanks,

    Hussein

  • 12. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    user12204755 Newbie
    Currently Being Moderated


    Hi,

     

    We dont have any XLA invalids.

     

    Thanks  Ronald

  • 13. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    We dont have any XLA invalids.

     

    Can you please provide the list of invalid objects under apps schema?

     

    Thanks,

    Hussein

  • 14. Re: Upgrade R12.1.1 to R12.1.3 disconnects with no errors
    user12204755 Newbie
    Currently Being Moderated

    AP_CCE_BANK_UPGRADE                                PACKAGE BODY

    ARBG_COLLECTION_CALLS                              VIEW

    ARBG_CUSTOMERS                                     VIEW

    ARBG_CUSTOMER_SITES                                VIEW

    ARBG_LOCATIONS                                     VIEW

    ARFG_AR_PAYMENT_SCHEDULES                          VIEW

    ARFG_CASH_RECEIPTS                                 VIEW

    ARFG_COLLECTION_CALLS                              VIEW

    ARFG_CUSTOMER_SITES                                VIEW

    ARFG_LOCATIONS                                     VIEW

    AR_FC_INVOICES_V                                   VIEW

    ASO_CC_ENCRYPT_CONC_REQ_PVT                        PACKAGE BODY

    AS_SALES_TEAM_V                                    VIEW

    CEBG_BANK_STATEMENTS                               VIEW

    CEBG_BANK_STATEMENT_LINES                          VIEW

    CEBG_CASH_FORECAST_CELLS                           VIEW

    CEFG_BANK_STATEMENTS                               VIEW

    CEFG_BANK_STATEMENT_LINES                          VIEW

    CEFG_CASH_FORECAST_CELLS                           VIEW

    CST_LAYER_ACTUAL_COST_DTLS_V                       VIEW

    FA_PROCESS_IMPAIRMENT_PKG                          PACKAGE BODY

    FA_SORP_IMPAIRMENT_PVT                             PACKAGE BODY

    FA_SORP_UPG_PKG                                    PACKAGE BODY

    FFP50296_01122012                                  PACKAGE BODY

    FFP50298_06042010                                  PACKAGE BODY

    FFP50300_06042009                                  PACKAGE BODY

    FFP50300_06042010                                  PACKAGE BODY

    FFP50300_06042011                                  PACKAGE BODY

    FFP50300_06042012                                  PACKAGE BODY

    FFP50302_06042010                                  PACKAGE BODY

    FFP50303_06042009                                  PACKAGE BODY

    FFP50303_06042010                                  PACKAGE BODY

    FFP50303_06042011                                  PACKAGE BODY

    FFP50303_06042012                                  PACKAGE BODY

    FFP52400_01010001                                  PACKAGE BODY

    FFP52402_01010001                                  PACKAGE BODY

    FFP52403_01010001                                  PACKAGE BODY

    FFP52468_01010001                                  PACKAGE BODY

    FFP52472_01010001                                  PACKAGE BODY

    FFP52474_01010001                                  PACKAGE BODY

    FFP52474_06042011                                  PACKAGE BODY

    FFP52503_06042012                                  PACKAGE BODY

    FFP52505_01010001                                  PACKAGE BODY

    FFP52506_06042012                                  PACKAGE BODY

    FFP52688_01010001                                  PACKAGE BODY

    FPA_AW_PCLASS_INV_MIX_V                            VIEW

    FPA_AW_PROJ_INV_RANK_MAPS_V                        VIEW

    FPA_AW_SCE_CONTEXT_V                               VIEW

    FPA_AW_SCE_EXCS_V                                  VIEW

    FPA_AW_SCE_SUM_CATS_V                              VIEW

    FPA_AW_SCE_SUM_PROJS_V                             VIEW

    FPA_AW_SCE_SUM_SCES_V                              VIEW

    FPA_MAIN_PROCESS_PVT                               PACKAGE BODY

    FPA_PLANNINGCYCLE_PVT                              PACKAGE BODY

    FPA_PORTFOLIO_PROJECT_SETS_PVT                     PACKAGE BODY

    FPA_PROJECT_PVT                                    PACKAGE BODY

    FPA_SCENARIO_PVT                                   PACKAGE BODY

    FPA_VALIDATION_PROCESS_PVT                         PACKAGE BODY

    GLBG_ACTUAL_BALANCES                               VIEW

    GLBG_ACTUAL_JOURNAL_BATCHES                        VIEW

    GLBG_ACTUAL_JOURNAL_ENTRIES                        VIEW

    GLBG_BUDGET_BALANCES                               VIEW

    GLBG_BUDGET_JOURNAL_BATCHES                        VIEW

    GLBG_BUDGET_JOURNAL_ENTRIES                        VIEW

    GLBG_ENCUMBRANCE_BALANCES                          VIEW

    GLBG_ENCUMB_JOURNAL_BATCHES                        VIEW

    GLBG_ENCUMB_JOURNAL_ENTRIES                        VIEW

    GLBG_GL_AVERAGE_BALANCES                           VIEW

    GLBG_GL_BUDGETS                                    VIEW

    GLBG_GL_BUDGET_ASSIGNMENTS                         VIEW

    GLBG_GL_BUDGET_ORGANIZATIONS                       VIEW

    GLBG_GL_STANDARD_BALANCES                          VIEW

    GLBG_JOURNAL_BATCHES                               VIEW

    GLBG_JOURNAL_ENTRIES                               VIEW

    GLBG_JOURNAL_LINES                                 VIEW

    GLFG_ACTUAL_BALANCES                               VIEW

    GLFG_ACTUAL_JOURNAL_BATCHES                        VIEW

    GLFG_ACTUAL_JOURNAL_ENTRIES                        VIEW

    GLFG_BUDGET_BALANCES                               VIEW

    GLFG_BUDGET_JOURNAL_BATCHES                        VIEW

    GLFG_BUDGET_JOURNAL_ENTRIES                        VIEW

    GLFG_ENCUMBRANCE_BALANCES                          VIEW

    GLFG_ENCUMB_JOURNAL_BATCHES                        VIEW

    GLFG_ENCUMB_JOURNAL_ENTRIES                        VIEW

    GLFG_GL_AVERAGE_BALANCES                           VIEW

    GLFG_GL_BUDGETS                                    VIEW

    GLFG_GL_BUDGET_ASSIGNMENTS                         VIEW

    GLFG_GL_BUDGET_ORGANIZATIONS                       VIEW

    GLFG_GL_STANDARD_BALANCES                          VIEW

    GLFG_JOURNAL_BATCHES                               VIEW

    GLFG_JOURNAL_ENTRIES                               VIEW

    GLFG_JOURNAL_LINES                                 VIEW

    HR_ASSIGNMENT_BK1                                  PACKAGE BODY

    HR_ASSIGNMENT_BK2                                  PACKAGE BODY

    HR_EMPLOYEE_BK1                                    PACKAGE BODY

    HR_PERSON_ADDRESS_BK3                              PACKAGE BODY

    HR_PERSON_BK1                                      PACKAGE BODY

    OKS_CCENCRYPTION_PKG                               PACKAGE BODY

    OTFG_ENROLLED_EVENTS                               VIEW

    OTFG_EXT_TRAINING_EVENT_ENROLS                     VIEW

    OTFG_FINANCE_HEADERS                               VIEW

    PAY_CA_RL1_AMEND_MAG                               PACKAGE BODY

    PAY_GB_HIST_ARCH_PKG                               PACKAGE BODY

    PAY_GB_PAYE_SYNC                                   PACKAGE BODY

    PAY_GB_REPORT_FUNCTION_PKG                         PACKAGE BODY

    PAY_GB_RTI_UPD                                     PACKAGE BODY

    PAY_IE_HIST_ARCH_PKG                               PACKAGE BODY

    PAY_IE_PAYFILE_SEPA                                PACKAGE

    PAY_IE_PAYFILE_SEPA                                PACKAGE BODY

    PAY_JP_DEF_REPORT_PKG                              PACKAGE

    PAY_JP_DEF_REPORT_PKG                              PACKAGE BODY

    PAY_JP_ITWB_ARCHIVE_PKG                            PACKAGE BODY

    PAY_JP_ITWB_REPORT_PKG                             PACKAGE BODY

    PAY_KR_YEA20090101_PKG                             PACKAGE BODY

    PAY_KR_YEA20100101_PKG                             PACKAGE BODY

    PAY_KR_YEA20110101_PKG                             PACKAGE BODY

    PAY_MX_SUBSIDY_EMP_PD_RPT                          PACKAGE BODY

    PAY_SA_HIST_ARCH_PKG                               PACKAGE BODY

    PERCONTACTRELATIONSHI_204I_DYT                     TRIGGER

    PERCONTACTRELATIONSHI_205U_DYT                     TRIGGER

    PER_SG_ORG_INFO_LEG_HOOK                           PACKAGE BODY

    PER_ZA_EE_DIFFERENTIAL_PKG                         PACKAGE BODY

    PER_ZA_EE_WORKFORCE_PROFILE                        PACKAGE BODY

    POBG_SUPPLIERS                                     VIEW

    POFG_SUPPLIERS                                     VIEW

    PSBBG_GL_ACCOUNT_HIERARCHIES                       VIEW

    PSBFG_GL_ACCOUNT_HIERARCHIES                       VIEW

    SSP_APAB_PKG                                       PACKAGE BODY

    SSP_APAD_PKG                                       PACKAGE BODY

    WMS_CARTNZN_PUB                                    PACKAGE BODY

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points