|
|
Choosing A Webhost: |
limitation on XML-RPC result size? experiencing incomplete result sets: msg#00005cms.opengroupware.xmlrpc.devel
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> |
|---|---|---|
| Previous by Date: | Re: Resources and appointments, Helge Hess |
|---|---|
| Next by Date: | Re: limitation on XML-RPC result size? experiencing incomplete result sets, adam |
| Previous by Thread: | Re: Resources and appointments, Adam Williams |
| Next by Thread: | Re: limitation on XML-RPC result size? experiencing incomplete result sets, adam |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive 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 |