jdbc scenario .. where to find the error msg

[Former Member]

Hi,

I am working on a scenario,

abap proxy->jdbc adapter->MsSql server.

Whle testing,

i sent the payload xml from the sproxy test sceen.

After that, i checked the "Monitor for processed xml messages" screen (SXI_MONITOR).

There it shows the status "Processed successfully" for the message that i sent.

But when i checked the sqlserver database, the record is not inserted.

Where can i find, if anything gone wrong at Jdbc adapter, or there after.

Thanks in advance,

Ganesh

[Former Member · Accepted solution]

Hi,

Try to get the status from RWB

Message monitoring, communication channel monitoring.

and come out with error.

Regards,

Ramesh.

[Former Member]

Hi

apart from this communication channel you can see the message in adapter engine

to do this take the id of the message fromSXI_MONITOR

then go to transaction sxmb_ifr

inside this go to message Monitoring

under drop down select adapter engine and inside the window give the iD of your message which you have taken from MONI

if you are not getting the filter for message ID then click on additional filter and give the iD

after this you can see your message

select the radio butten inside your message and click on details

here you will get the log of each and every step which have been followed in processing the message and you can find the error exactly

regards

sandeep

If helpful reward points

[Former Member]

thanks for all your replies.

[Former Member]

Hi,

You can check using the following link whether the file is picked by the adapter or not.

http://localhost:5[systemnumber]00/mdt/amtServlet

5 indicates that its a J2EE port.

Thanks,

Vijaya.

[former_member240483]

U inserting data into table then u must check what is CC log showing in RWB..

If u using any stored procedure then u can checkl there also..

RWBCCmonitoring-check log there for the particular adapter..

Regards

Rao

[Former Member]

Hi,

Open Runtime workbench--->Component Monitoring

Now select Adapter Engine

Select Communication Channel Monitoring

Another window opens.

In the communication channel monitoring window you need to select receiver(JDBC) Communication channel. and click on "Use Filter"

Now the Message IDs will be displays.

click on message ID

Now the Audit Log will be display

here you can find out which error occured.

Thanks,

Satish

[Former Member]

Hi,

Check in JDBC Adapter CC Monitoring in RWB

Regards

Seshagiri