OIM Schema Upgrade Patch Set Assistant Hangs at 93 Percent Completion (Doc ID 1988593.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Identity Manager - Version 11.1.2.0.0 to 11.1.2.3.0 [Release 11g]
Identity Manager - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

During the Patch Set Assistant execution for the OIM Schema upgrade, the installer stops processing at 93%.

There are no obvious errors in the upgrade logs (at $MW_HOME/oracle_common/upgrade/logs/psa/psatimestamp.log) and the last entries in the log are for  oim_mview_recon_changes_by_res.sql.

The screen shows that Oracle FM Patch Set Assistant UI is at Step 12 of 13
The Status bar shows 93% complete.
Title shows OIM INSTALLING UPGRADE STORED PROCEDURES.
User Messaging, OPSS, MDS and SOA shows status Succeeded
OIM shows status as In Progress.

Note: During OIM upgrade, Materialized view 'OIM_RECON_CHANGES_BY_RES_MV' is created as part script 'oim_mview_recon_changes_by_res.sql' execution. This Materialized View is used to populate data for OIM Exception report 'Fine Grained Entitlement Exceptions By Resource' only.

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