function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SBNSBN 

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

Satish_SFDCSatish_SFDC
What is the error message? If you could post a screenshot that would be helpful.

Regards,
Satish Kumar
SBNSBN

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

Ashish_SFDCAshish_SFDC

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

walter.stegen1.392375738625836E12walter.stegen1.392375738625836E12
was this issue solved ?  we're getting the same error, the moment we changed to our own domain SFDC name.  Not possible to do BULK loads anymore (still able to do basic insert, updates, ...) but having the same error as above 

The salesforce job could not be created: <ourdomain>.salesforce.com
pike.pullen1.395757231522142E12pike.pullen1.395757231522142E12
Was this ever resolved.  Having this same issue now.
SBNSBN
Yeah. we just restarted all the jitterbit service and  FTP servers on which the jitterbit is installed .

Did you guys registered for jitterbit data loader? try doing that before you create jobs in jitterbit