Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

limitation on XML-RPC result size? experiencing incomplete result sets: msg#00005

cms.opengroupware.xmlrpc.devel

Subject: limitation on XML-RPC result size? experiencing incomplete result sets

Hi all -

Is there an inherent limit on records contained in or other implicit
filtering applied to the result set returned to an XML-RPC query?

I'm currently migrating from an old FC1 OGo installation to FC5 OGo
1.1 (trunk) and I'm perplexed because I'm receiving apparently
incomplete result sets from XML-RPC search requests to the new server.

We maintain notations in person comment fields starting with 'X!' to
indicate relevant mailing lists or areas of interest. Part of a Python
XML-RPC script to assemble lists issues the following request:

result = server.person.fetch(
{
'qualifier' : "comment like '*X!*'",
'sortOrderings' : ["name","firstname"],
}
)

There's a Bryan Tucker record in our database, company_id = 1560250,
with X!P in his comment field which should match this qualifier, and
his record is returned when the script is run against the old
installation. On the new installation, however, "Bryan Tucker" is not
returned in the result set even though a number of other valid records
are indeed returned (there seem to be a large number of expected
records missing other than Bryan Tucker.) The problem is not an issue
of data migration or permissions because the qualifier can be altered
to "name like 'Tucker'" and the record in question is returned.

Based on some earlier posts, I figured perhaps the correct form of the
qualifier had changed between the two OGo versions, so I turned on
database statement logging and looked at how the XML-RPC request was
transformed into a database query.

The initial query was exactly as expected:

SELECT DISTINCT t2.company_id
FROM company_info t1, person t2
WHERE ((( LOWER(t1.comment) LIKE '%x!%' ))
AND (t2.db_status <> 'archived'))
AND ((t2.is_template_user IS NULL)
OR (t2.is_template_user = 0))
AND t2.company_id = t1.company_id

In fact, running this query, copied verbatim out of the PostgreSQL
log, directly in psql returns a big result set which does include
1560250 (Bryan Tucker).

Reading further in the PostgreSQL log, the subsequent queries retrieve
the requested information by company_id:

SELECT t1.owner_id, t1.is_private, t1.is_readonly, t1.company_id
FROM person t1
WHERE t1.company_id IN (628970,290030,617870,323180,623620, . . . )

SELECT t1.owner_id, t1.is_private, t1.is_readonly, t1.company_id
FROM person t1
WHERE t1.company_id IN (299270,324100,628970,154640,185680, . . . )

However, 1560250 does not appear in any of these statements, even
though it was returned by the first query. It seems that ogo-xmlrpcd
effectively ignores this company_id (among others.) Has it been
filtered somehow or the result set truncated? Is there a relevant
configuration setting which could explain the difference between the
two OGo installations? Incidentally, this company_id does not show up
in the results of an equivalent fetchIds() XML-RPC request either.

Any help would be greatly appreciated,

Damon

--
OpenGroupware.org XML-RPC
xmlrpc@xxxxxxxxxxxxxxxxx
http://mail.opengroupware.org/mailman/listinfo/xmlrpc



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
db.postgresql.b...    video.ffmpeg.us...    gis.qgis.devel/...    web.rdf.redland...    file-systems.oc...    recreation.rail...    systems.archos....    python.c++/2003...    lang.c--/2005-0...    multimedia.gpho...    network.unison....    editors.jedit.u...    hardware.pciids...    cms.tiki.cvs/20...    bug-tracking.ma...    java.hadoop.hba...    ietf.rsvp/2002-...    xfree86.devel/2...    qnx.openqnx.dev...    apache.labs.dev...    tex.pdftex/2008...    os.solaris.open...    user-groups.lin...    kde.koffice/200...   
Home | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation