SYMPTOM:
"No more spool space in " error is found in DSSErrors.log when connecting to a Teradata warehouse.
Sample Code/Error
2011-01-31 10:49:30.326-05:00 Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. No more spool space in . Connection String: DSN=WarehouseDSN;UID=UserID;AUTHENTICATION=;. SQL Statement: ;insert into...
CAUSE:
Spool space is temporary hard disk space that is used to store intermediate rows when processing a query and also for storing answer set rows of a transaction. Spool space allocation is done per user and this space is spread across all Access Module Processors (AMPs). An AMP is a type of virtual processor used to perform a variety of tasks in a Teradata Database environment. If a user is allocated 50GB of spool space and the system has 20 AMPs, the user is allocated 2.5GB of spool space on each AMP. If the spool space allocated for each AMP is exceeded while processing a query, it is cancelled with the "No more spool space in " error.
ACTION:
Contact the Database Administrator (DBA) to increase the spool space allocated.
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
KB423463
