topic Re: Destination Server received only directory string, not file on that directory. in Talend Studio

Destination Server received only directory string, not file on that directory.

raspati — Sat, 16 Nov 2024 01:07:37 GMT

Hi Team,

Basically, I have a Job who generated XML and sub-job to push XML payload with tEsbConsumer.

The XML output saved in "C:\xml\data.xml" . Then, the XML will be carried to sub-Job with trunJob. Please find the following picture.

In the sub-Job, please find the following picture:

But, in the receiver server, they only get payload in string mode (they get "

C:\xml\data.xml"). I expect, they will get the XML file in that directory not the directory string.

Is there any wrong configuration on my Schema ?

Regards,

Raspati

Re: Destination Server received only directory string, not file on that directory.

Anonymous — Thu, 12 Nov 2020 08:38:25 GMT

From your screenshot, I see you just pass the file path to child job, not the file. Try to use tFileInputXML to read the whole file as payload document, see

Regards

Shong

Re: Destination Server received only directory string, not file on that directory.

raspati — Thu, 12 Nov 2020 09:24:38 GMT

Hi @Shicong Hong

I put tfileInputXML before tMapXML.

But, I am confuse when configure tXmlMap. If I register the payload as a document on tXMLMap, then I unable to mapping from the left side to the right side.

Regards,

Raspati

Re: Destination Server received only directory string, not file on that directory.

raspati — Thu, 12 Nov 2020 14:10:10 GMT

In Parent Job, then tRunjob, then Context Param, is there any way to make the values as a document ?

Re: Destination Server received only directory string, not file on that directory.

Anonymous — Fri, 13 Nov 2020 09:24:23 GMT

if you don't need to do any other mapping, link tFileInputXML to tESBConsumer.

child job:

tFileInputXML --main-->tESBConsumer.

Re: Destination Server received only directory string, not file on that directory.

raspati — Fri, 13 Nov 2020 12:40:53 GMT

In this case, the Destination Servers require the Source Server to add some of parameters such as transaction_id, transaction_date. Please see the following:

I think, I have to add payload at the end of the line.

Regards,

Raspati

Re: Destination Server received only directory string, not file on that directory.

Anonymous — Sun, 15 Nov 2020 06:25:47 GMT

How do transaction_id, transaction_date comes from? I think you don't need a join, read the value of these two columns and store them to context variable or global variable, on tXMLMap, get the value from global variable in the expression of field.

Re: Destination Server received only directory string, not file on that directory.

raspati — Sun, 15 Nov 2020 11:33:53 GMT

Transaction_id and transaction date coming from Contexs and modified on tJavarow like the following:

tJavaRow:

String t_date = (context.transaction_date+" " ).replace("_"," ");

String t_id= "ABCD"+TalendDate.getDate("yyyyMMdd");

output_row.transaction_date = t_date;

output_row.transaction_id = t_id;

As you mentioned, I have store these two collums (transaction_id and transaction_date) on Context and get the value from the Contexts through tJavarow.

But, the problem is the destination server received only a string value of payload not a document.

Regards,

Raspati