nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DD error

msrinivas

Can somone point to me what I am missing? I am running it for testing from the command line

*************************************************************************************************************************************************************************************

dcr:

<?xml version="1.0" encoding="UTF-8"?>
<article>
<ArticleInfo>
<Abstract/>
<ArticleID>000999888</ArticleID>
<Body><p>Test</p>
</Body>
<CCoverageID/>
<Kicker/>
<PackageID/>
<PrintHeadLine/>
<SubHeadline/>
<Summary/>
<Title>Test45</Title>
<TopStory>T</TopStory>
<WebHeadLine/>
</ArticleInfo>
<ArticleMetaData>
<Author>Author</Author>
<CreationDate>2005-09-22</CreationDate>
<ExpireDate/>
<Keywords>Keywords</Keywords>
<Location/>
<ModifiedDate>2005-09-22</ModifiedDate>
<PublishDate>2005-09-22</PublishDate>
<Source/>
<TaxonomyID>3</TaxonomyID>
<Taxonomylist>4</Taxonomylist>
</ArticleMetaData>
<EditorOverride>
<BonusContent/>
<PartnerContent/>
<RelatedStories/>
<SponsoredLinks/>
<TopStories/>
<WebCast/>
<Whitepapers/>
</EditorOverride>
</article>

*************************************************************************************************************************************************************************************

dbschema:

<dbschema>
<group name="Article" table="Article" root-group="yes">
<attrmap>
<column name="ArticleID" data-type="VARCHAR(50)" value-from-element="article/0/ArticleInfo/0/ArticleID/0" allows-null="no" is-url="no"/>
<column name="PackageID" data-type="INT" value-from-element="article/0/ArticleInfo/0/PackageID/0" allows-null="no" is-url="no"/>
<column name="CcoverageID" data-type="VARCHAR(50)" value-from-element="article/0/ArticleInfo/0/CCoverageID/0" allows-null="yes" is-url="no"/>
<column name="Publish_Date" data-type="DATETIME" value-from-element="article/0/ArticleMetaData/0/PublishDate/0" allows-null="yes" is-url="no"/>
<column name="Creation_date" data-type="DATETIME" value-from-element="article/0/ArticleMetaData/0/CreationDate/0" allows-null="yes" is-url="no"/>
<column name="Exp_date" data-type="DATETIME" value-from-element="article/0/ArticleMetaData/0/ExpireDate/0" allows-null="yes" is-url="no"/>
<column name="Title" data-type="VARCHAR(100)" value-from-element="article/0/ArticleInfo/0/Title/0" allows-null="yes" is-url="no"/>
<column name="Abstract" data-type="VARCHAR(500)" value-from-element="article/0/ArticleInfo/0/Abstract/0" allows-null="yes" is-url="no"/>
<column name="Top_story" data-type="VARCHAR(1)" value-from-element="article/0/ArticleInfo/0/TopStory/0" allows-null="yes" is-url="no"/>
<column name="TaxonomyID" data-type="INT" value-from-element="article/0/ArticleMetaData/0/TaxonomyID/0" allows-null="no" is-url="no"/>

</attrmap>
<keys>
<primary-key>
<key-column name="ArticleID"/>
</primary-key>
</keys>
</group>
</dbschema>

*************************************************************************************************************************************************************************************

error:

DAS: ERROR:Values for PK column [ArticleID] missing in [templatedata\article\index\data\092120052320].
DAS: ERROR:Exception occured: Values for PK column [ArticleID] missing in [templatedata\article\index\data\092120052320].
com.interwoven.dd100.dd.InvalidSourceTupleException: Values for PK column [ArticleID] missing in [templatedata\article\index\data\092120052320].
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmtForExistCheck(TDbSchemaGroupCfg.java:2135)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2054)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForTuple(TDbSchemaCfg.java:1063)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1042)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:419)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:334)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:974)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:581)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:538)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:483)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:261)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:194)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:545)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

*************************************************************************************************************************************************************************************

Find more posts tagged with

Comments

Adam Stoller

As a guess:<column name="ArticleID" data-type="VARCHAR(50)" value-from-element="article/0/ArticleInfo/0/ArticleID/0" allows-null="no" is-url="no"/>I believe you want to get rid of the highlighted text as ArticleID is not a container (the /0 indicates the first [or only] instance of a container object)

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

msrinivas

Thank you for the reply!

This is what I gather from the ddadmin manual:

*****************************************************************************************************************************************

For example, assume that the following data from a custom DCR is to be deployed to a
user-defined database schema:

<press-release>
<head>
<title>title1</title>
<byline author="Chris" location="location1"/>
</head>
<body>
<heading>heading1</heading>
<paragraph>para1></paragraph>
</body>
</press-release>

To map an element’s value to a column (for example, the value for title), the column
element in the DataDeploy configuration file would look like this:

<column name="title" data-type="VARCHAR(100)"
value-from-element="press-release/0/head/0/title/0"/>

To map the value of an element’s named attribute to a column (for example, the value for
the author attribute), the column element in the DataDeploy configuration file would look
like this:

<column name="author" data-type="VARCHAR(100)"
value-from-attribute="press-release/0/head/0/byline/0/author"/>

Note the /o/ succeeding each element name. Those are instance indicators that specify
which instance of the node’s value or attribute is mapped. You must specify the maximum
number of instances (replicants) for a given node element. Arbitrarily large values can be
specified when the maximum number of replicants allowed is unknown.

*********************************************************************************************************************************

Adam Stoller

That's nice.
Have you tried dropping the '/0' to see if that works? If it works - file a bug against the manual; if it doesn't work - post again.

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

msrinivas

No luck! I tried that too!

Adam Stoller

Well, not sure what to tell you then... Based on what you posted (recap) - the error is:

DAS: ERROR:Values for PK column [ArticleID] missing in [templatedata\article\index\data\092120052320].The dbschema specifies:

<column name="ArticleID" data-type="VARCHAR(50)" value-from-element="article/0/ArticleInfo/0/ArticleID/0" allows-null="no" is-url="no"/>and the DCR looks like:

I'm assuming that neither 'article' nor 'ArticleInfo' are replicants - just single-instance containers - yes?
The only thing I can think of is that perhaps you mis-declared something in your DD config file - like where you declare the xml-source - what value did you use for the xml-type attribute? I believe it needs to be custom as opposed to interwoven.

Perhaps someone else will spot something - but in the meantime it might be a good idea to open a case with Support (just in case...)

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

Migrateduser

I had a similar issue but it was because I dorked up the "is-replicant" spec.

Current Environments:
(1,2) TS 6.5 on W2K3
(3) Vignette V7 Portal on Solaris 9