Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
7 replies Latest Post - ‏2013-01-10T10:08:20Z by SystemAdmin
SystemAdmin
SystemAdmin
881 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

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

    ‏2013-01-04T14:22:09Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

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

      ‏2013-01-07T08:56:23Z  in response to SystemAdmin
      Job completes always becouse we get result in second (HTML file is saved), but
    • SystemAdmin
      SystemAdmin
      881 Posts
      ACCEPTED ANSWER

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

      ‏2013-01-07T09:01:49Z  in response to SystemAdmin
      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
        ACCEPTED ANSWER

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

        ‏2013-01-07T13:47:27Z  in response to SystemAdmin
        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
          ACCEPTED ANSWER

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

          ‏2013-01-09T12:49:12Z  in response to SystemAdmin
          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
            ACCEPTED ANSWER

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

            ‏2013-01-09T13:41:15Z  in response to SystemAdmin
            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
              ACCEPTED ANSWER

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

              ‏2013-01-10T10:08:20Z  in response to SystemAdmin
              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.