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 <[email protected]> To: [email protected] 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.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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
