topic Re: Salesforce TEST connection succeeds but context fails in Talend Studio

Salesforce TEST connection succeeds but context fails

elkhounds — Fri, 15 Nov 2024 23:45:31 GMT

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

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Thu, 09 Sep 2021 00:20:40 GMT

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

Re: Salesforce TEST connection succeeds but context fails

Anonymous — Thu, 09 Sep 2021 06:53:42 GMT

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

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Thu, 09 Sep 2021 16:30:15 GMT

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

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Thu, 09 Sep 2021 23:25:31 GMT

Hi Sabrina,

Have you had a chance to review my last message?

Ray

Re: Salesforce TEST connection succeeds but context fails

Anonymous — Fri, 10 Sep 2021 05:05:37 GMT

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

Re: Salesforce TEST connection succeeds but context fails

Anonymous — Fri, 10 Sep 2021 05:12:49 GMT

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

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Fri, 10 Sep 2021 16:50:52 GMT

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

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Fri, 10 Sep 2021 16:56:15 GMT

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.

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Fri, 10 Sep 2021 17:04:09 GMT

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

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Fri, 10 Sep 2021 19:58:16 GMT

Hi Sabrina,

Have you had a chance to review my last post?

Ray

Re: Salesforce TEST connection succeeds but context fails

Anonymous — Mon, 13 Sep 2021 03:13:46 GMT

Hello,

Sorry for late.

Could you please clarify in which Talend version/edition you are?

From your screenshot QA connection, the URL given in the connection uses API 39 and you are using a test Salesforce account.

Are you sure about the version and the test Salesforce account credential?

Best regards

Sabrina

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Mon, 13 Sep 2021 20:05:32 GMT

Hi Sabrina,

6.4

Yes, we are sure the test SF account credentials are correct because as noted before, the SalesforceDev1 connection for QA (using the SF test account) under metadata works fine.

Since the SalesforceDev1 connection is successful, then the SF credentials are correct right?

Do the images help in understanding what the issue is?

What else do you need to help resolve this issue?

Ray

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Mon, 13 Sep 2021 22:15:09 GMT

Hi Sabrina,

It appears you are pretty busy. Is there anyone else who has time and can help with my issue?

Thanks

Ray

Re: Salesforce TEST connection succeeds but context fails

Anonymous — Tue, 14 Sep 2021 02:08:31 GMT

Hello,

Sorry for late!

As there is time difference we are not able to respond promptly to your question. Have you already created a support case on talend support portal? In this way, our colleagues from support team will give you a remote assistance through support portal with priority.

We have added support 39.0 starting from 6.4.1.

From the error message, so far it only tell us something wrong with the login.(password, username, security token...)

Best regards

Sabrina

Re: Salesforce TEST connection succeeds but context fails

elkhounds — Tue, 14 Sep 2021 16:46:58 GMT

Hi Sabrina,

I cannot find the support portal you mentioned before:

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

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

Do I need to setup a trial for accessing the support portal? The whole process is very confusing.

Again, we have a Talend subscription and need TECHNICAL SUPPORT.

We are going around circles and no progress has been made.

Very frustrated.

Can I call someone who can help me? What is the phone#?

Ray

Re: Salesforce TEST connection succeeds but context fails

Anonymous — Wed, 15 Sep 2021 02:23:53 GMT

Hello,

Don't be frustrated. Please do this thing step by step.

Firstly, are you able to access this page:

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

Please login with your Support Portal account. Is there any issue for your support portal account? It should be given to you by your talend representative when you get the subscription solution.

Any issue about the login issue, please send an email to Community <community@talend.com> and our manager will check your valid email address and username to address your login issue immediately (I'm supposing that you are missing your support portal account).

Do you have any contact of your own talend representative? Name or email address? I will help you to get his number for you if possible.