Data Mismatch in SXMB_MONI & ABAP Program.

[former_member644654]

Hi All,

I've a RFC to JDBC scenario. When I'm executing the program in the R3 server it showing me the correct value of a field retrieved from a FM but when I'm checking the entries for the same program in MONI, I'm finding that the data is wrong i.e. a field of length 22 chars is showing only 1 character.

1) I've re-imported the RFC.

2) Did the Mapping again.

3) Activated the whole interface.

4) Done Cache Refresh.

But still I'm getting the same error.

Is there anything else I need to do get the correct data.

Thanks in Advance

Sreedhar

[former_member644654]

I've used wrong sequence of fields in the prgram which I'd to correct.

Now the problem is resolved.

Edited by: Sreedhar Av on Nov 5, 2009 8:47 AM

[Former Member]

Hi,

Pls check the maximum length of the filed in your Function Module structure.

Thanks,

sateesh

[Former Member]

Hi,

Try doing a cache refresh of Integration builder and runtime. Make sure its happening.

Regards

vijaya

[former_member644654]

Hi,

Now I'm getting a new error like this:

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TABLE_X_TXN_SP_PROPS' (structure 'INSERT_DATA'): java.sql.SQLException: ORA-00917: missing comma

Now is there any method to correct this error.

Sreedhar

[Former Member]

Hi Sreedhar,

Can you provide us a sample target msg (JDBC) you are sending to the DB?

Have a look at the structure format for the receiver JDBC from the below link and make sure that your target structure conforms the expected JDBC structure : http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Pooja

[Former Member]

I hope this is not because of Data Type mismatch in your RFC program. Please check that.

Regards,

Sarvesh

[Former Member]

Hi,

This kaind of error only will occure because of message mapping.

re-check message mapping.

Thanks

Sivaram

[former_member644654]

Hi,

I've also done that but the error is same. Is there any other option to rectify that error?

Sreedhar

[former_member200962]

What is the payload showing for the RFC channel in RWB?

[former_member644654]

Hi Abhishek,

There is know payload generated in RWB, and there is a error while message monitoring i.e. System Error.

My scenario is Synchronous.

Sreedhar.