Problem in report studio with teradata

[backhandx]

Hi all,

When I excute a dimensional report on report Studio, I get this message from Database : No more spool space, and just below, the query which was sent to the database.

When I excute this query directly againt the database, it returns result without any problem.
I cannot understand why this is happening?

Any help please?

Thanks!

[AnalyticsWithJay]

This is something you should work with your DBA, as they could provide you much better information as to what's happening in your environment that's causing the account to run out of spool space.

Are you using the same account that Cognos is using when you're querying the database directly? An important note to make is that spool Space is a user specific attribute, not a database wide one. The spool space specific to the account that Cognos is using is running out of memory.

Finally, make sure you're testing the exact same query that Cognos is sending, by capturing it either via native SQL logging or a database trace. The SQL shown in Report Studio is NOT the exact SQL that is sent.

Once that issue is resolved, you may have another issue related to modeling or report design, but that's for later.

Could you give more details as to what kind of model this is - relational, DMR, etc? CQM or DQM? Dynamic cube?

Jay