Happy and Prosperous New Year 2010!!!
Today I need to discuss an issue while planning to upgrade my 12.1.1 instance to 12.1.2 using the patch 7303033 released recently by Oracle.
While updating the snapshot information through adadmin, i got the error as follows:
AD Administration error:
adusnapUpdateGlobalView(): Error while executing statement
AD Administration error:
ORA-00001: unique constraint (APPLSYS.AD_SNAPSHOT_FILES_U2) violated
ORA-06512: at "APPS.AD_FILE_UTIL", line 2535
ORA-06512: at line 3
AD Administration error:
adusnapStoreInDB(): Error calling adusnapUpdateGlobalView()
Failed to store APPL_TOP Snapshot to tables
adusnapMaintainSnapshot() : Error calling adusnapUpdateCurrentView2()
Error calling adusnapPartialCurVw()
Error calling adusnapMaintainSnapshot
Fix:
use the sql as below as apps user:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select distinct(snapshot_id) from ad_snapshot_files;
SNAPSHOT_ID
-----------
129
128
132
-130
130
131
6 rows selected.
SQL>
Note, the negative number -130, we need to delete the entry and retry with adadmin
SQL> delete from ad_snapshot_files where snapshot_id=-130;
84196 rows deleted.
SQL>
Rerun adadmin, it should continue normally.
Cheers!!!
Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.
You are encouraged to leave a comment.
You are encouraged to leave a comment.
Saturday, January 02, 2010
ORA-00001: unique constraint (APPLSYS.AD_SNAPSHOT_FILES_U2) violated in R12 (12.1.1)
Subscribe to:
Post Comments (Atom)
Let us be Friends...
Popular Posts
-
This blog describes the process of re-creating an existing Applications Release 12 database instance using the export and import utilities....
-
Secure Sockets Layer (SSL) SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data inte...
-
1. Installation of the Demantra Base Application or Patches Create a C:/Tmp folder on the machine where the setup.exe will be executed pri...
-
Symptom: A MultiException has 6 exceptions. They are: 1. java.lang.AssertionError: Cannot export non clusterable object with jndiName:weblo...
-
This blog speaks about the Login Page Issue on R12.1.1 instance. Suddenly the login page was throwing an error - 404 /OA_HTML/AppsLogin was ...
-
Memory Tuning The total available memory on a system should be configured in such a manner, that all components of the system functio...
-
We will be unable to login using none of the seeded users nor custom users. Applications will not allow any user to be logged in. For a VISI...
-
Today, i need to blog out the configuration of SSL in R12 Environment. The process and steps are as follows. It contains both Middle Tier an...
-
For Installation of the OBIEE please follow my previous post http://balajiabhi.blogspot.com/2009/07/installation-and-configuration-of-obiee....
-
In This blog I discuss some points of post clone activities of Oracle Applications. We need to update certain fields of certain tables after...
No comments:
Post a Comment