My Oracle Support Banner

OAS: BIPLATFORM Schema Creation Fails during OAS Installation/Upgrade (Doc ID 2668172.1)

Last updated on MAY 13, 2020

Applies to:

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

Symptoms

When running the RCU to create schemas during the installation of OAS (or upgrade), 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.