cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC to File Scenario

Former Member
0 Kudos

Hey Experts,

I have a scenario from JDBC to File (xml) scenario.

The problem is that the data is being picked up from the data base and is sent through the sender JDBC channel to the receiver file adapter channel where the file content conversion is done. But when I check the output text file, it is empty. When I go to SXMB_MONI to check if there is any error, every thing is fine with a checkered flag on the message. My sender and the receiver data types are the same.

Here is the scenario:

DT_sender and DT_receiver ---> row

NAME

ID

GRADE

payload from the sender channel is:

<MT_DB2FILE_SENDER>

< row>

<NAME>CNCN</NAME>

<ID>222</ID>

<GRADE>A</GRADE>

</MT_DB2FILE_SENDER>

When the content conversion is done with the parameters :

Recordset structure : row,1

row.fieldNames : NAME,ID,GRADE

row.fieldSeparator : \t

row.endSeparator: 'nl'

The text file that is generated is empty. I have tried out all the posts that are related to this topic. But I could not find the suitable answer. ANy help would be greatly appreciated.

Regards.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hey

Can you please check the payload in RWB->Message monitoring (make sure you are checking for the receiver side)

Thanks

Aamir

Former Member
0 Kudos

Hi,

How do you do that Aamir?

On the message monitoring in the RWB where do you check for the payload on the receiver side?

Inder ---> I tried without the occurence from the recordset structure.

But with the same result.

Former Member
0 Kudos

Hey

In RWB Go to Message monitoring(select adapter engine from drop down menu),select your message and hit the "Details" button,then go to "Message Content" tab and see the payload from the drop-down menu

Thanks

Aamir

Former Member
0 Kudos

Hey Aamir,

There is no Mesage Content tab in the details window. I see only message data.

Regards.

Former Member
0 Kudos

Hey

Can you please make sure that you have set the correct filter in Message monitoring.

For "Messages for Component" Select Adapter Engine and for "From" select DataBase

Do you see three tabs now when you hit "Details".they should be "Message data","Message Content" and "Audit Log"?

Thanks

Aamir

Former Member
0 Kudos

Hi,

Go to SXMB_MONI, open your message, Look at the left box : Under technical touting --> click payload --> click main Document . you will be able to see the payload in adjacent window.

Just copy that payload data to SDN, then it will be easier for everyone to help you. if there is no payload, check ur mapping.

Thanks

Inder

Former Member
0 Kudos

This is the payload on the Message Content tab.

<?xml version="1.0" encoding="UTF-8" ?>

<ns0:MT_DB2FILE_RECEIVER xmlns:ns0="http://jdbc2jdbc" />

I don't see the data.

Former Member
0 Kudos

It shows that your mapping is not producing correct output. Check ur mapping. in Message mapping, click on test tab and test mapping.

Thanks

Inder

Former Member
0 Kudos

Hey Inder,

