Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #73236

Re: Suds 4.1 Beta Assertion Failure

Show all headers | View raw

It turns out I was passing the parameters incorrectly to the generateReportSQL method.

This is what I had:
result=reportservice.generateReportSQL(rptRef, paramRpt, sessionid) 

This is what works:
result=XMLservice.generateReportSQL({'reportPath':rptRef},sessionid)

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

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Suds 4.1 Beta Assertion Failure 1stpoint@gmail.com - 2014-06-09 08:45 -0700
  Re: Suds 4.1 Beta Assertion Failure dieter <dieter@handshake.de> - 2014-06-10 07:50 +0200
    Re: Suds 4.1 Beta Assertion Failure 1stpoint@gmail.com - 2014-06-12 12:52 -0700
      Re: Suds 4.1 Beta Assertion Failure dieter <dieter@handshake.de> - 2014-06-13 08:02 +0200

csiph-web