search

theswamis / dataloadercliq

Command Line Interface Quickstart
12 stars 5 forks source link

unable to login #41

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What version of the product are you using? On what operating system?
i am using dataloader 23.0 and CLIq 2.1. OS is win-XP

Please provide any additional information below.
after entering the credentials and clicked the verify button ... i am unable to 
get the login result..you can see the attached image.....

Original issue reported on code.google.com by kiranmutturu on 12 Nov 2011 at 5:35

Attachments:

GoogleCodeExporter commented 9 years ago 
Thanks - I will look into this.

Original comment by vijay.swamidass@gmail.com on 12 Nov 2011 at 5:57

GoogleCodeExporter commented 9 years ago 
In the console, you should see some log lines and perhaps an error message.  
Can you copy and paste the log here?

Original comment by vijay.swamidass@gmail.com on 12 Nov 2011 at 6:07

GoogleCodeExporter commented 9 years ago 
Sorry - to get the debug logging, you need to start cliq with "-d" parameter.

1. Open a command prompt
2. Change to the dataloader cliq directory.
3. Run this command:
cliq.bat -d

Original comment by vijay.swamidass@gmail.com on 12 Nov 2011 at 6:23

GoogleCodeExporter commented 9 years ago 
Please use the attached version and use the "-d" command line option.
This version has more debugging info.

I am still not able to reproduce this problem, so anything you can do to help 
is appreciated.

Thanks,
Vijay

Original comment by vijay.swamidass@gmail.com on 12 Nov 2011 at 6:48

Attachments:

GoogleCodeExporter commented 9 years ago 
Hi sir, 
    Thanks for the response. I tried what u stated above and find the attached result file. I am getting the below error: 
Failed to send request to http://www.salesforce.com/services/Soap/u/23.0

Original comment by kiranmutturu on 13 Nov 2011 at 4:15

Attachments:

GoogleCodeExporter commented 9 years ago 
Below information is the debug log i am getting ...

Failed to send request to http://www.salesforce.com/services/Slog: 
Session Id: null
log: Logging in to salesforce as kiranmutturu@in.pwc.com
log: Connection exception: java.net.UnknownHostException: www.salesforce.com
log: Exception during login: Failed to send request to http://www.salesforce.com
/services/Soap/u/23.0

Original comment by kiranmutturu on 13 Nov 2011 at 4:20

GoogleCodeExporter commented 9 years ago 
Interesting - are you able to access 
http://www.salesforce.com/services/Soap/u/23.0 from a browser on that system?

Original comment by vijay.swamidass@gmail.com on 13 Nov 2011 at 4:43

GoogleCodeExporter commented 9 years ago 
Kiran,

Use https://www.salesforce.com/services/Soap/u/23.0 

https: not http:

Original comment by akashche...@gmail.com on 13 Nov 2011 at 10:03

GoogleCodeExporter commented 9 years ago 
hi sir, could you please guide me in one scenario and i.e.
I have a database oracle10g and in that I had some tables called account, 
contact and opportunities. Every month I need to get the data from those tables 
and upsert in to salesforce objects. So i thought of implementing this using 
ApexDataloader CLI. IS this possible with Apex DataLoader. Is it possible to 
connect multiple source tables from the dataloader in a single request?

and coming to our issue41 i am getting the error as 405 GET not supported
when i am using this in a browser

Original comment by kiranmutturu on 13 Nov 2011 at 1:22

GoogleCodeExporter commented 9 years ago 
Kiran,

was that connectivity issue resolved??

Original comment by amumman...@appirio.com on 13 Nov 2011 at 10:39

GoogleCodeExporter commented 9 years ago 
Kiran,

you can extract the data and place it in this folder every month and run the 
.bat file. But you need to generate .bat file for each individual object( 
Accounts, Contacts etc...). You can't schedule it directly using CLIQ to run 
run automatically on specified date every month. I believe you need to use 
windows schedule to do it.  I don't think you can schedule the job in such a 
way it extracts data from Oracle table automatically and load it into 
Salesforce as an automated process using CLIQ.

Original comment by amumman...@appirio.com on 13 Nov 2011 at 11:03

GoogleCodeExporter commented 9 years ago 
no sir not yet i am getting the error as 405 GET not supported
when i am using https://www.salesforce.com/services/Soap/u/23.0  in a browser

Original comment by kiranmutturu on 14 Nov 2011 at 2:58

