TimesTen Aggregate Script Generated By Exalytics OBIEE 11g Summary Advisor Fails With Error:"TT2231: New index index_name would be identical to existing index index_name" (Doc ID 1477739.1)

Last updated on NOVEMBER 17, 2014

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 and later
Oracle Exalytics Software - Version 1.0.0.0.0 and later
Information in this document applies to any platform.
Currency check on 17-NOV-2014.

Symptoms

When using Oracle Exalytics Version 1.0.0.0.0 and using Oracle Business Intelligence (OBI) Summary Advisor, an aggregate creation script is generated successfully.
While running this script via nqcmd, to create the recommended aggregates in TimesTen, it fails when issuing below query:

[OracleBIServerComponent] [TRACE:3] [USER-18] [] [ecid: 004kjlfkoCH3V8YFLrBT8A0000SH0008U0] [tid: 4817c940] [requestid: dfc000b] [sessionid: dfc0000] [username: biadmin]
----- Sending query to database named tt_newco (id: ExecutePhysical Gateway), connection pool named tt_newco, logical request hash f1033a90, physical request hash dcb48a16: [[
CREATE INDEX SA_Cla0005652D_N3 ON
   SA_Claim_C000559A9 ( Claim_Clos0005590D )
]]

The error message in the NQQuery.log:

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004kQjfweEs3V8YFLrBT8A00049Q0004t2] [tid: 428c5940] [nQSError: 16015] SQL statement execution failed.
[[
[nQSError: 16001] ODBC error state: S1000 code: 2231 message:
[TimesTen][TimesTen 11.2.2.2.0 ODBC Driver][TimesTen]TT2231: New index SA_CLA0005652D_N3 would be identical to existing index SA_CLA0005652D_N1
-- file "index.c", lineno 10496, procedure "sbIxRCheckPushErrOrWarn()".
]]
[OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004kQjfweEs3V8YFLrBT8A00049Q0004t2] [tid: 48521940] [nQSError: 43119] Query Failed:
[OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004kQjfweEs3V8YFLrBT8A00049Q0004t2] [tid: 48521940] Error while processing internal ODBC request: Prepare query failed

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