Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.albasani.net!rt.uk.eu.org!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <python-python-list@m.gmane.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.008
X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'intermediate': 0.07; '(its': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'thus,': 0.09; 'python': 0.11; '105,': 0.16; '64,': 0.16; 'received:80.91.229.3': 0.16; 'received:dip0.t-ipconnect.de': 0.16; 'received:plane.gmane.org': 0.16; 'received:t-ipconnect.de': 0.16; 'skip:e 100': 0.16; 'skip:r 80': 0.16; 'webservice': 0.16; 'memory': 0.22; 'issue.': 0.22; 'print': 0.22; 'header:User- Agent:1': 0.23; 'order.': 0.26; 'skip:" 30': 0.26; 'skip:" 40': 0.26; 'skip:" 20': 0.27; 'header:X-Complaints-To:1': 0.27; 'code': 0.31; 'apparently': 0.31; 'invoke': 0.31; 'skip:q 20': 0.31; 'writes:': 0.31; 'file': 0.32; 'this.': 0.32; 'run': 0.32; 'another': 0.32; '(most': 0.33; 'could': 0.34; 'objects': 0.35; 'but': 0.35; 'there': 0.35; 'data,': 0.36; 'executing': 0.36; 'options:': 0.36; 'charset:us-ascii': 0.36; 'too': 0.37; 'to:addr :python-list': 0.38; 'recent': 0.39; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'how': 0.40; 'read': 0.60; 'received:217': 0.63; 'email addr:gmail.com': 0.63; 'more': 0.64; 'temporary': 0.65; 'here': 0.66; 'limit': 0.70; 'incoming': 0.72; 'subject:Beta': 0.84; 'subject:Failure': 0.84
X-Injected-Via-Gmane: http://gmane.org/
To: python-list@python.org
From: dieter <dieter@handshake.de>
Subject: Re: Suds 4.1 Beta Assertion Failure
Date: Fri, 13 Jun 2014 08:02:09 +0200
References: <5d97c876-edd8-40b4-b7e2-0f2f8ec6c52a@googlegroups.com> <mailman.10942.1402379479.18130.python-list@python.org> <aa27fcb3-ad2b-4c39-a6f9-8fa96678b174@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Gmane-NNTP-Posting-Host: pd9e0a21e.dip0.t-ipconnect.de
User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.4.22 (linux)
Cancel-Lock: sha1:+6f+pd3Qi9R5nvLbJOSj5J4pXes=
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.11050.1402639344.18130.python-list@python.org>
Lines: 36
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1402639344 news.xs4all.nl 2960 [2001:888:2000:d::a6]:39403
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:73254

1stpoint@gmail.com writes:
> ...
> I have another issue.  When I make the call to return data apparently the result set is too big for suds and I get a MemoryError.
>
> Here is my code snippet:
>     print 'executing SQL Query:',len(logicalSQL)
>     executionOptions={'async':False,'maxRowsPerPage':50,'refresh':True,'presentationInfo':False,'type':'Q1'}
>     XMLservice=obiclient.service['XmlViewService']
> result=XMLservice.executeSQLQuery(logicalSQL,'SAWRowsetData',executionOptions,sessionid)
>
> When I run it I get:
> executing SQL Query: 5968
> Traceback (most recent call last):
>   File "C:\temp\obiee\obieetest.py", line 105, in <module>
>     result=XMLservice.executeSQLQuery(logicalSQL,'SAWRowsetData',executionOptions,sessionid)
>   File "build\bdist.win32\egg\suds\client.py", line 542, in __call__
>   File "build\bdist.win32\egg\suds\client.py", line 602, in invoke
>   File "build\bdist.win32\egg\suds\client.py", line 643, in send
>   File "build\bdist.win32\egg\suds\transport\https.py", line 64, in send
>   File "build\bdist.win32\egg\suds\transport\http.py", line 79, in send
>   File "C:\Python27\lib\socket.py", line 358, in read
>     buf.write(data)
> MemoryError: out of memory

There is not much "suds" can do with regard to this. In principle,
it could write to a temporary file - but its purpose is to present
the webservice result as a collection of Python objects - and
they, too, require memory in the same order.

Thus, you have the following options:

  *  learn how to limit the amount of data, the webservice provides
  *  give your system (its processes) more memory
  *  do not use "suds" but process the incoming data incrementally
     (avoiding the build of the intermediate collection of Python objects).