TimesTen/Exalytics/OBIEE: Queries With Nested Left Outer Joins Consume All Temporary Space And Fail With TT802 Errors (Doc ID 1570587.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 and later
Oracle TimesTen In-Memory Database - Version 11.2.2.4.1 and later
Oracle Exalytics Software - Version 1.0.0.0.0 to 1.0.0.3.0 [Release 1.0]
Information in this document applies to any platform.
***Checked for relevance 02-Apr-2015***

Symptoms

A customer observed that queries using a series of left-outer joins consumed all temporary space and failed with TT802 errors:

The SQL queries were being generated by the Oracle Business Intelligence "OBIEE" tool. Using queries and DDL supplied by the customer, the problem was subsequently reproduced in-house. Further testing showed that the problem reproduced regardless of the cardinalities of the tables in the query. Additionally, it was also observed that the problem reproduced only when the query involved a series of left outer joins. Rewriting the queries to use right outer joins or inner joins did not cause the same errors and the queries typically completed in timely fashion.

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