Sparsity Advisor Fails With ORA-01405 Error (Doc ID 959488.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle OLAP - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.
Checked for relevance on 05-Aug-2011.

Symptoms

Sparsity Advisor fails with the following error:

ORA-01405: fetched column value is NULL
ORA-06512: at "SYS.DBMS_AW", line 372
ORA-06512: at "SYS.DBMS_AW", line 400
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
.....

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