Topic
  • 7 replies
  • Latest Post - ‏2013-01-10T10:08:20Z by SystemAdmin
SystemAdmin
SystemAdmin
881 Posts

Pinned topic Freezing of submitted SPSS syntax (CTABLES, OMS)

‏2013-01-04T09:02:17Z |
Hello,

We are using Submit in .NET to run SPSS syntax which is generating HTML table with CTABLES via OMS export. If the final table is large, although HTML file is already stored, Submit doesn’t allow thread to continue and freeze for couple of minutes. Example of code and data is embedded.

Thank you for any suggestion

Radim


Processor spssProc = 

new Processor();   System.Array cmdlines = 

new string[] 
{ 
"set error=off.", 
"define !WrkDir() 'D:\\TMP\\' !enddefine.", 
"set TVars=Both TNumbers=Both OVars=Both ONumbers=Both.", 
"set error=on.", 
"GET FILE=!WrkDir+'data.sav'.", 
"OMS /SELECT TABLES /IF LABELS=['A1!P'] /DESTINATION FORMAT=HTML IMAGES=NO OUTPUTSET=LABELS FOLDER=!WrkDir VIEWER = NO.", 
"MRSETS /MCGROUP NAME=$MR LABEL='MR' VARIABLES=A1a A1b A1c A1d A1e /DISPLAY NAME=[$MR].", 
"CTABLES /FORMAT EMPTY=ZERO /TABLE ($MR) [S] [COLPCT.TOTALN, 'Column N %', F10.4] [COUNT,F10.0] [ROWPCT.COUNT,F10.4] [COLPCT.RESPONSES,F10.4] BY (quart2) [C] /CATEGORIES VAR=$MR EMPTY=EXCLUDE /CATEGORIES VAR=quart2 EMPTY=EXCLUDE /TITLES TITLE='A1!P'.", 
"OMSEND." 
};   

try 
{ spssProc.Submit(cmdlines); 
} 

catch 
{   
}   spssProc.StopSPSS();

Attachments

Updated on 2013-01-10T10:08:20Z at 2013-01-10T10:08:20Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    881 Posts

    Re: Freezing of submitted SPSS syntax (CTABLES, OMS)

    ‏2013-01-04T14:22:09Z  
    Are you saying that the job never completes or only that it takes a long time?

    What version of SPSS Statistics are you using (including patch level)? What version of Windows?
  • SystemAdmin
    SystemAdmin
    881 Posts

    Re: Freezing of submitted SPSS syntax (CTABLES, OMS)

    ‏2013-01-07T08:56:23Z  
    Are you saying that the job never completes or only that it takes a long time?

    What version of SPSS Statistics are you using (including patch level)? What version of Windows?
    Job completes always becouse we get result in second (HTML file is saved), but
  • SystemAdmin
    SystemAdmin
    881 Posts

    Re: Freezing of submitted SPSS syntax (CTABLES, OMS)

    ‏2013-01-07T09:01:49Z  
    Are you saying that the job never completes or only that it takes a long time?

    What version of SPSS Statistics are you using (including patch level)? What version of Windows?
    Job completes always because we get result in second (HTML file is saved), but thread doesn’t continue immediately. With big table it holds for minutes.

    We are using SPSS 18.0.3 with PASW Statistics-.NET Integration Plug-in 18 version 18.0.0.0.

    Thanks
  • SystemAdmin
    SystemAdmin
    881 Posts

    Re: Freezing of submitted SPSS syntax (CTABLES, OMS)

    ‏2013-01-07T13:47:27Z  
    Job completes always because we get result in second (HTML file is saved), but thread doesn’t continue immediately. With big table it holds for minutes.

    We are using SPSS 18.0.3 with PASW Statistics-.NET Integration Plug-in 18 version 18.0.0.0.

    Thanks
    I wonder how big this table actually is. If you run this job in regular interactive mode, does it also pause for a long time? In V18 very large tables could be very slow.
  • SystemAdmin
    SystemAdmin
    881 Posts

    Re: Freezing of submitted SPSS syntax (CTABLES, OMS)

    ‏2013-01-09T12:49:12Z  
    I wonder how big this table actually is. If you run this job in regular interactive mode, does it also pause for a long time? In V18 very large tables could be very slow.
    Table is big, because it is a long term tracking with former brands. In regular interactive mode it is OK and relatively fast. Problem is with .NET implementation and usage of Submit.
  • SystemAdmin
    SystemAdmin
    881 Posts

    Re: Freezing of submitted SPSS syntax (CTABLES, OMS)

    ‏2013-01-09T13:41:15Z  
    Table is big, because it is a long term tracking with former brands. In regular interactive mode it is OK and relatively fast. Problem is with .NET implementation and usage of Submit.
    That is baffling. When the command is submitted, its execution should be the same as in interactive mode. Since there is no front end, it could even be faster. The Submit api itself would not take any time. It would be useful to know what the Task Manager shows for the process during the dead time. Is the process doing anything - cpu, i/o,.... Maybe it is waiting for something (I don't know what.) What are the table dimensions?
  • SystemAdmin
    SystemAdmin
    881 Posts

    Re: Freezing of submitted SPSS syntax (CTABLES, OMS)

    ‏2013-01-10T10:08:20Z  
    That is baffling. When the command is submitted, its execution should be the same as in interactive mode. Since there is no front end, it could even be faster. The Submit api itself would not take any time. It would be useful to know what the Task Manager shows for the process during the dead time. Is the process doing anything - cpu, i/o,.... Maybe it is waiting for something (I don't know what.) What are the table dimensions?
    We tried to look at Task Manager, but unfortunately there was nothing relevant. You can try it yourself with code and sav file embedded in first post. You only change directory in code where you have placed sav file.