I hate datadeploy.....

Andy Knipp

sometimes.


This has to be easy. Of course I am spending way too much time on it.

Basic DD 6.0.2.1 won Win2k connecting to SQL server. I created a table in SQL and made the columns I need.

Config:

<data-deploy-configuration>
 <data-deploy-elements filepath="C:/Interwoven/OpenDeployNG/etc/database.xml"/>
 <client>
  <deployment name="PR">
   <source>
    <xml-source options="wide" area="/default/main/HET/WORKAREA/Content" area-type="os-filesystem" xml-type="Interwoven">
     <path name="templatedata/cat/Other/data/test_dcr.xml" visit-directory="shallow"/>
    </xml-source>
   </source>
   <destinations>
    <database use="DDTest" delete-tracker="yes" update-type="standalone">
     <dbschema>
      <group name="ThingsToDo" table="ThingsToDo" root-group="yes">
       <attrmap>
        <column name="VPATH" data-type="VARCHAR(1024)" value-from-field="path" allows-null="no" is-url="no"/>
        <column name="Title" data-type="VARCHAR(256)" value-from-field="Root/0/Property/0/Title/0/Title" allows-null="yes" is-url="no"/>
        <column name="Description" data-type="VARCHAR(256)" value-from-field="Root/0/Property/0/Other/0/Description" allows-null="yes" is-url="no"/>
        <column name="Long_description" data-type="VARCHAR(1024)" value-from-field="Root/0/Property/0/Other/0/LongDescription" allows-null="yes" is-url="no"/>
       </attrmap>
       <keys>
        <primary-key>
         <key-column name="VPATH"/>
        </primary-key>
       </keys>
      </group>
     </dbschema>
    </database>
   </destinations>
  </deployment>
    </client>
</data-deploy-configuration>

DD completes successfully but nothing is inserted. It complains that the DCR was not found so it says it deletes that record (which does not exist).

Yes I am certain that the DCR exists.

from log:

DBD: Connected to [vmware2k:1433?database=DDTest]
DBD: Table [THINGSTODO] exists.
DBD: Running deployment [PR]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/default/main/HET/WORKAREA/Content
DBD: /default/main/HET/WORKAREA/Content/templatedata/cat/Other/data/test_dcr.xml
DBD: Path not found -- interpret as 'NotPresent'
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={state=NotPresent, path=templatedata\cat\Other\data\test_dcr.xml}
DBD: TTableSchemaHelper object for [THINGSTODO] found in cache.
DBD: SELECTELECT Title,Description,Long_description,VPATH FROM THINGSTODO WHERE VPATH = ?
DBD: Recurse select: pIndex = 0, value = templatedata\cat\Other\data\test_dcr.xml
DBD: BuildTuples:executeQuery returned valid result set
DBD: TTableSchemaHelper object for [THINGSTODO] found in cache.
DBD: BuildTuples:BuildRows returned: true
DBD: -- Deleted