My Oracle Support Banner

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 APRIL 21, 2021

Applies to:

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


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).

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 (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.


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

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