Problem with JDBC Receiver - INSERT

[former_member248006]

Hello,

I am attempting to INSERT records into an Oracle Database.

Structure of my Data Type for JDBC:

My Operation Mapping works fine, all of the elements get the correct data.

I have enabled logging of SQL on my adapter.  Here is what I get in the message audit log:

So for some reason my SQL Statement does not contain any of the columns or values from my <access> node.  Any thoughts?  I test the exact same incoming message in the OM test page and it maps fine.

Thank you for the help!

[former_member182412 · Accepted solution]

Hi Adam,

Create the target structure based on below sap help

Defining an INSERT Statement - Advanced Adapter Engine - SAP Library

access element should be 1 to unbounded not dbTableName element.

Can you put the xml after the mapping here?

Regards,

Praveen.

[former_member248006 · Accepted solution]

Thanks Praveen.   I have made those changes, error persists.  Here is the XML after the mapping, as requested.  Odd that it is entering a blank line after the first <access>:

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

<ns0:MT_OurTool_SyncRouting xmlns:ns0="urn:OurCo:solumina:OurTool:SyncRouting">

   <StatementName1>

      <dbTableName action="INSERT">

         <table>BOM_OP_ROUTINGS_INTERFACE</table>

         <access>

            <ALTERNATE_ROUTING_DESIGNATOR>test</ALTERNATE_ROUTING_DESIGNATOR>

            <LAST_UPDATE_DATE>04-10-2016</LAST_UPDATE_DATE>

            <LAST_UPDATED_BY>0</LAST_UPDATED_BY>

            <CREATION_DATE>04-10-2016</CREATION_DATE>

            <CREATED_BY>0</CREATED_BY>

            <ROUTING_TYPE>1</ROUTING_TYPE>

            <PROCESS_REVISION>003</PROCESS_REVISION>

            <ORGANIZATION_CODE>DHV</ORGANIZATION_CODE>

            <ASSEMBLY_ITEM_NUMBER>testpart</ASSEMBLY_ITEM_NUMBER>

            <PROCESS_FLAG>1</PROCESS_FLAG>

            <TRANSACTION_TYPE>Create</TRANSACTION_TYPE>

         </access>

      </dbTableName>

   </StatementName1>

   <StatementName2>

      <dbTableName action="INSERT">

         <table>MTL_RTG_ITEM_REVS_INTERFACE</table>

         <access>

            <PROCESS_REVISION>003</PROCESS_REVISION>

            <LAST_UPDATE_DATE>04-10-2016</LAST_UPDATE_DATE>

            <LAST_UPDATED_BY>0</LAST_UPDATED_BY>

            <CREATION_DATE>04-10-2016</CREATION_DATE>

            <CREATED_BY>0</CREATED_BY>

            <EFFECTIVITY_DATE>2016-10-05T00:00:00.000-04:00</EFFECTIVITY_DATE>

            <INVENTORY_ITEM_NUMBER>testpart</INVENTORY_ITEM_NUMBER>

            <ORGANIZATION_CODE>DHV</ORGANIZATION_CODE>

            <PROCESS_FLAG>1</PROCESS_FLAG>

            <TRANSACTION_TYPE>CREATE</TRANSACTION_TYPE>

            <ORIGINAL_SYSTEM_REFERENCE>0000005</ORIGINAL_SYSTEM_REFERENCE>

         </access>

      </dbTableName>

   </StatementName2>

   <StatementName3>

      <dbTableName action="INSERT">

         <table>BOM_OP_SEQUENCES_INTERFACE</table>

         <access>

            <OPERATION_SEQ_NUM>010</OPERATION_SEQ_NUM>

            <LAST_UPDATE_DATE>04-10-2016</LAST_UPDATE_DATE>

            <LAST_UPDATED_BY>0</LAST_UPDATED_BY>

            <CREATION_DATE>04-10-2016</CREATION_DATE>

            <CREATED_BY>0</CREATED_BY>

            <EFFECTIVITY_DATE>2016-10-05T00:00:00.000-04:00</EFFECTIVITY_DATE>

            <DISABLE_DATE>2016-10-06T23:59:59.000-04:00</DISABLE_DATE>

            <BLACKFLUSH_FLAG>1</BLACKFLUSH_FLAG>

            <ALTERNATE_ROUTING_DESIGNATOR/>

            <ORGANIZATION_CODE>DHV</ORGANIZATION_CODE>

            <ASSEMBLY_ITEM_NUMBER>testpart</ASSEMBLY_ITEM_NUMBER>

            <DEPARTMENT_CODE>testdept</DEPARTMENT_CODE>

            <PROCESS_FLAG>1</PROCESS_FLAG>

            <TRANSACTION_TYPE/>

            <INCLUDE_IN_ROLLUP>1</INCLUDE_IN_ROLLUP>

         </access>

      </dbTableName>

   </StatementName3>

   <StatementName4>

      <dbTableName action="INSERT">

         <table>BOM_OP_RESOURCES_INTERFACE</table>

         <access>

            <RESOURCE_SEQ_NUM>10</RESOURCE_SEQ_NUM>

            <STANDARD_RATE_FLAG>1</STANDARD_RATE_FLAG>

            <ASSIGNED_UNITS>6.0</ASSIGNED_UNITS>

            <USAGE_RATE_OR_AMOUNT>2.00</USAGE_RATE_OR_AMOUNT>

            <BASIS_TYPE>2</BASIS_TYPE>

            <SCHEDULE_FLAG>1</SCHEDULE_FLAG>

            <LAST_UPDATE_DATE>09-278-2016</LAST_UPDATE_DATE>

            <LAST_UPDATED_BY>0</LAST_UPDATED_BY>

            <CREATION_DATE>09-278-2016</CREATION_DATE>

            <CREATED_BY>0</CREATED_BY>

            <AUTOCHARGE_TYPE>1</AUTOCHARGE_TYPE>

            <ALTERNATE_ROUTING_DESIGNATOR/>

            <OPERATION_SEQ_NUM>010</OPERATION_SEQ_NUM>

            <EFFECTIVITY_DATE>2016-10-05T00:00:00.000-04:00</EFFECTIVITY_DATE>

            <ORGANIZATION_CODE>DHV</ORGANIZATION_CODE>

            <ASSEMBLY_ITEM_NUMBER>testpart</ASSEMBLY_ITEM_NUMBER>

            <RESOURCE_CODE>testresource</RESOURCE_CODE>

            <PROCESS_FLAG>1</PROCESS_FLAG>

            <TRANSACTION_TYPE>Create</TRANSACTION_TYPE>

         </access>

         <access>

            <RESOURCE_SEQ_NUM>20</RESOURCE_SEQ_NUM>

            <STANDARD_RATE_FLAG>1</STANDARD_RATE_FLAG>

            <ASSIGNED_UNITS>6.0</ASSIGNED_UNITS>

            <USAGE_RATE_OR_AMOUNT>1.50</USAGE_RATE_OR_AMOUNT>

            <BASIS_TYPE>1</BASIS_TYPE>

            <SCHEDULE_FLAG>1</SCHEDULE_FLAG>

            <LAST_UPDATE_DATE>04-10-2016</LAST_UPDATE_DATE>

            <LAST_UPDATED_BY>0</LAST_UPDATED_BY>

            <CREATION_DATE>04-10-2016</CREATION_DATE>

            <CREATED_BY>0</CREATED_BY>

            <AUTOCHARGE_TYPE>1</AUTOCHARGE_TYPE>

            <ALTERNATE_ROUTING_DESIGNATOR/>

            <OPERATION_SEQ_NUM>010</OPERATION_SEQ_NUM>

            <EFFECTIVITY_DATE>2016-10-05T00:00:00.000-04:00</EFFECTIVITY_DATE>

            <ORGANIZATION_CODE>DHV</ORGANIZATION_CODE>

            <ASSEMBLY_ITEM_NUMBER>testpart</ASSEMBLY_ITEM_NUMBER>

            <RESOURCE_CODE>testresource</RESOURCE_CODE>

            <PROCESS_FLAG>1</PROCESS_FLAG>

            <TRANSACTION_TYPE/>

         </access>

         <access>

            <RESOURCE_SEQ_NUM>30</RESOURCE_SEQ_NUM>

            <STANDARD_RATE_FLAG>1</STANDARD_RATE_FLAG>

            <ASSIGNED_UNITS>6.0</ASSIGNED_UNITS>

            <USAGE_RATE_OR_AMOUNT>3.00</USAGE_RATE_OR_AMOUNT>

            <BASIS_TYPE>2</BASIS_TYPE>

            <SCHEDULE_FLAG>1</SCHEDULE_FLAG>

            <LAST_UPDATE_DATE>04-10-2016</LAST_UPDATE_DATE>

            <LAST_UPDATED_BY>0</LAST_UPDATED_BY>

            <CREATION_DATE>04-10-2016</CREATION_DATE>

            <CREATED_BY>0</CREATED_BY>

            <AUTOCHARGE_TYPE>1</AUTOCHARGE_TYPE>

            <ALTERNATE_ROUTING_DESIGNATOR/>

            <OPERATION_SEQ_NUM>010</OPERATION_SEQ_NUM>

            <EFFECTIVITY_DATE>2016-10-05T00:00:00.000-04:00</EFFECTIVITY_DATE>

            <ORGANIZATION_CODE>DHV</ORGANIZATION_CODE>

            <ASSEMBLY_ITEM_NUMBER>testpart</ASSEMBLY_ITEM_NUMBER>

            <RESOURCE_CODE>TIME</RESOURCE_CODE>

            <PROCESS_FLAG>1</PROCESS_FLAG>

            <TRANSACTION_TYPE/>

         </access>

         <access>

            <RESOURCE_SEQ_NUM>40</RESOURCE_SEQ_NUM>

            <STANDARD_RATE_FLAG>1</STANDARD_RATE_FLAG>

            <ASSIGNED_UNITS>6.0</ASSIGNED_UNITS>

            <USAGE_RATE_OR_AMOUNT>4.50</USAGE_RATE_OR_AMOUNT>

            <BASIS_TYPE>2</BASIS_TYPE>

            <SCHEDULE_FLAG>1</SCHEDULE_FLAG>

            <LAST_UPDATE_DATE>04-10-2016</LAST_UPDATE_DATE>

            <LAST_UPDATED_BY>0</LAST_UPDATED_BY>

            <CREATION_DATE>04-10-2016</CREATION_DATE>

            <CREATED_BY>0</CREATED_BY>

            <AUTOCHARGE_TYPE>1</AUTOCHARGE_TYPE>

            <ALTERNATE_ROUTING_DESIGNATOR/>

            <OPERATION_SEQ_NUM>010</OPERATION_SEQ_NUM>

            <EFFECTIVITY_DATE>2016-10-05T00:00:00.000-04:00</EFFECTIVITY_DATE>

            <ORGANIZATION_CODE>DHV</ORGANIZATION_CODE>

            <ASSEMBLY_ITEM_NUMBER>testpart</ASSEMBLY_ITEM_NUMBER>

            <RESOURCE_CODE>WQM-TIME</RESOURCE_CODE>

            <PROCESS_FLAG>1</PROCESS_FLAG>

            <TRANSACTION_TYPE>Create</TRANSACTION_TYPE>

         </access>

      </dbTableName>

   </StatementName4>

</ns0:MT_OurTool_SyncRouting>

[former_member248006 · Accepted solution]

im good to go.  had to refresh my OM in the ICO.