JDBC Sender adapter is reading but then there isn't the message in SXMB_MON

[Former Member]

Hi,

I have a JDBC to RFC async scenario. All configured.

Now the JDBC Sender adapter is reading the database table and if I go to communication channel monitoring ther is a "Processing finished succefully" message and an message ID like that: "0e4fd3b0acba11ddb65e0002a5adffd2".

But then I go to SXMB_MONI or message monitoring in RWB and there isn't a message to check...

What's happening? How can I know what the JDBC adapter has read and why there isn't an error but there isn't a message?

[Former Member]

Hi,

Chech this discussion

Regards

Seshagiri

[prateek]

Check if message is present in smq1. If you could see the details of message by clicking it at Component Monitoring, then check for the error inside it.

In message monitoring, check for complete Integration Server option.

Regards,

Prateek

[Former Member]

There isn't messages in SMQ1

And I can't click the message ID in the communication channel monitoring, it's just "text", not a link.

I checked the statement and it's OK too.

[prateek]

Check whether ur adpater channel is locked - SAP Note 1083488.

Regards,

Prateek

[Former Member]

Hi

Well u r that means no polling happening with u r Select statement

may be format is correct i agree ,,can u able to get resultset using the Select staement running on SQL PLus ??

check wether status flag is set right

paste u r slect statement and update statement

rgds

srini

[Former Member]

Hi

CLick on the message id , r u seeing the payload there

check in u r Database where that Sebder JDBC Adapter Update statement has been complete.

seems to be there is no matching to u r Select statement entere4d in Adapter

Run the Select statement in u r SQL PLus

rgds

srini