JDBC format with schema..

[Former Member]

Hello,

I'm attempting to insert into a table using the JDBC adapter and I need to specify the schema. Below is the format of my resulting xml mapped to insert into the table.

1. Am I missing something to make it specify ARIBAUSR.PO_RETURN as the table as opposed to just PO_RETURN? I'm using a different user for the JDBC connection in the adapter.

2. Is there somewhere I can look inside XI to see if this is really a SQL/database error? In the monitoring tool, it says it was successful everywhere I look. Only there's no insert into my table. I have tried to run a mannual SQL insert with the data in this file and it works perfectly.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns:PO_RETURN_insert xmlns:ns="urn:test_sap-ariba-PO:staging">

- <Insert1>

- <PO_RETURN action="INSERT">

<table>ARIBAUSR.PO_RETURN</table>

- <access>

<MANDT>01</MANDT>

<EBELN>D02</EBELN>

<EBELP>00010</EBELP>

<ACTION_KEY>A</ACTION_KEY>

<CR_DATE>20051212</CR_DATE>

<CR_TIME>12000000</CR_TIME>

<SEQUENCE>1</SEQUENCE>

<TYPE>W</TYPE>

<MSGNR>083</MSGNR>

<MSGID>ME</MSGID>

<FLDNAME>DOC_TYPE</FLDNAME>

<MESSAGE>Enter Document type</MESSAGE>

<SYSID>SR1CLNT545</SYSID>

<MESSAGE_V1>Document type</MESSAGE_V1>

<MESSAGE_V2 />

<MESSAGE_V3 />

<MESSAGE_V4 />

</access>

</PO_RETURN>

</Insert1>

</ns:PO_RETURN_insert>

[former_member185751 · Accepted solution]

Hi Tom,

Depending on the SP you are in, check the adapter monitor using one of the following URLs for the receiver JDBC adapter:

http://<hostname>:<portnumber>/mdt/amtServlet

or

http://<hostname>:<portnumber>/AdapterFramework

Also check the logs in J2EE engine where the adapters run as services.

Regards,

Sridhar

[Former Member · Accepted solution]

Thanks, I've actually seen that and my JDBC adapter shows up green there.

What I'm looking for is the actual SQL run based on the XML document passed.

Also, this is a synch interface between a JDBC table and a BAPI. As I understand the inbound "receiver" jdbc adapter will be used as the sender? Or do I have to do something special ie. create a separate sender/receiver agreement for the outbound post?

[former_member185751 · Accepted solution]

From the RWB, check the audit log in message monitoring of adapter engine<hostname>

Check out the following blog:

https://www.sdn.sap.com/sdn/weblogs.sdn?blog=/pub/wlg/1403 [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken]

It may help you with the configuration.

Regards,

Sridhar

[Former Member · Accepted solution]

My message log shows this..

The XI response message for message b5b11d10-ac43-11d9-8c56-00306e5d96f8(INBOUND) was successfully returned to the calling application.

And I don't think I need a BPM or Synch/Asynch for this. It's simply a pull from a database (JDBC adapter) and post to BAPI (RFC) and then return a field to a database. It's synch/synch with a single target on each side.

I have two adapters involved. One for RFC for the BAPI and one JDBC inbound for the database pull.