Out Of Disk Space Error In Obiee 11g
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Business Intelligence Suite Enterprise Edition All PlacesBusiness IntelligenceBusiness Intelligence FoundationBusiness Intelligence Suite Enterprise Edition This discussion is archived 10 Replies Latest reply on Jan 24, 2011 3:29 AM by 776852 [nQSError: 46118] Out of disk space. M. Corallo Sep 11, 2009 9:02 AM Hello, I'm having this error: [nQSError: 46118] Out of disk space. after launching several (heavvy) reports. The software configuration is an oracle bi 10.1.3.3.3 and oracle 10g db. What does it mean? I know it means that there isn't space left but where? In the db machine or in the bi server (presentatio? server?) machine? Is it a db problem? I don't think so beacuse there isn't an ORA-XXXX error code so i think is not an oracle error caught by the BI server and we discovered that clearing all cursors from the administration prevent this error to appear for a while. Can someone tell me if is an Oracle Bi (Server? Presentation?) problem and how to solve it? Do i have to set a parameter somewhere to limit the cursors or to high the cache? Thank you Maurizio I have the same question Show 0 Likes(0) 2196Views Tags: none (add) This content has been marked as final. Show 10 replies 1. Re: [nQSError: 46118] Out of disk space. rmoff Sep 11, 2009 9:23 AM (in response to M. Corallo) Almost certainly your BI Server's temp dir is out of space. If they're big reports then when the data's brought back from the DB a lot will land on d
stop there. How you are producing those numbers matters, and matters a lot if you have an interest in the long-term health of your system and its ability to scale. OBIEE is the case in point here, but the principle applies to any architecture with >1 tiers or components. Let me start with a rhetorical question. The user has got a report which has ten rows of data. Which of the following methods is going to be a more efficient way to generate the report? Transfer the ten rows of data from the database back to the rendering application, and the rendered report to the user Transfer https://community.oracle.com/thread/958640 fourteen million rows of data from the database back to the rendering application, get the application to crunch these to the required ten rows, transfer rendered report to the user Obviously, it's the first one. In the second one (and this is no hyperbolic example to prove a point, I'm sorry to say) we have the following overheads: Network traffic of fourteen million rows from the database to the application server Disk https://rnm1978.wordpress.com/2011/05/19/obiee-performance-get-your-database-sweating/ and/or Memory impact on the application server, depending on how it's processing those fourteen millions rows CPU impact on the application server when it processes those fourteen million rows Considering OBIEE specifically, you should be aiming to be able to answer all of your questions on the database directly. As soon as you start using the database simply as a source for dumping big volumes of rows into your OBIEE server, you're storing up problems. An RDBMS is designed for crunching lots of data. You've already lifted all that data off the disk when you selected it out of the tables on Oracle DB - why not get Oracle DB to do the additional processing required too? Where's the benefit in lifting & shifting all of that data to then reprocess it again? In fact, consider why you're crunching big volumes of data each time in the first place. If multiple people have the same big queries, are you missing some aggregates in your data source that would support these queries much better? Or do you need to be looking towards multi-dimensional sources such as Oracle OLAP or Essbase? The flexibility and power of OBIEE to do its own calculations and aggregations on data is a double-edged sword, and one to be wielded with respon
Solution : Need to http://obieedue.blogspot.com/2011/10/odbc-driver-returned.html keep minimum 10MB for obiee-disk memory space...after http://community.teradata.com/t5/Database/Out-of-spool-space-on-disk/td-p/25067 cleaning the drive that issue was resolved.ThanksDeva Posted by obieedue Obiee at 10/24/2011 08:09:00 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest 3 comments: AnonymousDec 13, out of 2011, 12:57:00 PMGreat Work Deva........AnandReplyDeleteDevaJan 25, 2012, 8:43:00 PMthanksReplyDeleteSandeep VenuJul 27, 2012, 1:52:00 AMThanks DevaReplyDeleteAdd commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom) Total Page View Count Search This out of disk Blog Loading... Blog Archive ► 2012 (27) ► August (6) ► July (8) ► June (2) ► May (3) ► March (4) ► February (2) ► January (2) ▼ 2011 (54) ► December (1) ► November (6) ▼ October (5) Refreshing GUID in obiee11g ODBC driver returned an error(SQLExecDirectW).NQSE... OBIEE11g Features OBIEE Licence supporting components Windows 7 Home Premium edition is not supported fo... ► September (7) ► August (7) ► June (28) ► 2010 (9) ► December (9) Followers About Me View my complete profile Follow by Email obieedue.blogspot.com. Simple template. Template images by Cimmerian. Powered by Blogger.
baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: Teradata : Product Forums : Database : Out of spool space on disk Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page vickyejain Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 10-22-2014 12:11 AM 10-22-2014 12:11 AM Out of spool space on disk I have a situation on a productions system where our production jobs are failing with the 'Out of spool space on disk' error since yesterday. This process has been running for over a year and the data volumes being processed are consistent with the usual. The runs are currently failing whenever the total spool used is 1x although I have 6x space free in the database and the user is assigned >6x spool space limit for the user. There does not seem to be any change in the skewness of the data in the system either.Usually when we run out of space, I see a 'no more spool space' error but this time it is 'out of spool space on disk' error. Teradata documentation does not provide much help in diagnosing and resolving the issue. There is nothing else running on the box and there is sufficient perm space. Any pointers on what else should be investigated will be appreciated. Everyone's tags (3): out of spoolspacespool 0 Kudos Reply All forum topics Previous Topic Next Topic 2 REPLIES CarlosAL Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 10-22-2014 12:37 AM 10-22-2014 12:37 AM Re: Out of spool space on disk Vickye:There is no disk space to provide spool space for the process. The spool space available is provided by the free cylinders in the filesystem. This usually means that you are running out of space. Notice that this can happen on a single AMP which can be full (its filesystem) due to skew."No more spool space" is a 'logical limit' (imposed as a rule) whereas your error is a 'physical limit' (lack of resources).Cheers.Carlos. 0 Kudos Reply CarlosAL Enthusiast Options Mark as New Bookmark