GoogleCodeExporter commented 9 years ago 
Kiran,

Replace cliq.properties file in the your Cliq folder with the file attached in 
this email and try it. The URL will not open in the browser. That is the URL 
that needs to be used in your properties file as an end point URL.
Please let me know if you have any questions.

Original comment by amumman...@appirio.com on 14 Nov 2011 at 4:58

Attachments:

GoogleCodeExporter commented 9 years ago 
even now also i am getting the same response Failed to send request to 
https://www.salesforce.com/services/Soap/u/23.0

and i tried to login in to native apex dataloader ...but i am getting the same 
response when i logged in to apex dataloader 23.0

Original comment by kiranmutturu on 14 Nov 2011 at 5:37

GoogleCodeExporter commented 9 years ago 
please find the below screen shot...

Original comment by kiranmutturu on 14 Nov 2011 at 5:39

Attachments:

GoogleCodeExporter commented 9 years ago 
now i added the proxy settings also .. and now i am able to login in to the 
native apex dataloader23.0

Original comment by kiranmutturu on 14 Nov 2011 at 6:12

GoogleCodeExporter commented 9 years ago 
hurry... its all because of proxy that is stopping in the backend..

Original comment by kiranmutturu on 14 Nov 2011 at 6:17

GoogleCodeExporter commented 9 years ago 
You need to add the proxy settings to the cliq.properties file.

Original comment by vijay.swamidass@gmail.com on 14 Nov 2011 at 6:23

GoogleCodeExporter commented 9 years ago 
i am unable to upload contacts in to salesforce based on accounts.
what I done is...i created a external field in account and contact. i inserted 
the account csv. Then I am struggling while inserting the contacts.. i had the 
same external field in the contacts also ..but it is saying duplicate 
externalid.. but i may have multiple contacts to one account right? please help 
me out in this.. thank you

Original comment by kiranmutturu on 14 Nov 2011 at 1:48

GoogleCodeExporter commented 9 years ago 
Hi Kiran,
Please post your question about external ids in the discussion board.  This 
area should be for solving the login issue.

Thanks,
Vijay

Original comment by vijay.swamidass@gmail.com on 14 Nov 2011 at 5:54

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Hi Vijay

Thanks for the quick response - I'm using Apex Data Loader v23 on Windows 7 
Professional.

The debug trace follows;

C:\Program Files\salesforce.com\Apex Data Loader 23.0\cliq>cliq.bat -d
Salesforce Data Loader Command Line Interface Quickstart (CLIq)
===============================================================
 .oOOOo.  o       ooOoOOo
