fatal error

[pspangler1]

Hey all,

I when running SORT BY I received the following error. Strange this is that I have run this command on this file a couple times earlier (today) with no trouble. Can I empty this cache to clear it?

SORT CASES  BY decilebin. 

 

>Error.  Command name: SORT CASES BY 

>File write error: file name C:\Users\PSPANG~1\AppData\Local\Temp\spss4960\cache.3: No space left on device (DATA1002) 

>Execution of this command stops.

[David Marso]

Delete all your porn.
Then you will have space enough to sort the file.
I actually recommended this as the error message to the design peeps at SPSS in the 90's...
Can imagine how that meeting went ;=}
---------

Peter Spangler-2 wrote

Hey all,

I when running SORT BY I received the following error. Strange this is that
I have run this command on this file a couple times earlier (today) with no
trouble. Can I empty this cache to clear it?

SORT CASES  BY decilebin.

>Error.  Command name: SORT CASES BY
>File write error: file name
C:\Users\PSPANG~1\AppData\Local\Temp\spss4960\cache.3: No space left on
device (DATA1002)
>Execution of this command stops.

[pspangler1]

Or maybe move a few of these 8GB datasets to my backup drive :-)

I just received a new box at work. The drive is only 267GB. Bound to fill up fast.

Sent from my iPhone

> On Feb 6, 2014, at 12:07 AM, David Marso <[hidden email]> wrote:
>
> Delete all your porn.
> Then you will have space enough to sort the file.
> I actually recommended this as the error message to the design peeps at SPSS
> in the 90's...
> Can imagine how that meeting went ;=}
> ---------
>
> Peter Spangler-2 wrote
>> Hey all,
>>
>> I when running SORT BY I received the following error. Strange this is
>> that
>> I have run this command on this file a couple times earlier (today) with
>> no
>> trouble. Can I empty this cache to clear it?
>>
>> SORT CASES  BY decilebin.
>>
>>> Error.  Command name: SORT CASES BY
>>> File write error: file name
>> C:\Users\PSPANG~1\AppData\Local\Temp\spss4960\cache.3: No space left on
>> device (DATA1002)
>>> Execution of this command stops.
>
>
>
>
>
> -----
> Please reply to the list and not to my personal email.
> Those desiring my consulting or training services please feel free to email me.
> ---
> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
> --
> View this message in context: http://spssx-discussion.1045642.n5.nabble.com/fatal-error-tp5724344p5724347.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Rick Oliver-3]

SORT can require three times as much temporary disk space as the size of the file being sorted. For large data files, this can require a large amount of disk space. The message indicates you don't have enough disk space.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        Peter Spangler <[hidden email]>
To:        [hidden email],
Date:        02/05/2014 04:45 PM
Subject:        fatal error
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hey all,

I when running SORT BY I received the following error. Strange this is that I have run this command on this file a couple times earlier (today) with no trouble. Can I empty this cache to clear it?

SORT CASES  BY decilebin. 
 
>Error.  Command name: SORT CASES BY 
>File write error: file name C:\Users\PSPANG~1\AppData\Local\Temp\spss4960\cache.3: No space left on device (DATA1002) 
>Execution of this command stops.

[Albert-Jan Roskam]

________________________________
> From: Peter Spangler <[hidden email]>
>To: [hidden email]
>Sent: Thursday, February 6, 2014 2:32 PM
>Subject: Re: [SPSSX-L] fatal error
>
>
>Or maybe move a few of these 8GB datasets to my backup drive :-)

hmm, that adds a whole new dimension to the term 'data scientist'. :-)

I have had the same issue before:
1-you can programmatically change the tempdir (see below)
2-you can clean the tempdir (sometimes needed after spss has crashed)
3-poor man's solution: if you need to sort by vars x, y, z

you can do

sort cases by z.
sort cases by y.
sort cases by x.
...instead of "sort cases by x y z", because the sort is a stable sort. That might save some caching space.


* Ad 1.
file handle alt_tempdir /name = "\\server\share\spacious\location".

