on 07-30-2009 7:26 PM
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.
Hey
Can you please check the payload in RWB->Message monitoring (make sure you are checking for the receiver side)
Thanks
Aamir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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>
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
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.
Hi,
I beleive you dont need to mention occurence in recordstructure.
Recordset structure : row,1
should be
Recordset structure : row
Thanks
Inder
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.