Troubleshooting
Problem
This technote explains why the error, Required primary key(s) are missing from the database, occurs when validating an IBM® Rational® RequisitePro® (ReqPro) database.
Symptom
The full error message is as follows:
Schema Validation
Required primary key(s) are missing from the database.
- Repair the database before creating a new project, or
- Select another database
Cause
The database schema was not created successfully and there are required primary keys missing from the database.
Resolving The Problem
Login to the schema as the schema owner in sql plus to identify this information.
Verify the keys are missing by running the following SQL statement below:
SELECT
A.TABLE_NAME table_name,
A.CONSTRAINT_NAME key_name,
B.TABLE_NAME referencing_table,
B.CONSTRAINT_NAME primary_key_name,
B.STATUS pk_status
FROM USER_CONSTRAINTS A, USER_CONSTRAINTS B
WHERE
A.CONSTRAINT_NAME = B.R_CONSTRAINT_NAME and
B.CONSTRAINT_TYPE = 'R'
ORDER BY 1, 2, 3, 4
/
There should be 65 rows returned.
If there are no keys or missing keys, rerun the schema creation scripts.
If you are certain that the rest of the scripts completed successfully, you can rerun only the primary.sql which creates the keys.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21296045