This discussion is archived
2 Replies Latest reply: Oct 24, 2012 9:47 PM by siakhooi-2029222 RSS

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

siakhooi-2029222 Newbie
Currently Being Moderated
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?

Legend

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