Dufferent data in sxmbmoni and sql tables

[vishnu_pallamreddy]

Hi All

JDBC receiver adapter.

SAP sends staus as S but thats not updated in JDBC.

its updated as P.

i found S in sxmb_moni.

whats the problem?

please help me to resolve this issue

Thanks in advance

vishnu

[rajasekhar_reddy14 · Accepted solution]

may be you are checking wrong message if message delivered to DB then issue at DB end .

[vishnu_pallamreddy · Accepted solution]

Hi all,

I found the solution for issue.

Thank you all

[Muniyappan · Accepted solution]

Hi Vishnu,

if you could narrate your solution for the issue it will be helpful for others.

Regards,

Muniyappan.

[vishnu_pallamreddy · Accepted solution]

Hi Muniyappan,

Actually that is ECC side problem.

they are not sending the correct data to the Record ID field for updation of  Status Flag for Detail.

Thats the issue only.

[ambrish_mishra]

Hi Vishnu,

Check the payload at the adapter level. What is going to the DB. If S is going, then contact the third party (DB side) if they have any implicit definition for this field which makes it P.

Ambrish

[baskar_gopalakrishnan2]

>>i found S in sxmb_moni.  whats the problem?

If you see S status in sxmb_moni, then see that you have any errors in sxmb_moni in any of the pipleline steps.  If no errors and everything successful in PI and still status does not impact in table, then talk to DBA.

a) Are you updating in different schema of the db table?

b) Check with dba like autocommit not enabled on the db side?

Also you could configure

logSQLStatement  = true in the Advanced tab of the jdbc receiver just to log your query.  This might help.

You might also work with dba and come to the decision about setting transaction level in the adapter. Assume that some other application /system modify the same table too at the same time or different time.. If that's the case, you need to set transaction serializable highest isolation level.

http://help.sap.com/saphelp_srm40/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Hope that helps.

[vishnu_pallamreddy]

Hi Bhaskar,

In my structure i have Header and detail.

The status flag successfully updated for Header in JDBC as S,

but its updated as P for detail in JDBC.

Why it is doing like that?

Thanks In Advance,

vishnu pallamreddy

[ambrish_mishra]

Hi Vishnu,

Can you paste your target structure here and also the payload going into the DB at adapter level.

Ambrish