"The input line is too long" When RCU is Creating Portal And Portlet Repository Schemas (Doc ID 1316803.1)

Last updated on DECEMBER 23, 2016

Applies to:

Portal - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
Checked for relevance on 14-Apr-2015

Symptoms

Attempting to install Portal schema with RCU and receive the following errors:

RCU.log shows:

2011-04-20 11:50:41.585 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-00604: error occurred at recursive SQL level 1
ORA-02429: cannot drop index used for enforcement of unique/primary key Statement:CREATE SEQUENCE lsid

Portal.log shows:

INSTALL_ERROR: sqlExecuter() : Raised Exception oracle.webdb.config.PortalWiringException: Generated errors of type ORA-, PLS-, SP2-, ERROR: or IMP-. Refer to the log file for details.

ERROR: Installing Seed Data raised exception.
Executing SQL statement: drop tablespace TST_PORTAL including contents and datafiles
JDBC SQLException - ErrorCode: 2449SQLState:72000 Message: ORA-02449: unique/primary keys in table referenced by foreign keys

JDBC SQLException handled by error handler


Executing SQL statement: drop tablespace TST_IAS_TEMP including contents and datafiles
Executing SQL statement: drop tablespace TST_PORTAL_DOC including contents and datafiles
JDBC SQLException - ErrorCode: 2449SQLState:72000 Message: ORA-02449: unique/primary keys in table referenced by foreign keys

JDBC SQLException handled by error handler


Executing SQL statement: drop tablespace TST_PORTAL_LOG including contents and datafiles
Executing SQL statement: drop tablespace TST_PORTAL_IDX including contents and datafiles
JDBC SQLException - ErrorCode: 604SQLState:60000 Message: ORA-00604: error occurred at recursive SQL level 1
ORA-02429: cannot drop index used for enforcement of unique/primary key

If the portal.log is scanned more, the following error is seen:

OracleFusionMiddleware\BusinessIntelligence\OBIEE_RCU(11.1.1.3.3)\ofm_rcu_win32_11.1.1.3.3_disk1_1of1\rcuHome
The input line is too long.
The syntax of the command is incorrect.

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