Running BEGIN PROGRAM... getting stuck

[Ruben Geert van den Berg]

Dear all,

I'm running a whole bunch of (rather small) Python blocks (from SPSS 20.0.0.2, Python 2.7.1). At some point, SPSS always seems to get stuck.

I used Windows Task Manager to kill it. I saw that the total memory consumption was exceeding my physical memory so I thought that this was the problem. Also, some SPSS components stay active upon killing the process so I also terminated those.

That brings memory usage back to normal but it doesn't prevent SPSS from getting stuck. Typing "Python" in the command prompt as suggested here works fine.

I expect a reboot to solve the problem but rebooting every 10-15 minutes would be a time consuming solution for the problem.

Has anybody else experienced similar symptoms? Can I fix it faster than rebooting?

TIA!

[Jon K Peck]

Which process is showing the large memory consumption?  If it is in the Python process, can you account for this memory usage in your code logic?  When SPSS "get stuck", do you see in the TM that the SPSS processes are consuming cpu time or not (startx startx32 spssengine, stats, with some variation according to the SPSS version)?


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        Ruben Geert van den Berg <[hidden email]>
To:        [hidden email],
Date:        12/12/2013 09:19 AM
Subject:        [SPSSX-L] Running BEGIN PROGRAM... getting stuck
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear all,

I'm running a whole bunch of (rather small) Python blocks (from SPSS
20.0.0.2, Python 2.7.1). At some point, SPSS always seems to get stuck.

I used Windows Task Manager to kill it. I saw that the total memory
consumption was exceeding my physical memory so I thought that this was the
problem. Also, some SPSS components stay active upon killing the process so
I also terminated those.

That brings memory usage back to normal but it doesn't prevent SPSS from
getting stuck. Typing "Python" in the command prompt as suggested  here
<https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014586746#77777777-0000-0000-0000-000014587226>
works fine.

I expect a reboot to solve the problem but rebooting every 10-15 minutes
would be a time consuming solution for the problem.

Has anybody else experienced similar symptoms? Can I fix it faster than
rebooting?

TIA!



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Running-BEGIN-PROGRAM-getting-stuck-tp5723617.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

[Ruben Geert van den Berg]

Thanks for the suggestions.

It seems the real problem is in my VPN, not SPSS.

I'm using Python's cx_Oracle module for querying a Database. In order for the DB server not to reject my requests, I need to be VPN connected to the DB server while generating queries.

The very moment I disconnect the VPN, SPSS recovers instantly and is "Ready for processing". (That surprised me too.)

Conclusion: the problem seems unrelated to SPSS and therefore off-topic here.

Kind regards,

Ruben