Portal 10.1.4.2 To 11.1.1.6 Upgrade Fails On SVU Inconsistencies In Post Upgrade SVU Execution (Doc ID 1509709.1)

Last updated on MAY 17, 2017

Applies to:

Portal - Version 10.1.4.2 and later
Information in this document applies to any platform.
Checked for relevance on 21-Aug-2015

Symptoms

When upgrading from Oracle Portal 10.1.4.2 to 11.1.1.6 the Metadata Repository upgrade fails due to Inconsistencies Reported in the Post Upgrade SVU:

# Validate if style background image exists in the document table
# . Inconsistency: Number of style background images that no longer exist in the document table =

...

#---- Ending inner script: wwutl_schema_validation.validate_all, 7.27 seconds
# Handling exception
# ERROR: Data inconsistencies after running the upgrade
# ERROR: User-Defined Exception
# ----- PL/SQL Call Stack -----
  object line object
  handle number name
700000070ceedd8 434 package body PORTAL.WWPOF
70000007e1275a0 43 anonymous block

###
### ERROR: Exception Executing upg/common/postchk/../../frwk/svurun.sql REPORT POSTCHK for Subscriber: 1
###

The Pre SVU executed during the upgrade shows the following inconsistencies reported.

# Validate if the documents in wwdoc_document$ table have corresponding entries in wwv_things and in wwv_docinfo tables
# . Inconsistency: Number of documents in wwdoc_document$ table which do not have corresponding entries in wwv_things and in wwv_docinfo tables = 35
# . Delete from the document and WebDAV tables
# .. Number of rows deleted from wwv_docinfo table = 0
# .. Number of rows deleted from wwdoc_document$ table = 35
# .. Number of rows deleted from WebDAV table = 0

...

# . Inconsistency: Number of security ACLs that need to be deleted = 65
# .. Number of rows deleted = 65

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms