Datadeploy not deploying from xml

I'm trying to deploy from xml file. The XML is as follows:

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

<Sample_Datafile>
<record>
<contentId>001</contentId>
<ContentTypes>A</ContentTypes>
</record>
<record>
<contentId>001</contentId>
<ContentTypes>B</ContentTypes>
</record>
<record>
<contentId>001</contentId>
<ContentTypes>C</ContentTypes>
</record>
<record>
<contentId>001</contentId>
<ContentTypes>D</ContentTypes>
</record>
</Sample_Datafile>

And my datadeploy config file is as follows:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<data-deploy-configuration>
<client>
<deployment name="xml-to-db">
<source>
<xml-formatted-data file="/interwoven/iw-home/ddconfig/test2.xml">
<fields>
<field name="contentId" element="contentId" />
<field name="ContentTypes" element="ContentTypes" />
</fields>
</xml-formatted-data>
</source>
<destinations>
<database db="mydb:1521:host" user="user" password="pwd" vendor="oracle" table="CONTENT_DETAIL" update-type="base">
<select>
<column name="CONTENT_ID" value-from-field="contentId" />
<column name="DISPLAY_NAME" value-from-field="ContentTypes" />
<column name="PAGE_TYPE" value="P" />
<column name="PAGE_SUB_TYPE" value="A" />
</select>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

When i run the iwdd.ipl command
/interwoven/iw-home/datadeploy/bin/iwdd.ipl cfg=/interwoven/iw-home/ddconfig/config.cfg deployment=xml-to-db
i am getting the following message from Datadeploy:
DataDeploy Version 5.6.0 Build 14707 Interwoven 20021211
Database Vendor set to oracle
Setting up consumer TDbAgent
>>> Loading drivers <<<
url : mydb:1521:host login : user
login timeout=3
Connecting to the database...
Try connecting using jdbc Smiley Surprised

racle:thin:@mydb:1521:host...

Connected to jdbc Smiley Surprised

racle:thin:@mydb:1521:host
Driver Oracle JDBC driver
Version 9.0.1.1.0
Connected to [mydb:1521:host]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
Building mappings cache...
Built mapping cache(s) successfully.
# column mappings: 0
# table mappings: 0
# view mappings: 0
# constraint mappings: 0
SELECT * FROM USER_TABLES WHERE TABLE_NAME='CONTENT_DETAIL'
Table <CONTENT_DETAIL> exists.
Running deployment [xml-to-db]
Xml source[/interwoven/iw-home/ddconfig/test2.xml]
"contentId" element cannot be the root element of the XML document
Committing database [mydb:1521:host]...
Deployment[xml-to-db] Table[CONTENT_DETAIL]
-----------------------------------
Tuples inserted : 0
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
Started : Wed Mar 26 21:14:13 CST 2003
Finished: Wed Mar 26 21:14:15 CST 2003

### IWDataDeploy DONE ###
Can anyone help?Am I missing something?

thanks

Find more posts tagged with

Comments

Migrateduser

Source type <xml-formatted-data> is only used for XML files generated by DD. In your case you have a generic XML file.
If you are using DD5.6 change the source type to <xml-source> and since you are deploying from a generic xml file you need to map the column to an xml attribute or element hence you need to use value-from-element or value-from-attribute , refer the section in manual Deploying Custom data records and Sample Scenarios for Using the xml-source Tag.

msingh

did you get your problem solved. if yes, please let me know. i was able to successfully do DD for single file (not replicant) but for replicant data as in your case i am unable to do it. "value-from-element" and "value-from attribute" is not working. it has to be replaced by "value-from-field". i am using DD5.6. please let me know the solution. its urgent.

Migrateduser

are you trying to deploy a Interwoven DCR or a generic XML file. If you are using a IWOV DCR you would be using value-from-field to map the DCR elements. Also if the field you are trying to map is a replicant you need to specify the attribute is-replicant="yes" in the column element.

msingh

Hi,
i am trying to deploy a generic xml. my xml is as such.
<TOP>
<RANK value="1">
<CONTENT_TYPE>1</CONTENT_TYPE>
<CONTENT_REF>2</CONTENT_REF>
</RANK>
<RANK value="2">
<CONTENT_TYPE>12</CONTENT_TYPE>
<CONTENT_REF>22</CONTENT_REF>
</RANK>
....
...
</TOP>

how do we do DD for the above xml.
is-replicant of course is not going to serve my purpose. please let me know as soon as possible.
Thanks

Migrateduser

Did you generate a dbschema for the corresponding dtd. Can I see what your dbschema.cfg looks like for dtd corresponding to this XML file.

msingh

Do i need to generate dbschema.xml file for each dd. i am not using one. is it required.

msingh

Hi,
i am running the dd through command iwdd.ipl. i don't have dbschema.cfg for it. i don't require one. i am able to dd from xml to database without dbschema.cfg for normal xml file using say value-from-field="CDP/0/CONTENTTYPE/0/CATEGORY/0" etc etc. but i am unable to insert data for generic xml containing replicant data as mentioned in the above mail. this xml i am generating from my custom cgi. am i missing something.
Thanks.

Migrateduser

Its recommended to use the UDS table format for deploying xml data to database. You are probably using the wide table format (which does not have the dbschema section) which has lot of limitations and restrictions.

You need to generate the dbschema.cfg just once for a specific dtd. Please post your config file.