I was able to retrieve all records from Lead object earlier(with 80k) . But now, my lead size grown upto 500k records. I'm getting the following error. Your help is very much a apprectiated
My code snippet:
....
....
try { String sql="SELECT "+<<all_columns_from_lead_object>>+" FROM Lead" QueryResult queryResult = binding.bind().query(sql); while (true) { SObject[] sObjs = queryResult.getRecords(); if (sObjs==null || sObjs.length==0) { break; } //Begin: retrieving sObjs and storing into csvfile && our biz logic here.. ... ... ... //End: retrieving sObjs and storing into csvfile && our biz logic here.. if (queryResult.isDone()) { break; } else { queryResult = binding.bind().queryMore(queryResult.getQueryLocator()); } } }catch (Exception e) { the_log.error(e); }
INVALID_QUERY_LOCATOR: invalid query locator at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at java.lang.Class.newInstance0(Unknown Source) at java.lang.Class.newInstance(Unknown Source) at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:104) at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:90) at com.sforce.soap.partner.fault.InvalidQueryLocatorFault.getDeserializer(InvalidQueryLocatorFault.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized(BaseDeserializerFactory.java:154) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs(BaseDeserializerFactory.java:84) at org.apache.axis.encoding.DeserializationContext.getDeserializer(DeserializationContext.java:464) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType(DeserializationContext.java:547) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild(SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(Unknown Source) at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227) at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696) at org.apache.axis.Message.getSOAPEnvelope(Message.java:435) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206) at org.apache.axis.client.Call.invokeEngine(Call.java:2812) at org.apache.axis.client.Call.invoke(Call.java:2795) at org.apache.axis.client.Call.invoke(Call.java:2461) at org.apache.axis.client.Call.invoke(Call.java:2384) at org.apache.axis.client.Call.invoke(Call.java:1830) at com.sforce.soap.partner.SoapBindingStub.queryMore(SoapBindingStub.java:1743) at responsys.sf2ri.model.bo.SFCampaignMemberBO.selectSfDataAsCSVFile(SFCampaignMemberBO.java:915) at responsys.sf2ri.model.bo.RIEtlBO.mergeDataIntoSfLeadOrContactTableForAutomationJob(RIEtlBO.java:2528) at responsys.sf2ri.model.bo.Sf2RiAutomationWorker.uploadSfContactsNLeadsDataForAutomationJob(Sf2RiAutomationWorker.java:2137) at responsys.sf2ri.model.bo.Sf2RiAutomationWorker.transferAllLeadsNContacts(Sf2RiAutomationWorker.java:238) at responsys.sf2ri.model.bo.Sf2RiAutomationWorker.run(Sf2RiAutomationWorker.java:2459) at java.lang.Thread.run(Unknown Source)
I'm getting the exception.PASSWORD_LOCKOUT. This makes sense, as tried with wrong password for multiple times.
Docs says PASSWORD_LOCKOUT ==> The user has exceeded the allowed number of login attempts. The user must contact his or her administrator to regain login access.
I want to know
What is the lockout period
What is the max login failures can I attempt? i.e. How many unsuccessfull login attempts can i do, before the account is locked out.
How can i clear the lockout.
I'm developing automation(background) process,
which logs into salesfroce and my application. Retrieve date from sf objects (i.e. leads, contacts, owners, campaignmember etc...) and transfer into my application.
This is a recursive process, and runs every hourly/daily/weekly/monthly manner based on user input in my application.
I'm integrating salesforce with one of our apps. I enter into our app using custom link, which is defined in the salesforce. My custom link looks like....
I'm getting the exception.PASSWORD_LOCKOUT. This makes sense, as tried with wrong password for multiple times.
Docs says PASSWORD_LOCKOUT ==> The user has exceeded the allowed number of login attempts. The user must contact his or her administrator to regain login access.
I want to know
What is the lockout period
What is the max login failures can I attempt? i.e. How many unsuccessfull login attempts can i do, before the account is locked out.
How can i clear the lockout.
I'm developing automation(background) process,
which logs into salesfroce and my application. Retrieve date from sf objects (i.e. leads, contacts, owners, campaignmember etc...) and transfer into my application.
This is a recursive process, and runs every hourly/daily/weekly/monthly manner based on user input in my application.
I'm integrating salesforce with one of our apps. I enter into our app using custom link, which is defined in the salesforce. My custom link looks like....
