2 Replies Latest reply: Oct 24, 2012 11:47 PM by siakhooi-2029222 RSS

    fail to install E-Business Suite Diagnostics Installation Guide ID 167000.1

    siakhooi-2029222
      I am following E-Business Suite Diagnostics Installation Guide [ID 167000.1] for the installation.
      Firstly, i have successfully adsplice Patch 3636980.

      then i try on Patch 7530017 and i hit this error during adpatch:
      ----
      About to update the current-view snapshot: Wed Oct 24 2012 18:27:43

      Updating the current-view snapshot...
      ORA-01403: no data found
      ORA-06512: at "APPS.AD_FILE_SYS_SNAPSHOTS_PKG", line 2095
      ORA-06512: at line 2

      AutoPatch error:
      Error while executing statement (curr-vw updt)
      Error calling adphistUpdtCurrVwSnapshot(1).
      Error calling adphistStoreCurPatchHistInDB2

      AutoPatch error:
      Unable to save Patch History information to Database
      ----
      Then according to note [ID 468940.1], i need to run the Update current view snapshot, and i hit this error:
      ----
      File "atg_supp_patches.sql"
      Either has No Version or Unknown error(-4)

      Failed in adusnapGetDetailFileInfo()
      AD Administration error:
      Failed store Snapshot file info
      adusnapMaintainSnapshot() : Error calling adusnapUpdateCurrentView()
      Error calling adusnapMaintainSnapshot
      ----

      Checking from knowledge base, i should follow ID 372491.1 to solve the problem, but i can't figure out which record to follow.
      AD_APPL_TOPS
      ----
      appl_top_id,name,server_type_admin_flag,server_type_forms_flag,server_type_node_flag,server_type_web_flag,applications_system_name,appl_top_type,active_flag
      1,tafnw1,Y,Y,Y,Y,prod,R,Y
      43,*PRESEEDED*,,,,,*PRESEEDED*,S,Y
      68,digidb2,Y,N,Y,N,EES06A,R,Y
      69,GLOBAL,,,,,EES06A,G,Y
      21,crmees06,Y,Y,Y,Y,DEV,R,Y
      41,isupplier,N,N,N,Y,DEV,R,Y
      42,t_f_w1,,Y,,Y,DEV,R,Y
      88,AT_ofsdevdb,Y,Y,Y,Y,DEV,R,Y
      45,digiapps1,N,Y,N,Y,DEV,R,Y
      65,GLOBAL,,,,,DEV,G,Y
      66,digiapps1,N,Y,N,Y,EES06A,R,Y


      AD_SNAPSHOTS
      ----
      snapshot_id,release_id,appl_top_id,snapshot_name,snapshot_type,comments,ran_snapshot_flag
      1,21,43,*PRESEEDED*11.5.5,B,Preseeded,Y
      8,41,68,CURRENT_VIEW,C,Current View,N
      9,41,69,GLOBAL_VIEW,G,Created from Current View Snapshots,N
      2,21,88,CURRENT_VIEW,C,Current View,Y
      3,61,45,CURRENT_VIEW,C,Current View,Y
      4,61,41,CURRENT_VIEW,C,MERGING_APPL_TOPS_DONE,Y
      5,21,41,PROD,S, ,Y
      6,21,65,GLOBAL_VIEW,G,Created from Current View Snapshots,Y
      7,21,41,BACKUP_SNAPSHOT_4,S, ,Y

      (sorry, not sure how to post the table nicely)

      what should i do next?