You need to sign in to do that
Don't have an account?
SBN
Jitterbit Integration with Salesforce
Hi,
I was trying to query the data from my production org in Jitter bit. I have changed the URL of my production org from" login.salesforce.com" to my company domain URL. Jitter bit now throwing some fatal error. It worked before when the URL was "login.salesforce.com".
I have also given the company domain URL in Jitter bit while connecting to salesforce. Its connecting successfully but still the query function throwing the same error.
I am using Jitter Bit basic version
Thanks
Regards,
Satish Kumar
Thanks for the reply. Here is the Failure message. This is the production org.
"hri-newyork.salesforce.com" is the domain URL given to my production org
Fatal Error Failed to run bulk query. The salesforce job could not be created: hri-newyork.salesforce.com
Cause stacktrace: com.jitterbit.integration.server.engine.bulkload.BulkLoadException: The salesforce job could not be created: hri-newyork.salesforce.com
at com.jitterbit.integration.server.engine.bulkload.rest.JobCreator.handleError(JobCreator.java:105)
at com.jitterbit.integration.server.engine.bulkload.rest.JobCreator.postRequest(JobCreator.java:96)
at com.jitterbit.integration.server.engine.bulkload.rest.JobCreator.createJob(JobCreator.java:63)
at com.jitterbit.integration.server.engine.bulkload.BulkLoadProcess.createJob(BulkLoadProcess.java:151)
at com.jitterbit.integration.server.engine.bulkload.BulkLoadProcess.run(BulkLoadProcess.java:120)
at com.jitterbit.integration.server.engine.bulkload.BulkLoadStaging.runProcess(BulkLoadStaging.java:180)
at com.jitterbit.integration.server.engine.bulkload.BulkLoadStaging.runBulkLoad(BulkLoadStaging.java:76)
at com.jitterbit.integration.server.engine.bulkload.BulkLoadSession.runBulkLoad(BulkLoadSession.java:88)
at com.jitterbit.integration.server.engine.bulkload.BulkLoadExecutor.doWork(BulkLoadExecutor.java:36)
at com.jitterbit.integration.server.engine.bulkload.BulkLoadExecutor.doWork(BulkLoadExecutor.java:20)
at org.jitterbit.integration.server.engine.SessionExecutionWrapper.run(SessionExecutionWrapper.java:29)
at com.jitterbit.integration.server.engine.bulkload.BulkLoadEngine.runBulkLoad(BulkLoadEngine.java:118)
at com.jitterbit.integration.server.implementation.webservice.bulkload.Konga_bulkload_engineSoapBindingImpl.runBulkLoad(Konga_bulkload_engineSoapBindingImpl.java:84)
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.providers.java.RPCProvider.invokeMethod(RPCProvider.java:410)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:332)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invokeService(AxisServer.java:234)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:375)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.UnknownHostException: hri-newyork.salesforce.com
at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)
at java.net.InetAddress.getAddressesFromNameService(Unknown Source)
at java.net.InetAddress.getAllByName0(Unknown Source)
at java.net.InetAddress.getAllByName(Unknown Source)
at java.net.InetAddress.getAllByName(Unknown Source)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.resolveHostname(DefaultClientConnectionOperator.java:242)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:130)
at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:149)
at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:121)
at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:561)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:415)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:820)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:941)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:919)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:910)
at com.jitterbit.integration.server.engine.bulkload.rest.Poster.post(Poster.java:38)
at com.jitterbit.integration.server.engine.bulkload.rest.Poster.post(Poster.java:29)
at com.jitterbit.integration.server.engine.bulkload.rest.JobCreator.postRequest(JobCreator.java:94)
... 40 more
Hi ,
Try using the URL as na15.salesforce.com instead of login.salesforce.com.
Here are the steps that you can follow if you are still unable to login to Data Loader:
1. Make sure you are adding security key to the end of your password to log in to Data Loader.
See the following documentation on how to "logging in to Data Loader":
https://help.salesforce.com/apex/HTViewHelpDoc?language=en&id=installing_the_data_loader.htm
2. You have to change the Server Host to point to the appropriate server in Data Loader. Here’s how to do this:
Start the Data Loader by choosing Start | Programs | salesforce.com | Data Loader | Data Loader.
Choose Settings | Settings.
Change Server Host to be https://xx.salesforce.com (where xx=whichever salesforce instance they are on i.e. na1, na2, na3...)
Click OK to save your settings
Documentation regarding Configuring the Data Loader can be found here:
https://help.salesforce.com/apex/HTViewHelpDoc?id=configuring_the_data_loader.htm&language=en_US
Also, if you are using any proxy server, please make sure to enter proxy related information under Settings in Data Loader. When they are behind a proxy server, you will see NO information about "Other Apex API" under Login History even when they try to login using Data Loader - the proxy server is preventing them to hit salesforce's servers. Ask them to enter proxy related information into Data Loader setting
Regards,
Ashish
The salesforce job could not be created: <ourdomain>.salesforce.com
Did you guys registered for jitterbit data loader? try doing that before you create jobs in jitterbit