.O     o  O          O
o         o          o
o         o          O
o         O          o    .oOoO'
O         O          O    O   o
`o     .o o     .    O    o   O
 `OoooO'  OOoOooO ooOOoOo `OoOo
                              O
                              `o
===============================================================
You can download the latest version of CLIq at:
http://code.google.com/p/dataloadercliq/
Enabling debug mode.
Loading GUI...
log: Session Id: null
log: Logging in to salesforce as jhilditch@gsr.com.au
[UnexpectedErrorFault [ApiFault  exceptionCode='UNSUPPORTED_CLIENT'
 exceptionMessage='HTTPS Required'
]
]

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627)
        at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504)
        at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:229)
        at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:203)
        at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:14
9)
        at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98)
        at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:39)
        at com.sforce.soap.partner.PartnerConnection.<init>(PartnerConnection.ja
va:11)
        at com.salesforce.cliq.cliconfig.CliConfig.doSalesforceLogin(Unknown Sou
rce)
        at com.salesforce.cliq.ui.LoginPanelDescriptor.actionPerformed(Unknown S
ource)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:18
49)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:234)
        at java.awt.Component.processMouseEvent(Component.java:5488)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
        at java.awt.Component.processEvent(Component.java:5253)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3955)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3803)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212
)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)

        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1774)
        at java.awt.Component.dispatchEvent(Component.java:3803)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:163)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:153)
        at java.awt.Dialog$1.run(Dialog.java:515)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)

        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
log: Connection exception: null
[UnexpectedErrorFault [ApiFault  exceptionCode='UNSUPPORTED_CLIENT'
 exceptionMessage='HTTPS Required'
]
]

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627)
        at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504)
        at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:229)
        at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:203)
        at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:14
9)
        at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98)
        at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:39)
        at com.sforce.soap.partner.PartnerConnection.<init>(PartnerConnection.ja
va:11)
        at com.salesforce.cliq.cliconfig.CliConfig.doSalesforceLogin(Unknown Sou
rce)
        at com.salesforce.cliq.ui.LoginPanelDescriptor.actionPerformed(Unknown S
ource)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:18
49)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2169)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:234)
        at java.awt.Component.processMouseEvent(Component.java:5488)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
        at java.awt.Component.processEvent(Component.java:5253)
        at java.awt.Container.processEvent(Container.java:1966)
        at java.awt.Component.dispatchEventImpl(Component.java:3955)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3803)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212
)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)

        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1774)
        at java.awt.Component.dispatchEvent(Component.java:3803)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:163)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:153)
        at java.awt.Dialog$1.run(Dialog.java:515)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)

        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
log: Exception during login: null
log: Session Id: null

Hope this helps....

Kind Regards

Jim

Original comment by adelaide...@gmail.com on 16 Nov 2011 at 12:16

GoogleCodeExporter commented 9 years ago 
Thanks, that is helpful.

Try putting this line in your cliq.properties file:
sfdc.endpoint=https://www.salesforce.com/services/Soap/u/23.0

That should force it to use HTTPS.  Let me know what happens.

Original comment by vijay.swamidass@gmail.com on 16 Nov 2011 at 1:38

GoogleCodeExporter commented 9 years ago 
This should be fixed now in the 2.1.1 version of CLIq.
The default endpoint used http, and orgs which required https were rejecting 
the connection.  I have now updated the default endpoint to use https.

Original comment by vijay.swamidass@gmail.com on 16 Nov 2011 at 7:27

GoogleCodeExporter commented 9 years ago 
by giving the proxy i am able to loginthru the data loader, but unable to login 
through the cliq with the same proxy.

Original comment by indira.d...@gmail.com on 21 Nov 2011 at 4:07

Attachments:

GoogleCodeExporter commented 9 years ago 
Indira,
Are you using CLIq 2.1.1?
Please start CLIq with the -d option and post the console results.

Original comment by vijay.swamidass@gmail.com on 21 Nov 2011 at 6:22

GoogleCodeExporter commented 9 years ago 
Hi all I am experiencing the same issue :
proxy setting entered, they work just fine
once asked to enter the password and login it fails.
I tried to enter simple login and password as well as login and 
password+security token.
the error message is still the same:

"Failed to send request to https://www.salesforce.com/services/Soap/u/23.0"

any suggestion?
thank you in the meantime
Valentina

Original comment by valentin...@gmail.com on 23 Nov 2011 at 3:52

GoogleCodeExporter commented 9 years ago 
Valentina,
Can you start CLIq with the -d option and post the console results to the 
discussion board?
Thanks.

Original comment by vijay.swamidass@gmail.com on 23 Nov 2011 at 6:51

GoogleCodeExporter commented 9 years ago 
Hi again Vijay,

As Valentina, I'm experiencing the same problem after modifying the 
correspondent line on the CLIq properties that you mention above as solution.

I attached the related log from the console.

I hope it has a simple solution. 

Note: I'm already using CLIq 2.1.1 and Data Loader 23

Regards,

MGA

Original comment by spavilad...@gmail.com on 30 Nov 2011 at 8:27

Attachments:

GoogleCodeExporter commented 9 years ago 
Hi Vijay,

Another finding, in my process-conf.xml I have this line:

<entry key="sfdc.endpoint" 
value="https://test.salesforce.com/services/Soap/u/23.0"/>

Note that is not www.salesforce.com is test.salesforce.com This extract is from 
a config file which is working smoothly right now.

I don't know if this helps or distracts, anyways, I thought might be of your 
interest.

Thanks for your help,

MGA

Original comment by spavilad...@gmail.com on 30 Nov 2011 at 8:52

GoogleCodeExporter commented 9 years ago 
MGA,
Did you put https://test.salesforce.com/services/Soap/u/23.0 as the endpoint in 
your cliq.properties?  It looks like you did not.

Vijay

Original comment by vijay.swamidass@gmail.com on 30 Nov 2011 at 7:09

GoogleCodeExporter commented 9 years ago 
If you are experiencing login problems, please open a new issue.  This one is 
getting too long and the original problem has been fixed.
Thanks.

Original comment by vijay.swamidass@gmail.com on 30 Nov 2011 at 7:12