How to monitor RFC to JDBC scenario?

[Former Member]

How to monitor RFC to JDBC scenario

Hello,

I have update_insert scenario from RFC to Oracle database.

In TOC SXMB_MONI I have black and white flag.

In RWB I found for this scenario only successful status.

But in the database I found only 2 records from the 15 that I sent.

How can I monitor this problem?

What are the steps to investigate this situation?

Have a way to see the exact statement that I sent to the database?

Regards

Elad

[Former Member · Accepted solution]

Hi,

To check message status in Adapter Level.

Message Monitoring > Messages from (Adapter Engine) > (Select message) > Details > Audit log.

Thanks,

Boopathi

[Former Member · Accepted solution]

Hello,

Inot found the audit log there.

Elad

[Former Member · Accepted solution]

Any new idea how to solve this issue?

[Former Member · Accepted solution]

Hi,

In RWB > Meaasge Mointoring > Messages from Component ( Select Adapter Engine) > Filter your corresponding message > select one message > Details > Message Display Tool (Detail Display)

The Audit log clearly shows the Adapter processing status. This is better way to trace the problems.

Thanks,

Boopathi

Edited by: Boopathi Thangavel on Sep 23, 2008 12:54 PM

[Former Member · Accepted solution]

Hello,

I found this details but I'm not found there any clue abut my problem

Elad

[Former Member · Accepted solution]

Hi,

check last page in the audit log...you can able to view processing status information.

Thanks,

Boopathi

[Former Member · Accepted solution]

The message status is:

Successful

[former_member187587 · Accepted solution]

Hi Elad,

If nothing can be seen in the Adapter monitor...go to the Database.

Oracle has various developer\system tools that can allow you to get information.

For example Oracle has the TOAD tool which allows you to get the SQL trace of the treatment the XI actually send.

see if the SQL interpreted by the JDBC adapter was really what you meant.

Good luck.

Nimrod.G

[Former Member]

Hi Peleg,

out 15 only 2 records have been modified try to check the flag condition in the database as per ur scenario it is able to send the records from RFC to oracle database but at other end ie database it is unable to update the values accordingly

Regards

Sampath