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 1.0.0.0.0 and laterBusiness Intelligence Suite Enterprise Edition - Version 11.1.1.6.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
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 |