begin program.
import SpssClient, spssaux
try:
    SpssClient.StartClient()
    option = SpssClient.PreferenceOptions.TempDir
    value = spssaux.FileHandles().resolve("alt_tempdir")
    SpssClient.SetPreference(option, value)
finally:
   SpssClient.StopClient()
end program.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[pspangler1]

Haha, thank you for the solution, Albert-Jan. I shall keep that in the ready! It is primarily transaction and demographic data. It tends to grow quite quickly.

On Thu, Feb 6, 2014 at 10:57 AM, Albert-Jan Roskam <[hidden email]> wrote:

________________________________
> From: Peter Spangler <[hidden email]>
>To: [hidden email]
>Sent: Thursday, February 6, 2014 2:32 PM
>Subject: Re: [SPSSX-L] fatal error

>
>
>Or maybe move a few of these 8GB datasets to my backup drive :-)

hmm, that adds a whole new dimension to the term 'data scientist'. :-)

I have had the same issue before:
1-you can programmatically change the tempdir (see below)
2-you can clean the tempdir (sometimes needed after spss has crashed)
3-poor man's solution: if you need to sort by vars x, y, z

you can do

sort cases by z.
sort cases by y.
sort cases by x.
...instead of "sort cases by x y z", because the sort is a stable sort. That might save some caching space.


* Ad 1.
file handle alt_tempdir /name = "\\server\share\spacious\location".

begin program.
import SpssClient, spssaux
try:
    SpssClient.StartClient()
    option = SpssClient.PreferenceOptions.TempDir
    value = spssaux.FileHandles().resolve("alt_tempdir")
    SpssClient.SetPreference(option, value)
finally:
   SpssClient.StopClient()
end program.

[David Marso]

This can also be done via Edit>Options>File Locations [tab] ..
One thing I can't fathom is why there isn't a SET option for this?
Same with the Journal file (used to be but according to the FM is now obsolete!)!

Albert-Jan Roskam wrote

________________________________
> From: Peter Spangler <[hidden email]>
>To: [hidden email]
>Sent: Thursday, February 6, 2014 2:32 PM
>Subject: Re: [SPSSX-L] fatal error
>
>
>Or maybe move a few of these 8GB datasets to my backup drive :-)

hmm, that adds a whole new dimension to the term 'data scientist'. :-)

I have had the same issue before:
1-you can programmatically change the tempdir (see below)
2-you can clean the tempdir (sometimes needed after spss has crashed)
3-poor man's solution: if you need to sort by vars x, y, z

you can do

sort cases by z.
sort cases by y.
sort cases by x.
...instead of "sort cases by x y z", because the sort is a stable sort. That might save some caching space.


* Ad 1.
file handle alt_tempdir /name = "\\server\share\spacious\location".

begin program.
import SpssClient, spssaux
try:
    SpssClient.StartClient()
    option = SpssClient.PreferenceOptions.TempDir
    value = spssaux.FileHandles().resolve("alt_tempdir")
    SpssClient.SetPreference(option, value)
finally:
   SpssClient.StopClient()
end program.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Albert-Jan Roskam]

----- Original Message -----

> From: David Marso <[hidden email]>
> To: [hidden email]
> Cc:
> Sent: Thursday, February 6, 2014 8:25 PM
> Subject: Re: [SPSSX-L] fatal error
>
>T his can also be done via Edit>Options>File Locations [tab] ..
> One thing I can't fathom is why there isn't a SET option for this?
> Same with the Journal file (used to be but according to the FM is now
> *obsolete*!)!

I actually wrapped this code in an extension command TEMPDIR (I thought about calling it SET_TEMPDIR!). I don't like it if things cannot be reproduced straight from syntax. *I* might have changed the tempdir to one with more space, but somebody who runs my code might not have done this, so the program might crash depending on the user.

I also never understood why they removed SET JOURNAL. I rarely look at the .jnl file, but occasionally it is very useful. It can probably also be set using SpssClient, or else probably somewhere under the following regkey (Windows only, SPSS v20 though): HKEY_CURRENT_USER\Software\JavaSoft\Prefs\com\ibm\/S/P/S/S\/Statistics\20.0\ui\options\file_locations

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD