Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Bulk Fetch Failed in OBIEE 12c
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 :
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)
Answers
-
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.
0 -
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
0 -
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
0
