cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Oracle Help

BenLoosli
23-Emerald II

Oracle Help

I am working through the UpgradeManager for a 9.1m060 to 10.0m040 upgrade and the Verify Pre Condition check failed. I am not an Oracle expert and we do not have one at this site.


Can someone help me with the commands I need to look at and correct these errors?


Logged Messages:
1. Primary Key Index PK_AUTHORIZATIONAGREEMENT does not exist.
2. Primary Key Constraint PK_AUTHORIZATIONAGREEMENT does not exist.
3. Primary Key Index PK_NAVFILTERDESIGNATIONLINK does not exist.
4. Primary Key Constraint PK_NAVFILTERDESIGNATIONLINK does not exist.
5. Primary Key Index PK_DESIGNATIONGROUP does not exist.
6. Primary Key Constraint PK_DESIGNATIONGROUP does not exist.
7. Primary Key Index Verification Failed :-
8. For any missing primary key index or primary key constraints, follow the steps below for each table reported in the log:- 1) Examine existing constraints on the table and check if there exists any other constraint on the primary key column for that table. 2) If no constraint exists on the primary key column, create the primary key constraint. See example shown below. 3) If a constraint exists on the primary key column, drop the existing constraint and recreate it with the correct name as reported in the log message. For example, If a primary key constraint, PK_WTDocument, is missing on WTDocument, following statement could be used to create it:- ALTER TABLE WTDocument ADD CONSTRAINT PK_WTDocument PRIMARY KEY (idA2A2) USING INDEX; If Primary key constraint exists but Primary key index is missing, create the index as below:- CREATE UNIQUE INDEX PK_WTDocument ON WTDocument(idA2A2); To see the existing constraints on a table, run the following query:- SELECT CONSTRAINT_NAME, INDEX_NAME from USER_CONSTRAINTS where TABLE_NAME='WTDOCUMENT';


1 REPLY 1

Hi Ben,

You need to log into Oracle using Windchill user credentials and then run the following lines:

Here is how to login (you type everyting in a command prompt on DB server)
sqlplus pdmlink/pdmlinkpassword@wind
Here are commands:
CREATE UNIQUE INDEX PK_AUTHORIZATIONAGREEMENT ON AUTHORIZATIONAGREEMENT(idA2A2);
CREATE UNIQUE INDEX PK_NAVFILTERDESIGNATIONLINK ON NAVFILTERDESIGNATIONLINK (idA2A2);
CREATE UNIQUE INDEX PK_DESIGNATIONGROUP ON DESIGNATIONGROUP (idA2A2);
ALTER TABLE AUTHORIZATIONAGREEMENT ADD CONSTRAINT PK_AUTHORIZATIONAGREEMENT PRIMARY KEY (idA2A2) USING INDEX PK_AUTHORIZATIONAGREEMENT;
ALTER TABLE NAVFILTERDESIGNATIONLINK ADD CONSTRAINT PK_NAVFILTERDESIGNATIONLINK PRIMARY KEY (idA2A2) USING INDEX PK_NAVFILTERDESIGNATIONLINK;
ALTER TABLE DESIGNATIONGROUP ADD CONSTRAINT PK_DESIGNATIONGROUP PRIMARY KEY (idA2A2) USING INDEX PK_DESIGNATIONGROUP;
exit;

Best regards,
[cid:image003.jpg@01CE42B2.01D3E940]

Igor Varshavsky
Senior Application Specialist
Top Tags