Cannot push interface

ucmdb 10.22 cp 18.

Trying to get a custom db push adpater to send node & mac_adress to sql db.

The node is moving over fine, but the  ip_address is not mapping  correctly.

The input TQL returns ip and ip_address fine.

Also in the sql db I see 2 separate records being create - one for the host and one for the IP, but hte IP is blank.

I am seeing the below which I think is showing that it is geting the ip_Address but passingthe value.

<Object mode="update_else_insert" name="dbo.hardware" operation="add" mamId="FPush ip_address 1 ID=STRING=454 " id="FPush ip_address 1 ID=STRING=454 ">
        <field name="ip_address" key="false" datatype="char" length="255"></field>
      </Object>

 

Mapping table below:

 

<?xml version="1.0" encoding="UTF-8"?>
<integration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="mappings_schema.xsd">
    <info>
        <source name="UCMDB"  versions="10.01" vendor="HP" />
       <target name="SQLServer" versions="10.50.4000" vendor="Microsoft" />
    </info>
    <targetcis>
        <!-- source_ci_type/source_ci_type_tree name = "<NAME OF UCMDB CLASS TO PULL DATA FROM>" -->
        <source_ci_type_tree name="node" mode="update_else_insert">
            <!-- target_ci_type name = "<NAME OF TABLE TO PUSH DATA TOO>" -->
            <target_ci_type name="dbo.hardware">
                <!-- targetprimarykey = "<MAPS THE SELECTED ATTRIBUTE AS THE TABLE PRIMARY KEY>" -->
                <!-- in this example we are generating primary key using an external db table so we
                don't need to map an UCMDB attribute -->
                <targetprimarykey/>
                <!-- target_attribute name = <"NAME OF THE COLUMN TO PUSH DATA TOO"> -->
                <target_attribute name="hostname" datatype="char" length="255" option="uppercase">
                    <!-- map source_attribute = <"NAME OF ATTRIBUTE TO RETRIEVE THE DATA"> -->
                    <map type="direct" source_attribute="name"/>
                </target_attribute>
            </target_ci_type>
        </source_ci_type_tree>
            <source_ci_type_tree name="ip_address" mode="update_else_insert">
            <target_ci_type name="dbo.hardware">
                <targetprimarykey/>
                 <target_attribute name="ip_address" datatype="char" length="255" option="uppercase">
                    <!-- map source_attribute = <"NAME OF ATTRIBUTE TO RETRIEVE THE DATA"> -->
                    <map type="direct" source_attribute="name"/>
                </target_attribute>
            </target_ci_type>
        </source_ci_type_tree>      
    </targetcis>
  <targetrelations>
    <source_link_type_tree name="containment" target_link_type="UCMDB_Relationship" mode="update_else_insert" source_ci_type_end1="node" source_ci_type_end2="ip_address">
      <target_ci_type_end1 name="node" />
      <target_ci_type_end2 name="ip_address" />
      <targetprimarykey/>
      <target_attribute name="NAME" datatype="char" length="255" option="uppercase">
          <map type="direct" source_attribute="name"/>
      </target_attribute>
  </source_link_type_tree>
    </targetrelations>
</integration>

 

In the log file getting:

 

<root>
  <data>
    <objects>
      <Object mode="update_else_insert" name="dbo.hardware" operation="add" mamId="FPush nt 1 ID=STRING=451 " id="FPush nt 1 ID=STRING=451 ">
        <field name="hostname" key="false" datatype="char" length="255">UCMDB-TEST-03</field>
      </Object>
      <Object mode="update_else_insert" name="dbo.hardware" operation="add" mamId="FPush ip_address 1 ID=STRING=454 " id="FPush ip_address 1 ID=STRING=454 ">
        <field name="ip_address" key="false" datatype="char" length="255"></field>
      </Object>
      <Object mode="update_else_insert" name="dbo.hardware" operation="add" mamId="FPush ip_address 1 ID=STRING=455 " id="FPush ip_address 1 ID=STRING=455 ">
        <field name="ip_address" key="false" datatype="char" length="255"></field>
      </Object>
    </objects>
    <links>
      <link targetRelationshipClass="UCMDB_Relationship" targetParent="node" targetChild="ip_address" operation="add" mode="update_else_insert" mamId="end1id[FusePush nt 1 ID=STRING=451 ] end2id[Push ip_address 1 ID=STRING=454 ] FPush containment 1 ID=STRING=457 " id="end1id[FPush nt 1 ID=STRING=451 ] end2id[FPush ip_address 1 ID=STRING=454 ] FPush containment 1 ID=STRING=457 ">
        <field name="DiscoveryID1">FPush nt 1 ID=STRING=451 </field>
        <field name="DiscoveryID2">FPush ip_address 1 ID=STRING=454 </field>
        <field name="end1Id">FPush nt 1 ID=STRING=451 </field>
        <field name="end2Id">FPush ip_address 1 ID=STRING=454 </field>
        <field name="NAME" key="false" datatype="char" length="255"></field>
      </link>
      <link targetRelationshipClass="UCMDB_Relationship" targetParent="node" targetChild="ip_address" operation="add" mode="update_else_insert" mamId="end1id[FPush nt 1 ID=STRING=451 ] end2id[FPush ip_address 1 ID=STRING=455 ] FusePush containment 1 ID=STRING=456 " id="end1id[FusePush nt 1 ID=STRING=451 ] end2id[FPush ip_address 1 ID=STRING=455 ] FPush containment 1 ID=STRING=456 ">
        <field name="DiscoveryID1">FPush nt 1 ID=STRING=451 </field>
        <field name="DiscoveryID2">FPush ip_address 1 ID=STRING=455 </field>
        <field name="end1Id">FPush nt 1 ID=STRING=451 </field>
        <field name="end2Id">FPush ip_address 1 ID=STRING=455 </field>
        <field name="NAME" key="false" datatype="char" length="255"></field>
      </link>
    </links>
  </data>
</root>