My Oracle Support Banner

BIPLATFORM Schema Creation Fails during Installation/Upgrade of Oracle Analytics Server (OAS) 5.5 (Doc ID 2668172.1)

Last updated on OCTOBER 21, 2021

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

When running the Repository Creation Utility (RCU) to create schemas during the installation or upgrade of Oracle Analytics Server (OAS), the BIPLATFORM schema creation failed.

biplatform_plugin-<timestamp>.log (/tmp/RCU<timestamp>_xxxx/logs/) shows below error.

oracle.bi.search.dbstorage.scripting.oracle.SQLPlusScriptRunner executeScript

WARNING: Failing command: ALTER TABLE S_NQ_SEARCH_WEBCAT_EVENTS MODIFY EVENT_ID VARCHAR2(256) DEFAULT webcat_events_seq.NEXTVAL

<Timestamp> oracle.bi.search.schema.plugin.BISearchSchemaPlugin update

WARNING: Could not install or upgrade BISEARCH database schema

java.sql.SQLException: Error running SQL commands in script /RCU/oracle/search/createtables-bisearch.sql

Caused by: java.sql.SQLSyntaxErrorException: ORA-02262: ORA-406 occurs while type-checking column default value expression

Caused by: Error : 2262, Position : 45, Sql = ALTER TABLE S_NQ_SEARCH_WEBCAT_EVENTS MODIFY EVENT_ID VARCHAR2(256) DEFAULT webcat_events_seq.NEXTVAL, OriginalSql = ALTER TABLE S_NQ_SEARCH_WEBCAT_EVENTS MODIFY EVENT_ID VARCHAR2(256) DEFAULT webcat_events_seq.NEXTVAL, Error Msg = ORA-02262: ORA-406 occurs while type-checking column default value expression

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)

... 34 more

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.