topic error-ERROR: Teradata row not delivered (trget): No more spool space in udkdw02. in SAS Programming

error-ERROR: Teradata row not delivered (trget): No more spool space in udkdw02.

Ronein — Wed, 30 Mar 2022 05:51:44 GMT

Hello

I am running in SAS proc sql that is working on database from tera.

I am running a code and I am getting this error:

ERROR: Teradata row not delivered (trget): No more spool space in udkdw02.

What does it mean?>

What should I do to solve it?

Re: error-ERROR: Teradata row not delivered (trget): No more spool space in udkdw02.

ballardw — Wed, 30 Mar 2022 17:21:04 GMT

You don't describe how you are connecting to Teradata so this sort of a generic comment.

Look up the SPOOL= option for Libname connecting to relation data bases for a description of what spooling means, and the warning about turning it off for Teradata.

Likely your spool space isn't large enough for what ever you connected to. I found a note in the documentation under Teradata Processing Tips for SAS Users that possibly setting the OBS option can reduce the space used. Which points to "See the SAMPLE clause in your Teradata documentation for more information."

Re: error-ERROR: Teradata row not delivered (trget): No more spool space in udkdw02.

Tom — Wed, 30 Mar 2022 18:10:51 GMT

Check exactly what query you are trying to run. That typically means whatever Teradata query you tried to run overwhelmed the system.

Back when I used Teradata it was usually caused be not using the right PRIMARY INDEX variable for a table. That can lead to unbalanced loading such that all of the data is allocated to just one or a few of the compute nodes. So even though the system has lots of spool space that node ran out of the space allocated for it to use.

So make sure to define your Teradata tables using a PRIMARY INDEX variable(s) that evenly allocates the data to the nodes. Or look into use a NOPI or No Primary Index table.