Memory Usage Error in Win64 version of SPSS 19
Locked
Memory Usage Error in Win64 version of SPSS 19
 
|
Several people in my office have started running into problems running TABLES inside OMS on 64-bit Win7 SP1 computers (8GB RAM) with SPSS 19.0.0.3. We just switched from 32-bit Win7 (4GB RAM) where the syntax was working. The error messages have all referenced “insufficient memory” or “Out of memory”. Has anyone run into this and found a solution? I couldn’t find anything on the list. Here’s a co-worker’s more detailed description of what he’s seeing. This last week I encountered a strange error message running a basic table that has worked repeatedly in the past: Warning reads: Insufficient memory to process the TABLES command. The problem encountered during tuple creation. Break up the request or rerun with more memory. Execution of this command stops. I recently upgraded office machines from Windows 7, 32-Bit to Windows 7, 64-Bit. In the previous environment, using SPSS 19 the following table syntax would generate a valid table that we would then export to Excel using OMS: TABLES /FORMAT BLANK MISSING('.') /FTOTAL=T1 'Total' /obs applicants acceptance_rate yield /TABLE= x_comp>(applicants+acceptance_rate+yield) by year /STATISTICS= max( 'Maximum') ptile 75( '75th Percentile') median( 'Median') ptile 25 ( '25th Percentile') min( 'Minimum') validn( 'n=') /TITLE "Admissions Statistics at ND and Peers 2002-2011" /CAPTION 'IPEDS Institutional Characteristics, 2002-2011 (cEX024B_testscores)\nInstitutional Research' I went back to my old Win7 32-Bit box and reran the syntax. No error. Table generated fine. I restarted my new Win7 64-Bit box and reran the syntax. Same error. I closed all of other open programs and reran the syntax. Same error. I tried setting tablerender to Light. Same error. I tried setting workspace to a larger value (set workspace = 100000). Same error. Is this a known feature to get me to move to ctables? Is this a problem with the 64-Bit version of SPSS 19? Thanks! Catherine Kubitschek ([hidden email]) IR Sr. Analyst & Programmer Office of Strategic Planning & Institutional Research 403B Grace Hall University of Notre Dame Notre Dame, IN 46556-5611 Ph: 574/261-3550 | Fx: 574/261-9235 | http://ospir.nd.edu |
Re: Memory Usage Error in Win64 version of SPSS 19
|
|
TABLES was deprecated many years ago in
favor of CTABLES, so it isn't altogether surprising that it has problems
in a 64-bit environment. I haven't heard of this problem before,
but it's certainly not "a known
feature to get me to move to ctables".
On the other hand, I doubt that anyone would be willing to try to
fix this.
You might consider trying the syntaxconverter utility included with Statistics that converts TABLES code to CTABLES. It can't be absolutely perfect at converting, but it's easy to try, and it usually does a pretty reasonable job. As an experiment, I applied it to the TABLES command below. Here is the conversion (the converter does not produce the most parsimonious code: CTABLES /MRSETS COUNTDUPLICATES=YES /FORMAT EMPTY=BLANK MISSING='.' /TABLE x_comp[C]>applicants[S][MAXIMUM,'Maximum',PTILE 75,'75th Percentile', MEDIAN,'Median',PTILE 25,'25th Percentile',MINIMUM,'Minimum',VALIDN,'n=']+ x_comp[C]>acceptance_rate[S][MAXIMUM,'Maximum',PTILE 75,'75th Percentile', MEDIAN,'Median',PTILE 25,'25th Percentile',MINIMUM,'Minimum',VALIDN,'n=']+ x_comp[C]>yield[S][MAXIMUM,'Maximum',PTILE 75,'75th Percentile', MEDIAN,'Median',PTILE 25,'25th Percentile',MINIMUM,'Minimum',VALIDN,'n='] BY year[C] /CATEGORIES VAR=ALL EMPTY=EXCLUDE MISSING=EXCLUDE /SLABELS POSITION=ROW /TITLES TITLE="Admissions Statistics at ND and Peers 2002-2011" CAPTION= 'IPEDS Institutional Characteristics, 2002-2011 (cEX024B_testscores)\nInstitutional Research'. Try running this to see what the table looks like. Jon Peck (no "h") aka Kim Senior Software Engineer, IBM [hidden email] new phone: 720-342-5621 From: Catherine Kubitschek <[hidden email]> To: [hidden email] Date: 03/15/2012 05:45 PM Subject: [SPSSX-L] Memory Usage Error in Win64 version of SPSS 19 Sent by: "SPSSX(r) Discussion" <[hidden email]> Several people in my office have started running into problems running TABLES inside OMS on 64-bit Win7 SP1 computers (8GB RAM) with SPSS 19.0.0.3. We just switched from 32-bit Win7 (4GB RAM) where the syntax was working. The error messages have all referenced “insufficient memory” or “Out of memory”. Has anyone run into this and found a solution? I couldn’t find anything on the list. Here’s a co-worker’s more detailed description of what he’s seeing. This last week I encountered a strange error message running a basic table that has worked repeatedly in the past: Warning reads: Insufficient memory to process the TABLES command. The problem encountered during tuple creation. Break up the request or rerun with more memory. Execution of this command stops. I recently upgraded office machines from Windows 7, 32-Bit to Windows 7, 64-Bit. In the previous environment, using SPSS 19 the following table syntax would generate a valid table that we would then export to Excel using OMS: TABLES /FORMAT BLANK MISSING('.') /FTOTAL=T1 'Total' /obs applicants acceptance_rate yield /TABLE= x_comp>(applicants+acceptance_rate+yield) by year /STATISTICS= max( 'Maximum') ptile 75( '75th Percentile') median( 'Median') ptile 25 ( '25th Percentile') min( 'Minimum') validn( 'n=') /TITLE "Admissions Statistics at ND and Peers 2002-2011" /CAPTION 'IPEDS Institutional Characteristics, 2002-2011 (cEX024B_testscores)\nInstitutional Research' I went back to my old Win7 32-Bit box and reran the syntax. No error. Table generated fine. I restarted my new Win7 64-Bit box and reran the syntax. Same error. I closed all of other open programs and reran the syntax. Same error. I tried setting tablerender to Light. Same error. I tried setting workspace to a larger value (set workspace = 100000). Same error. Is this a known feature to get me to move to ctables? Is this a problem with the 64-Bit version of SPSS 19? Thanks! Catherine Kubitschek (kubitschek.2@...) IR Sr. Analyst & Programmer Office of Strategic Planning & Institutional Research 403B Grace Hall University of Notre Dame Notre Dame, IN 46556-5611 Ph: 574/261-3550 | Fx: 574/261-9235 | http://ospir.nd.edu |
Re: Memory Usage Error in Win64 version of SPSS 19
|
|
Thanks, Jon. We knew it would happen someday. We’ll be experimenting with syntaxconverter.exe on many tables now. Thanks for getting us started with the first. The “In defense of CTABLES” thread that is happening right now – good timing for us. Catherine From: Jon K Peck [mailto:[hidden email]] TABLES was deprecated many years ago in favor of CTABLES, so it isn't altogether surprising that it has problems in a 64-bit environment. I haven't heard of this problem before, but it's certainly not "a known feature to get me to move to ctables". On the other hand, I doubt that anyone would be willing to try to fix this.
|
| Free forum by Nabble | Edit this page |