Salesforce TEST connection succeeds but context fails

[elkhounds]

Our Salesforce TEST connection in Studio under meta data is successful most of the time when testing it. However, when the connection is in context mode, the tSalesforceOutput component fails every time. The salesforce PROD works fine, both in meta data and in context mode.

Any suggestions how to resolve this issue is greatly appreciated.

Thanks

[elkhounds]

Its been a while since I submitted a technical question/issue. Is this the right place to submit technical questions/issues? If not, please direct me to the right place.

Ray

[Anonymous]

Hello,

It is the right place to post your technical questions on community.

As there is no remote assistance on community, we need more information to address your issue.

What's the error message are you getting when your Salesforce connection in context mode? Could you please clarify in which Talend version/edition you are?

With talend subscription solution, it is recommend that you create a support case on talend support portal for urgent issue and our colleagues from support team will help you through support cycle with priority.

Best regards

Sabrina

[elkhounds]

Hi Sabina,

Error message:

Starting job job_SFDC_TreatmentDup at 09:45 08/09/2021.

[statistics] connecting to socket on port 3577

[statistics] connected

Exception in component tSalesforceOutput_1 (job_SFDC_TreatmentDup)

java.lang.RuntimeException: IOException: [LoginFault [ApiFault exceptionCode='INVALID_LOGIN'

 exceptionMessage='Invalid username, password, security token; or user locked out.'

 extendedErrorDetails='{[0]}'

]

]

at talenddev1.job_sfdc_treatmentdup_1_6.job_SFDC_TreatmentDup.tOracleInput_1Process(job_SFDC_TreatmentDup.java:12217)

at talenddev1.job_sfdc_treatmentdup_1_6.job_SFDC_TreatmentDup.runJobInTOS(job_SFDC_TreatmentDup.java:17110)

at talenddev1.job_sfdc_treatmentdup_1_6.job_SFDC_TreatmentDup.main(job_SFDC_TreatmentDup.java:16241)

[FATAL]: talenddev1.job_sfdc_treatmentdup_1_6.job_SFDC_TreatmentDup - tSalesforceOutput_1 IOException: [LoginFault [ApiFault exceptionCode='INVALID_LOGIN'

 exceptionMessage='Invalid username, password, security token; or user locked out.'

 extendedErrorDetails='{[0]}'

]

]

6.4 version (we have a subscription)

A little confused. You indicated this the right place for submitting technical issues. But you are also saying I should create a support case on talend support portal. I cannot find this site.

Please re-direct my issue to this site and provide me the link.

Thanks

Ray

[elkhounds]

Hi Sabrina,

Have you had a chance to review my last message?

Ray

[Anonymous]

Hello,

This is a good and right place to post your issue(techinical, suggestion, design, installation, certification...etc) on community.

For talend subscription solution with priority in 24 hours, we have a support portal for talend customer.

https://login.talend.com/support-login.php

In addition to that, please check this article about:

https://community.talend.com/s/question/0D53p00007vs8eVCAQ/instructions-for-password-reset

Best regards

Sabrina

[Anonymous]

Hello,

I made a testing on V 7.3.1 and it works.

Does your login details work? Are you able to login to Salesforce via browser?

Is there any special characters in your password?

Please double check for URL, username, password and security token.

Feel free to post your issue here.

Best regards

Sabrina

[elkhounds]

Hi Sabrina,

No special characters in the password. Not sure how to login to Salesforce via browser with the QA connection creds.

Lets review. The SalesforceDev1 connection for QA under metadata works fine:

Here is the SalesforceDev1 QA connection in the SalesforceDev1 Context:

When the SalesforceDev1 Context is used in a job like here:

And the QA connection from the Context is selected to Run:

it Fails.

Only the QA connection fails. The PROD works fine.

Do you need more information from me?

Ray

[elkhounds]

Great, the images I copied did not display.

I tried using the clip icon to upload images, but the PNGs in my Pictures folder were not listed in the scrolling list , so I could not upload them. And yes, I tried several times. Very frustrated.

[elkhounds]

Hi Sabrina,

No special characters in the password. Not sure how to login to Salesforce via browser with the QA connection creds.

Lets review. The SalesforceDev1 connection for QA under metadata works fine:

 

Here is the SalesforceDev1 QA connection in the SalesforceDev1 Context:

 

When the SalesforceDev1 Context is used in a job like here:

And the QA connection from the Context is selected to Run:

 

it Fails.

Only the QA connection fails. The PROD works fine.

Do you need more information from me?

Ray