Web service not working when deployed to ESB server, runs fine locally..

[Anonymous]

Hi all,

I've created a fairly simple web service job, which runs perfectly locally. I'm having some issues when deploying this to our ESB server. 

This job should only connect to our salesforce organization, run a SOQL query (which only returns 1 result), and return a 200 response code. I'm not even trying to do any mappings yet.

I'm getting error messages when I'm trying to hit this endpoint using postman, the first time I send a request I get;

and every time thereafter I get;

I've added an additional route that just returns "hello world" which works perfectly from the ESB server. The Salesforce component seems to be causing an issue, If I remove the salesforce component, then it successfully hits the response component

tJava_2 is empty placeholder so I can connect the Salesforce component

Any ideas would be great as I'm very quickly running out of things to try. I'm currently using Talend Open Studio 7.2.1

[Anonymous]

@TRF you use Salesforce a lot more than I do. Have you ever seen the error or similar before?

[TRF]

@rhall no, I have never seen this before with this version or an other.

@Mivox it seems you have tried a tSalesforceConnection -> tSalesforceInput -> tLogRow process but your post shows a compilation error.

Did you solve this error?

Did you try to run this job within the Studio (not called by your service)?

Does it work?

Does it work from the command line as an autonomous job?

If nothing works I suggest you to reinstall the Studio.

Be careful when extracting the archive if you use winrar you may have errors due to filenames exceeding 260 characters. I saw it with Talend-Studio-20190620_1446-V7.2.1.zip archive and have been forced to fixe the winrar problem before to restart the installation process.

Everything works fine within the Studio and when deployed to runtime.

[Anonymous]

Hi @TRF 

it seems you have tried a tSalesforceConnection -> tSalesforceInput -> tLogRow process but your post shows a compilation error.

Did you solve this error?

Nope, the job compiles and runs but when I hit the endpoint, the response is the error message above (Unresolved compilation problems: ...)

and due to it requiring me to restart my machine (detailed a few posts up), I only attempted this twice.

Did you try to run this job within the Studio (not called by your service)?

Yes, the job (tSalesforceConnection -> tSalesforceInput -> tLogRow) can be run independantly and runs fine.

Does it work from the command line as an autonomous job?

I'm not sure how to try this

The way that I am deploying the job to the ESB server is that I am publishing it from Talend Open Studio to our Nexus, and then creating and deploying the service within the TAC. I've deployed many similar jobs this way but this is the first time I've tried it on 7.2.1 (we're on the evaluation license currently).

Thanks for your help/suggestions

I'm no longer at work so I'll be picking this up in the morning!

[Anonymous · Accepted solution]

Hi All,

A member of the Talend Support team provided me with Patch_20191028_TPS-3478_v1-7.2.1 for Talend Open Studio and this resolved all of the issues above after re-publishing and re-deploying the job.

I'm not sure exactly what the issue was, but they referenced TESB-26293 (which I cant see on jira.talendforge.org).

@rhall The Jira ticket you opened might need closing

Thanks to everyone for your help and suggestions!