salesforce2hadoop connector issue

[kapil9186]

Hi ,

I am new to hadoop and trying salesforce2hadoop connector as part of POC to ingest salesforce data into hadoop/HDFS.
I have performed steps as per the URL https://github.com/datadudes/salesforce2hadoop but while executing the jar command i am getting error

Exception in thread "main" [LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked out.'

Not sure if its due to the connectivity between the Hadoop box and Salesforce API or anything else.

Salesforce WSDL file has
<soap:address location="https://test.salesforce.com/services/Soap/c/38.0/0DF2C000000CaWq"/>

May you please let me know how can i overcome this issue.

Thanks
Kapil

[tmowbrey]

You need to do either: Add your IP to the Salesforce "Network Access" list Or Add your security token to the end of your password. Tyler

…

On December 17, 2016 6:09:44 PM kapil9186 ***@***.***> wrote: Hi , I am new to hadoop and trying salesforce2hadoop connector as part of POC to ingest salesforce data into hadoop/HDFS. I have performed steps as per the URL https://github.com/datadudes/salesforce2hadoop but while executing the jar command i am getting error Exception in thread "main" [LoginFault [ApiFault exceptionCode='INVALID_LOGIN' exceptionMessage='Invalid username, password, security token; or user locked out.' Not sure if its due to the connectivity between the Hadoop box and Salesforce API or anything else. Salesforce WSDL file has <soap:address location="https://test.salesforce.com/services/Soap/c/38.0/0DF2C000000CaWq"/> May you please let me know how can i overcome this issue. Thanks Kapil -- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: #14

[kapil9186]

Thanks Tyler for reply. Made the changes as suggested but still facing issue Exception in thread "main" [LoginFault [ApiFault exceptionCode='INVALID_LOGIN' exceptionMessage='Invalid username, password, security token; or user locked out.' Thanks Kapil On Sat, Dec 17, 2016 at 6:17 PM, Tyler Mowbrey <notifications@github.com> wrote:

…

You need to do either: Add your IP to the Salesforce "Network Access" list Or Add your security token to the end of your password. Tyler On December 17, 2016 6:09:44 PM kapil9186 ***@***.***> wrote: > Hi , > > I am new to hadoop and trying salesforce2hadoop connector as part of POC to > ingest salesforce data into hadoop/HDFS. > I have performed steps as per the URL > https://github.com/datadudes/salesforce2hadoop but while executing the jar > command i am getting error > > Exception in thread "main" [LoginFault [ApiFault exceptionCode='INVALID_LOGIN' > exceptionMessage='Invalid username, password, security token; or user > locked out.' > > Not sure if its due to the connectivity between the Hadoop box and > Salesforce API or anything else. > > Salesforce WSDL file has > <soap:address > location="https://test.salesforce.com/services/Soap/ c/38.0/0DF2C000000CaWq"/> > > May you please let me know how can i overcome this issue. > > Thanks > Kapil > > > > -- > You are receiving this because you are subscribed to this thread. > Reply to this email directly or view it on GitHub: > #14 — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#14 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AHwJwTydAN_nkiA2rUHlYDqUgXqp-xGfks5rJJeygaJpZM4LQB56> .

[tmowbrey]

If both of those are not working, your either using the wrong username/password or trying to login to sandbox with production credentials or production with sandbox credentials. Tyler

…

On Mon, Dec 19, 2016 at 4:28 PM, kapil9186 ***@***.***> wrote: Thanks Tyler for reply. Made the changes as suggested but still facing issue Exception in thread "main" [LoginFault [ApiFault exceptionCode='INVALID_LOGIN' exceptionMessage='Invalid username, password, security token; or user locked out.' Thanks Kapil On Sat, Dec 17, 2016 at 6:17 PM, Tyler Mowbrey ***@***.***> wrote: > You need to do either: > > Add your IP to the Salesforce "Network Access" list > > Or > > Add your security token to the end of your password. > > Tyler > > > On December 17, 2016 6:09:44 PM kapil9186 ***@***.***> > wrote: > > > Hi , > > > > I am new to hadoop and trying salesforce2hadoop connector as part of POC > to > > ingest salesforce data into hadoop/HDFS. > > I have performed steps as per the URL > > https://github.com/datadudes/salesforce2hadoop but while executing the > jar > > command i am getting error > > > > Exception in thread "main" [LoginFault [ApiFault > exceptionCode='INVALID_LOGIN' > > exceptionMessage='Invalid username, password, security token; or user > > locked out.' > > > > Not sure if its due to the connectivity between the Hadoop box and > > Salesforce API or anything else. > > > > Salesforce WSDL file has > > <soap:address > > location="https://test.salesforce.com/services/Soap/ > c/38.0/0DF2C000000CaWq"/> > > > > May you please let me know how can i overcome this issue. > > > > Thanks > > Kapil > > > > > > > > -- > > You are receiving this because you are subscribed to this thread. > > Reply to this email directly or view it on GitHub: > > #14 > > — > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub > <#14# issuecomment-267799181>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/AHwJwTydAN_ nkiA2rUHlYDqUgXqp-xGfks5rJJeygaJpZM4LQB56> > . > — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#14 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AC5CYllzBSvEdpCDW5W0l4xT7GOlZAo7ks5rJyFGgaJpZM4LQB56> .

[DonDebonair]

Thanks Tyler, for helping out! Can I suggest @kapil9186 that you first try to call/use the Salesforce API outside of this project? See if you can get that to work. Otherwise we'll be debugging a problem that might not even be inside salesforce2hadoop :)

[kapil9186]

@tmowbrey , I have verified the username and pwd loging into the stage sandbox and was able to login.

@dandydev , The SOAP API testing outside is https://test.salesforce.com/services/Soap/u/33.0 but wsdl file from stage sandbox is having https://test.salesforce.com/services/Soap/c/38.0/0DF2C000000CaWq.

Can this be a possible reason for the issue.