topic Re: tESBProvider_Fault on SQL ERROR in Talend Studio

tESBProvider_Fault on SQL ERROR

Anonymous — Sat, 16 Nov 2024 09:55:30 GMT

Is there a way to send a tESBProviderFault error when I have an error with the sql?

At this moment, when I have an error on the sqlinput the service stops, I want to to send an error and start again the service(or keep it working).

Re: tESBProvider_Fault on SQL ERROR

Anonymous — Wed, 12 Apr 2017 12:40:49 GMT

Hi dferre

What kind of error do you get? Can you upload a screenshot of your current job design?

Regards

Shong

Re: tESBProvider_Fault on SQL ERROR

Anonymous — Wed, 12 Apr 2017 12:54:40 GMT

Hi Shong,

Well, I am not having an error because I don't know how to do it or I don't know if it's possible with Talend.

I mean, I have to send a tESBproviderFault when having an error on my tMSSqlInput BUT when you have an error there the job stops.

This is a screenshoot from my design, the idea would be activate tESBProvider_Fault2 when "tills" had some kind of error.

Thanks for answering!

Re: tESBProvider_Fault on SQL ERROR

Pooja_kataria — Thu, 13 Apr 2017 13:28:39 GMT

Hi ,

You can try by linking oncomponentError link of tmssqlinput component to fixedflowinput component where you can give your error payload which you need to send when the fault is generated.

Connect the fixedflowinput to tesbproviderFault and by this job will not stop I guess.

Let us know If this helps.

Re: tESBProvider_Fault on SQL ERROR

Anonymous — Thu, 13 Apr 2017 16:12:15 GMT

Hi Pooja_kataria, The job still stops without sending the error through the service.

The main problem I am having at this moment is that if I want to send the tESBProviderFault, tESBProviderRequest should be working. But, if I am getting an error on the "tills", the job don't let tESBProviderRequest works and I can't send a fault error.

Example of what you suggested: As you can see, tESBProviderRequest is not started. Although I send a tESBProviderFault, I can't see the fault message at the webservice client.

On this example below I can do what I want. I let the job starts with TESBProviderRequest and when someone request the webservice it triggers to the "tills" and I can display the error. But! I would like to use the result from "tills" at the first tXML_MAP. Somehow, I would need to let tESBProviderRequest start before "tills".

Thanks for your attention.