OBIEE 11g Dashboard Fails Intermittently With Errors: "OPR4ONWY:U9IM8TAC:OI2DL65P... ORA-01652: unable to extend temp segment by 128 in tablespace TEMP at OCI call OCIStmtFetch..." (Doc ID 1580561.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Exalytics Software - Version 1.0.0.0.0 to 1.0.0.3.0 [Release 1.0]
Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 to 11.1.1.7.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

When executing a certain Oracle Business Intelligence Enterprise Edition (OBIEE) 11g dashboard page with multiple prompts, that returns millions of rows, inconsistent behavior is seen.
If the report is run and a value is selected in each prompt, the report completes.

If the report is run and the "All Values" option is selected in the prompts, the report may fail with errors:

Odbc driver returned an error (SQLExecDirectW).

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 12801, message: ORA-12801: error signaled in parallel query server P005, instance exadataDB.mydomain.com (1) ORA-01652: unable to extend temp segment by 128 in tablespace TEMP at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)

SQL Issued: SELECT "- Well Header"."API Well No." ...


If the query is run in SQL*Plus or SQL Developer, it succeeds and returns over 4.65 million rows.

This problem may occur when running OBIEE 11g on Exalytics, or on standalone OBIEE 11g server.

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