Webi Intelligence Error

building reports webintelligence
1

Hi All,

When attempting to create a BusinessObjects Web Intelligence XI 3.1 document from the Universe I encountered the following error :

“Database error: [NCR][ODBC Tersadata Driver] [Teradata Database]
No more spool space in Dev…(Error: WIS 10901)”

Thanks in Advance.

Adious (BOB member since 2009-10-06)

2

this definitely looks like a database error and with spool space errors it is normally associated with your SQL or in this case there simply isn’t enough spool space to run your query/report.
If you are not the BO administrator contact him/her and also check with your DBA too.

calleT74 :australia: (BOB member since 2007-03-30)

3

I am the Admin. What does the Admin need to do before taking this to DBA.
If I take the issue to DBA what do I need to ask him?

Thanks

Adious (BOB member since 2009-10-06)

4

Ok, before seeing your DBA you will need to assess the report and it’s query that you are trying to build. Is it a fairly huge query containg a lot of objects…etc? See if you can restrict the data by applying filters in the query (ie. rather than returning 5 years of data restrict it to just one year…etc).
I would start off with creating a very simple report (an object or two) to see if that runs ok and go from there and if the error still is encountered then there is an issue with space allocated in the database.

Do you see the error with existing reports too?

calleT74 :australia: (BOB member since 2007-03-30)

5

The easiest solution is to take the SQL generated for this report and give it to the DBA for analysis. There are generally one of several things wrong that cause this issue. First, it could be that spool space is not allocated correctly on the server and the SQL is fine. Second, there might not be a “group by” clause in your SQL, causing the temporary space on the database to be over subscribed. Third, if your “group by” clause is too large (contains large text values) it can overrun the spool space. Finally, if there is a join missing and the result is a full or even a partial Cartesian product then that needs to be fixed in the universe, but the DBA might be able to help track down what is missing.

Dave Rathbun :us: (BOB member since 2002-06-06)