Bulk Fetch Failed in OBIEE 12c

User_5YLTI

Hi All,

I have OBIEE 12.2.1.4. installed and my DB version is also 12c.

But for few of the reports which fetched huge data (65000 or more) I am getting the following error :

State: HY000. 
Code: 17001.  [nQSError: 17001] Oracle Error code: 1652, message:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
at OCI call OCIStmtFetch.
(HY000)

State: HY000.  Code: 17012.  [nQSError: 17012] Bulk fetch failed. (HY000)

is there any permanent solution to this?

Joel

There is a permanent solution to this but beforehand, this is a DB error indicating that your OBIEE analysis is using up all the TEMP space on your DB which would indicate that the data volumes are excessive. Resolve this by redefining the analysis causing this.

Gianni Ceresa

3003431 wrote:is there any permanent solution to this?

Filter your dataset

Ok, more seriously, you aren't having an OBIEE issue.

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

This is a database message, you are short in tablespace in your DB, you need to ask your DBA to look into it to either extend the tablespace or you need to use a different approach for what you are trying to do ....

EDIT: I need to stop writing sentences, so I can *post* faster than Joel

[Deleted User]

Gianni Ceresa wrote:EDIT: I need to stop writing sentences, so I can faster than Joel 

You need to start writing sentences which aren't missing key words like "post" ;-P