search

datadudes / salesforce2hadoop

Import Salesforce data into Hadoop HDFS in Avro format
23 stars 13 forks source link

salesforce2hadoop connector issue #14

Open kapil9186 opened 7 years ago

kapil9186 commented 7 years ago

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

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

Thanks Kapil

tmowbrey commented 7 years ago

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 notifications@github.com 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: https://github.com/datadudes/salesforce2hadoop/issues/14

kapil9186 commented 7 years ago

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 notifications@github.com 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: https://github.com/datadudes/salesforce2hadoop/issues/14

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/datadudes/salesforce2hadoop/issues/14#issuecomment-267799181, or mute the thread https://github.com/notifications/unsubscribe-auth/AHwJwTydAN_nkiA2rUHlYDqUgXqp-xGfks5rJJeygaJpZM4LQB56 .

tmowbrey commented 7 years ago

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 notifications@github.com 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 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 notifications@github.com 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: https://github.com/datadudes/salesforce2hadoop/issues/14

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/datadudes/salesforce2hadoop/issues/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 https://github.com/datadudes/salesforce2hadoop/issues/14#issuecomment-268118839, or mute the thread https://github.com/notifications/unsubscribe-auth/AC5CYllzBSvEdpCDW5W0l4xT7GOlZAo7ks5rJyFGgaJpZM4LQB56 .

DonDebonair commented 7 years ago

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 commented 7 years ago

@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.