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:

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

Changes

Cause

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