JDBC format with schema..
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>