My Oracle Support Banner

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 FEBRUARY 04, 2022

Applies to:

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


When using Oracle Exalytics Version 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: [[
   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 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




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

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