[Test_Mapping|http://img181.imageshack.us/img181/8596/testmapping.jpg]

Here is the screen shot for the mapping.

I tested it. It is working fine. Do I need to use any functions?

Regards.

Former Member
0 Kudos

Hey

Could you please paste the payload from

In sxmb_moni go to your message->Technical routing->Payload->main document.

The bottom window will be your payload.

Thanks

Aamir

Former Member
0 Kudos

Hi,

your mapping seems to be fine. Test interface mapping also.

follow these step

Go to SXMB_MONI, open your message, Look at the left box : Under technical touting --> click payload --> click main Document . you will be able to see the payload in adjacent window.

Paste that payload. it will tell us what data you are sending to receiver adapter.

Regards

inder

Former Member
0 Kudos

This is the payload.

<?xml version="1.0" encoding="utf-8" ?>

- <MT_DB2FILE_SENDER>

- <row>

<NAME>CHAD</NAME>

<ID>204</ID>

<GRADE>A</GRADE>

</row>

- <row>

<NAME>TYLER</NAME>

<ID>204</ID>

<GRADE>A</GRADE>

</row>

- <row>

<NAME>AMER</NAME>

<ID>204</ID>

<GRADE>A</GRADE>

</row>

- <row>

<NAME>BASHIR</NAME>

<ID>204</ID>

<GRADE>A</GRADE>

</row>

- <row>

<NAME>WENBIN</NAME>

<ID>206</ID>

<GRADE>A</GRADE>

</row>

- <row>

<NAME>lilian</NAME>

<ID>139</ID>

<GRADE>A</GRADE>

</row>

</MT_DB2FILE_SENDER>

Former Member
0 Kudos

Hey

I m a little confused here

In your earlier reply,you posted


<?xml version="1.0" encoding="UTF-8" ?>
<ns0:MT_DB2FILE_RECEIVER xmlns:ns0="http://jdbc2jdbc" /> 

and now you are posting this


<?xml version="1.0" encoding="utf-8" ?>
- <MT_DB2FILE_SENDER>
- <row>
<NAME>CHAD</NAME>
<ID>204</ID>
<GRADE>A</GRADE>
</row>
- <row>
<NAME>TYLER</NAME>
<ID>204</ID>
<GRADE>A</GRADE>
</row>
- <row>
<NAME>AMER</NAME>
<ID>204</ID>
<GRADE>A</GRADE>
</row>
- <row>
<NAME>BASHIR</NAME>
<ID>204</ID>
<GRADE>A</GRADE>
</row>
- <row>
<NAME>WENBIN</NAME>
<ID>206</ID>
<GRADE>A</GRADE>
</row>
- <row>
<NAME>lilian</NAME>
<ID>139</ID>
<GRADE>A</GRADE>
</row>
</MT_DB2FILE_SENDER>

The above looks like a sender structure to me.

Could you please confirm this is exactly the payload you are getting in sxmb_moni under Technical routing .

Thanks

Aamir

Former Member
0 Kudos

Hi Aamir,

This is definately the payload of sender side. look at the message type in screenshot and payload.

Thanks.

Former Member
0 Kudos

Sorry guys,

This is what I have from the transaction SXMB_MONI.

Which payload are you guys talking about? Probably I am not understanding what you are talking about.

I pasted the payload under the Receiver Grouping MainDocument(application/xml).

Just look at this screen shot and please let me know.

[SXMBMONI|http://img220.imageshack.us/img220/3014/sxmbmoni.jpg]

Regards.

Former Member
0 Kudos

Hi,

There is problem in your configuration. your mapping is not getting executed.

are you able to see your interface mapping in Interface determination ?

regards

Inder

Former Member
0 Kudos

Hey Inder,

I have done the test configuration on the scenario with the payload generated from the interface mapping done in the integration repository.

Here is the screen shot.

[IDnMapping|http://img118.imageshack.us/img118/3927/62361947.jpg]

Please help me out.

Reagrds.

Former Member
0 Kudos

Hi,

ur interface seems to be working fine. You are unable to see all the pipeline steps in SXMB_MONI as nay be trace level is set to low. (not related to ur problem)

Can you copy that payload in screenshot in sdn ? i will try it out on my server.

Thanks

Former Member
0 Kudos

Hey Inder,

This is the payload.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_DB2FILE_RECEIVER xmlns:ns0="http://jdbc2jdbc">

<row>

<ID>222</ID>

<NAME>chad</NAME>

<GRADE>a</GRADE>

</row>

<row>

<ID>123</ID>

<NAME>vera</NAME>

<GRADE>a</GRADE>

</row>

</ns0:MT_DB2FILE_RECEIVER>

Regards.

Former Member
0 Kudos

Hi,

I justed tested it, write like this. you will be able to find all your data. you can always enhance it according to your requirement.

Recordset Structure : row

row.fieldSeparator: ,

row.endSeparator: 'nl'

no need to specify each field name as of now.

Best of luck

Inder

Former Member
0 Kudos

Hey Inder,

Got it solved. Thanks for the help.

It is working now.

Yippeee!!!!

Thank you very much for the help.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I beleive you dont need to mention occurence in recordstructure.

Recordset structure : row,1

should be

Recordset structure : row

Thanks

Inder