Portal 11g Upgrade Failing on Post 11G SVU CHECKS (Doc ID 1096881.1)

Last updated on MARCH 08, 2017

Applies to:

Portal - Version 10.1.4.0 to 11.1.1.3.0 [Release 10gR2 to FMW11g]
Information in this document applies to any platform.

Symptoms

Portal 11g upgrade is failing in the Post Upgrade steps when the svu is ran in report mode. The errors from the upgrade.log are:

### Show errors and warnings
Step started at Tue Jan 19 14:03:58 2010

### ERROR: WWU-01013: Upgrade terminated with the following errors:
### 10173 : ERROR at line 1:
### 10174 : ORA-20000:
### 10175 : ORA-06512: at "PORTAL.WWPOF", line 440
### 10176 : ORA-06512: at line 43
### 10177 : ORA-06510: PL/SQL: unhandled user-defined exception
### 10543 : # ERROR: Data inconsistencies after running the upgrade
### 10544 : # ERROR: User-Defined Exception
### 10552 : ### ERROR: Exception Executing
upg/common/postchk/../../frwk/svurun.sql REPORT POSTCHK for Subscriber: 1




Inside the log we see the real failures as being:

# Run the report mode of the schema validation utility
#---- Beginning inner script: wwutl_schema_validation.validate_all
# Schema Validation Utility Version = 11.1.1.2.1
# Running the validation in report mode
.
.
# Validate document info for existing documents
# . Inconsistency: Number of document info records for non-existing documents = 1
.
.
# Validate the pending items in approval table
# . Inconsistency: Number of pending items with invalid status in
wwbsr_item_approval$ table = 21
.
.
# Validate if text entries are associated with existing text items
# . Inconsistency: Number of text entries that are associated with
non-existing text items = 7
.
.
# . Getting the group profile records outside the group install base
that do not conform to the naming convention
# . Inconsistency: Inconsistency: Number of Group profile records that
are outside the group install base and do not conform to the naming
convention = 72
# ERROR: Data inconsistencies after running the upgrade
# ERROR: User-Defined Exception
# ----- PL/SQL Call Stack -----
object line object
handle number name
0x42c4f3bc 434 package body PORTAL.WWPOF
0x3452ea7c 43 anonymous block

 


Another possible inconsistency seen inside the log can be:

Validate if pages have base customization entries 
Inconsistency: Number of pages that do not have base customization  entries = 1

 

 

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