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..."
Last updated on JANUARY 02, 2018
Applies to:Oracle Exalytics Software - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 1.0]
Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 to 126.96.36.199.1 [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).
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.
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