Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Pre-Upgrade Tasks
  4. Database Tasks
  5. Application Server Tasks
  6. Hub Store Upgrade
  7. Hub Server Upgrade (In-place Upgrade)
  8. Process Server Upgrade (In-place Upgrade)
  9. Resource Kit Upgrade (In-place Upgrade)
  10. Post-Upgrade Tasks
  11. Search Configuration Upgrade
  12. ActiveVOS Post-Installation Tasks for the Application Server
  13. ActiveVOS Post-Upgrade Tasks for Business Entity Adapter
  14. ActiveVOS Post-Upgrade Tasks for Subject Areas Adapter
  15. Troubleshooting the Upgrade Process
  16. Frequently Asked Questions
  17. Processing Existing ActiveVOS Tasks
  18. Configuring Metadata Caching

Upgrading from Version 9.7.1

Upgrading from Version 9.7.1

Resolving Metadata Validation Messages

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.
  1. In the Hub Console, open the Configuration workbench and click
    Enterprise Manager
    .
  2. Acquire a write lock.
  3. Select the
    ORS databases
    tab.
  4. Select the database.
  5. Select the
    Properties
    tab.
  6. 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.
  1. In the Hub Console, open the Security Access Manager workbench and click
    Roles
    .
  2. Acquire a write lock.
  3. Select the proxy user role.
  4. Select the
    Resource Privileges
    tab.
  5. Find the package or table that was named in the message.
  6. 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.

0 COMMENTS

We’d like to hear from you!