Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Back Next

Resolving Metadata Validation Messages

After you run the validation tool, you might receive validation messages.

The following error messages are some of the most common validation messages.

Warning SIP-PV-10703 Package 'EMPLOYEE_DETAILS_PKG' is not synchronized with its database view.: To synchronize with the database view, run the Repair process from the Repository Manager.
View 'C_EMPLOYEE_DETAILS_MTIP' - SELECT privilege for proxy user role is not granted. or SIP-MV-11410- SQL of the root MTIP is incorrect.: Rebuild the MTIP views.
In the Hub Console, open the Configuration workbench and click
Enterprise Manager
.
Acquire a write lock.
Select the
ORS databases
tab.
Select the database.
Select the
Properties
tab.
Find the property called
MTIP regeneration required
, and click the
Regenerate MTIPs
button.
View 'EMPLOYEE_DETAILS_PKG' - SELECT privilege for proxy user role is not granted.: Update the proxy user role to include this privilege.
In the Hub Console, open the Security Access Manager workbench and click
Roles
.
Acquire a write lock.
Select the proxy user role.
Select the
Resource Privileges
tab.
Find the package or table that was named in the message.
Select the
Read
check box.
SIP-PV-11105 - SELECT privilege for proxy user role has not been granted for a view.
View 'C_REPOS_USER_GROUP_ALL' - SELECT privilege for proxy user role is not granted.: The database migration script created the proxy user role but did not grant privileges to the proxy user on the repository views. From the database, grant the proxy user SELECT privileges on the repository views.