topic Re: Return soap response or fault after insert to database in Talend Studio

Return soap response or fault after insert to database

Anonymous — Sat, 16 Nov 2024 04:22:40 GMT

Hello.

I'm new in TOS.
I created service which has few fields in request.
I managed to insert these fields to database using tXMLMap and tDBOutput.

Now what I want to do is return soap response when there is no error during inserting to database otherwise return fault message.
Which component should I use?
I cannot use triggers from tDBOutput to tESBProviderResponse

Re: Return soap response or fault after insert to database

Anonymous — Tue, 15 Oct 2019 18:10:55 GMT

Hi,

Could you please try this method? You can create a message using tRowgenerator and convert it to appropriate format before sending as either response or fault.

Please note that the number of records in tRowgenerator must be 1 instead of default value of 100.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Return soap response or fault after insert to database

Anonymous — Wed, 16 Oct 2019 07:25:12 GMT

Thanks for replay, but...
While inserting into database I get error "Violation of PRIMARY KEY constraint" and it's not recognized as SubjobError

Re: Return soap response or fault after insert to database

Anonymous — Wed, 16 Oct 2019 09:56:55 GMT

Problem was in Die on error in DBOutput.
Thank you

Re: Return soap response or fault after insert to database

Anonymous — Wed, 16 Oct 2019 10:53:09 GMT

I still have problem to get response or fault.

In case of database error, flow goes to tESBFaultProvider but I don't get any message in SoapUI as response. And I get error:

"Exception in component tESBProviderFault_1 (AddFileTaskLogging)
java.lang.RuntimeException: Send Response failed! Response already sent with current request."

Re: Return soap response or fault after insert to database

Anonymous — Wed, 16 Oct 2019 21:39:49 GMT

Hi,

It could be because your trowgnerator may have multiple records getting generated. Could you please verify whether its having default value of 100?

Please also check the below link which has been solved for similar issue.

https://community.talend.com/t5/Design-and-Development/Send-Response-failed-Response-already-sent-with-current-request/td-p/41809

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Return soap response or fault after insert to database

Anonymous — Tue, 22 Oct 2019 07:19:03 GMT

In tRowGenerator number of rows is set to 1.
I also changed All in one to true but I don't think I does make sens.
I return static response "Ok" or "Error".
One thing I've noticed is that I get sql exception immediately and after a while (probably timeout ?) I get
java.lang.RuntimeException: Send Response failed! Response already sent with current request.

Second case is more confusing:
In case of proper insert to database, flow goes to DBOutput and hang for a while, then I get Timeout exception, and flow goes to onSubjibError

Re: Return soap response or fault after insert to database

Anonymous — Tue, 22 Oct 2019 09:55:51 GMT

Everything works good on runtime.
Thanks for help