You need to sign in to do that
Don't have an account?
how to avoid SFDC Query time out exception
####<Dec 14, 2008 3:15:22 PM EST> <Warning> <WLW> <tfsny395sql> <cgServer> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <BEA1-2C4C0F3E04707E138162> <000000> <Id=sfdcCtrl; Method=com.tf.bsg.crm.sfdcCtrl.query(); Failure=com.bea.control.ServiceControlException: <xml-fragment xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sf="urn:fault.enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><faultcode>sf:QUERY_TIMEOUT</faultcode><faultstring>QUERY_TIMEOUT: Your query request was running for too long.</faultstring><detail><sf:fault xsi:type="sf:UnexpectedErrorFault" xmlns:sf="urn:fault.enterprise.soap.sforce.com"><sf:exceptionCode xmlns:sf="urn:fault.enterprise.soap.sforce.com">QUERY_TIMEOUT</sf:exceptionCode><sf:exceptionMessage xmlns:sf="urn:fault.enterprise.soap.sforce.com">Your query request was running for too long.</sf:exceptionMessage></sf:fault></detail></xml-fragment>>
Any thoughts how to resolve this issue.
thanks
pannar
I agree its a nested query, but its just one time query which would fetch the records from opportunity records at a single shot.
Is there any solution to avoid this error? Yes, i might be getting HUGE number of records and write them into excel sheet thru java program.
I didn't want to see this exception like Connection time out, Query time out , socket exception from the web logic server.
please guide me how to get rid of this error