Bulk Fetch Failed in OBIEE 12c

Question

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?

[Deleted User] · Answer

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

Gianni Ceresa · Answer

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

Joel Acha · Answer

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.