Regarding Moni issue -Jdbc to Idoc Scenario

[Former Member]

Hi Experts ,

I am working on one of the interface where my sender System is Database System (Oracle) and Receiver System is SAP ECC

we are using JDBC as Sender Channel to send Data to PI and Idoc as Receiver Channel which will Post the Idoc to ECC System (JDBC>PI>IDOC) .

Both IR and ID part is Configured and everything is working fine .

Now the Problem i am facing is in sxmb_moni . once the Test Data is triggred from the Sender System the Test Data is Passing through the Pipeline steps and i got the Success chequred Flag .

But when i check the Payload (RequestMessageMapping Level in Pipeline) i can see the payload in the below format as given below . even after mapping all the segments and nodes in Message mapping

<ACC_DOCUMENT02>

- <IDOC BEGIN="">

<E1BPACHE09 SEGMENT="" />

<E1BPACEXTC SEGMENT="" />

</IDOC>

</ACC_DOCUMENT02

Where as the actual Output should Come in the below format

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

- <ACC_DOCUMENT02>

- <IDOC BEGIN="">

- <E1BPACHE09 SEGMENT="">

<HEADER_TXT>3030/0533/000000/533</HEADER_TXT>

<COMP_CODE>1610</COMP_CODE>

<DOC_DATE>20110704</DOC_DATE>

<PSTNG_DATE>20110615</PSTNG_DATE>

<DOC_TYPE>ZD</DOC_TYPE>

<REF_DOC_NO>45834-A1</REF_DOC_NO>

</E1BPACHE09>

- <E1BPACAP09 SEGMENT="">

<ITEMNO_ACC>01</ITEMNO_ACC>

<VENDOR_NO>600040</VENDOR_NO>

<ALLOC_NMBR>3030/0533/000</ALLOC_NMBR>

<ITEM_TEXT>USD</ITEM_TEXT>

<SP_GL_IND>0</SP_GL_IND>

</E1BPACAP09>

- <E1BPACCR09 SEGMENT="">

<ITEMNO_ACC>01</ITEMNO_ACC>

<CURRENCY>USD</CURRENCY>

<AMT_DOCCUR>1545351.73</AMT_DOCCUR>

</E1BPACCR09>

- <E1BPACCR09 SEGMENT="">

<ITEMNO_ACC>01</ITEMNO_ACC>

<CURRENCY>USD</CURRENCY>

<AMT_DOCCUR>1545351.73</AMT_DOCCUR>

</E1BPACCR09>

- <E1BPACEXTC SEGMENT="">

<FIELD3 />

<FIELD4 />

</E1BPACEXTC>

</IDOC>

</ACC_DOCUMENT02>

Kindly Let me know if any one has gone through such problem and have any inputs to solve the above issue .

Help needed ..!!!

Regards,

Aziz khan

[Former Member]

Thanks for your help ..!!

[baskar_gopalakrishnan2]

I might want you to check first at JDBC sender level. GIving empty resultset or records will also show success status in jdbc side. Do the following

1) See your select statement and check whether your sql is right... Paste the select sql command in toad or some database tool and see what do you get? if you get empty records there is a possibility to have this kind of output.

2) Check your mapping fields and make sure you mapped as per requiremetn and activate it again.

3) Finally copy the output from sxmb_moni and test in the mapping tool.

[former_member181962]

Hi Aziz,

get the source payload xml from SXMB_MONI and use it in the ESR/IR mapping test tab.

If the source xml is empty, then you might want to check the select query in the JDBC side.

YOu can find the issue.

My guess is that you have something to do with the contexts.

Check how the mapping is done

Best Regards,

Ravikanth Talagana