Hi Sameer,
As per my understanding there are no limits for fetching records through web services using getlist method, make sure that your form search is not limited for searching. There are no limitations on publishing web service in OOTB forms and as Chintan mentioned we should be very specific about the search qualification. Regards, Prasanth From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chintan Shah Sent: Wednesday, October 12, 2011 9:15 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service getlist can not fetech more than 700 records and give request time out ** Hi Sameer, As far as I know, there is none..in your web-service designer you can specify the # of records to be retrieved. I generally keep it to 1000 or less. Usually you want to keep the qualification very specific and make sure that it does not return a large data set or if it does then # of attributes that you are returning should be kept less otherwise you see will a large SOAP envelope returning back. I had seen issues in past where retrieving more than over 5K records with bad qualification hung the midtier (and errors registered were similar to what you are seeing below...cant recall but I have even seen out of memory)..although these does depend on your JVM settings on tomcat. As far as writing web-service on join form, I have not tried that..but make sure you have a good qualification and fields used in qualification are indexed. Thanks. Chintan. ________________________________ From: Sam The Dam <sameer.inam...@wipro.com> To: arslist@ARSLIST.ORG Sent: Wednesday, October 12, 2011 5:36 AM Subject: Web Service getlist can not fetech more than 700 records and give request time out ** Hi All, I have published web service using gelist. But when I try to consume this web service I can fetch only 500 records. I found a BMC KB KA299205 and set the 'Proxy Server Settings for Java VM' value to -Xms512m -Xmx1024m and now able to fetch 700 records. However if I try to fetch more than 700 records using this web service I get request time out. I have written this web service on a custom form which is a join form of HPD:Help desk Wed Oct 12 06:24:34 GMT 2011:ERROR:Exception in request: java.net <http://java.net.So> .SocketTimeoutException: Read timed out Wed Oct 12 06:24:34 GMT 2011:ERROR:An error occured [Read timed out], see error log for details Wed Oct 12 06:24:35 GMT 2011:INFO:Error getting response for [PortSoapBinding.GetList:Request 1]; java.net.SocketTimeoutException: Read timed out Is there any limit on number of records that one can fetch by consuming a web service which is using getlist? Also is there any restriction on publishing web service on OOTB forms? Regards, Sameer Inamdar Wipro Technologies Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ Think green - keep it on the screen. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
