Repository Creation Utilty (RCU) Fails Loading Portal Schemas with "Error creating PL/SQL Object WWWCP_API_REGISTRY:PACKAGE BODY" (Doc ID 1940136.1)

Last updated on JANUARY 17, 2017

Applies to:

Oracle Fusion Middleware - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.8.0 version, Install - Classic

When attempting to run RCU 11.1.1.8.0 against a 12.1.0.2.1, the create schema fails for PORTLET schema with the following errors in the rcu log:

ERROR
-----------------------

2014-10-28 23:02:26.134 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: Error creating PL/SQL Object WWWCP_API_REGISTRY:PACKAGE BODY

2014-10-28 23:02:33.612 ERROR rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::executeNextSQLStatement: Error encountered executing SQL statement FileName: '/opt/rcuHome/rcu/integration/portlet/sql/oracle/wcpreg.plb' LineNumber: '5440' Script log file: /tmp/logdir.2014-10-28_22-59/portlet.log
2014-10-28 23:02:33.613 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::cleanAndLog: RCU-6134:Error while trying to execute JDBC action. - PORTLET
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@268dc2d
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@324f0f97
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@64889c4e
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@44cdf872

at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1414)
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:402)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:245)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
at java.lang.Thread.run(Thread.java:662)

2014-10-28 23:02:33.620 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6134:Error while trying to execute JDBC action.
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:302)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6134:Error while trying to execute JDBC action.
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:424)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:245)
... 2 more
Caused by: oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@268dc2d
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@324f0f97
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@64889c4e
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@44cdf872

at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1414)
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:402)
... 3 more

 

The portal log also shows:

DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@268dc2d
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@324f0f97
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@64889c4e
DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@44cdf872

2014-10-28 23:03:18.093 rcu:Executing SQL statement: DROP USER DEVELOP_PORTLET CASCADE
2014-10-28 23:03:22.571 rcu:Executing SQL statement: drop tablespace DEVELOP_IAS_PORTLET including contents and datafiles

  

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