Aggregate Build On Exalytics HA Clustered Environment Does Not Complete (Doc ID 1609819.1)

Last updated on DECEMBER 20, 2013

Applies to:

Oracle Exalytics Software - Version 1.0.0.1.0 to 1.0.0.3.0 [Release 1.0]
Oracle TimesTen In-Memory Database - Version 11.2.2.3.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.6.10 [Release 11g]
Information in this document applies to any platform.

Symptoms

An Oracle Business Intelligence Enterprise Edition (OBIEE) 11g aggregate build against a TimesTen High Availability (HA) cluster on Exalytics fails to complete.

You may see the following errors in the NQQuery log:

[nQSError: 10058] A general error has occurred.
Statement preparation failed

Query Status: [nQSError: 16011] ODBC error occurred while executing SQLExtendedFetch to retrieve the results of a SQL statement. [[
[nQSError: 16001] ODBC error state: S1T00 code: 6111 message: [TimesTen][TimesTen 11.2.2.4.1 ODBC Driver][TimesTen]TT6111: SQL statement has reached its timeout limit and has been terminated -- file "tindex.c", lineno 4280, procedure "sbTixNext()".
[nQSError: 43119] Query Failed:

Query Status: [nQSError: 17012] Bulk fetch failed. [[
[nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation
at OCI call OCIStmtFetch.
[nQSError: 43119] 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