deployment multiple select box options

ENV: win2k/TS61/DD56sp1/Oracle8i

Hi all,

I am looking for an example of a deployment which deploys this:

<item name="document_category">
<description>Category of the associated document file.</description>
<database data-type="VARCHAR(50)" />
<select required="t" multiple="t">
<option label="Change Management" value="6"/>
<option label="Developer Operations" value="1"/>
<option label="Hardware Configurations" value="7"/>
<option label="Hosting" value="2"/>
<option label="Issue Management" value="11"/>
<option label="Logical Environment" value="5"/>
<option label="Middleware Components" value="9"/>
<option label="Physical Environment" value="4"/>
<option label="Problem Management" value="10"/>
<option label="Questionnaire" value="13"/>
<option label="Release" value="3"/>
<option label="Software Configurations" value="8"/>
<option label="Ticket Tracking" value="12"/>
</select>
</item>

Into a Oracle8i table with multiple tables or in one table.

I am trying this deployment:

<data-deploy-configuration>
<client>



<deployment name="DeployDocTypes">
<source>

<teamsite-extended-attributes
options="wide,full"
area="/default/main/datadeploy/WORKAREA/work" >
<path name="/templatedata/internet/multipleselectbox" visit-directory="deep" />
</teamsite-extended-attributes>
</source>

<destinations>


<database db="10.101.1.210:1521:nlsup"
user="brandon"
password="brandon"
vendor="oracle"
table= "KO_CONTENT_META_CATEGORY"
update-type="standalone"
state-field="state"
delete-tracker="yes"
drop-table="yes">
<dbschema>

<group name="document_category" root-group="yes">
<attrmap>
<column name="CATEGORY_TYPE_ID" data-type="INTEGER" value-from-field="TeamSite/Metadata/document_category/[1-13]/doc_cat" allows-null="no" is-url="no" list-to-replicant="yes" list-field="TeamSite/Metadata/document_category" is-replicant="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CATEGORY_TYPE_ID"/>
</primary-key>
</keys>
</group>
<group name="document_category1" root-group="no">
<attrmap>
<column name="CATEGORY_TYPE_ID" data-type="INTEGER" value-from-field="TeamSite/Metadata/document_category/1/doc_cat" allows-null="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CATEGORY_TYPE_ID"/>
</primary-key>
<foreign-key parent-group="document_category">
<column-pair parent-column="CATEGORY_TYPE_ID" child-column="CATEGORY_TYPE_ID"/>
</foreign-key>
</keys>
</group>

</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

But I get the following error:

C:\dd-home\bin>iwdd.ipl cfg=c:\dd-home\conf\ddclientDev.cfg deployment=DeployDocTypes
DataDeploy Version 5.6.0 Build 19499 Interwoven 20030506
Database Vendor set to oracle
SQL datatype for column CATEGORY_TYPE_ID is INTEGER
# of columns: 1
# of primary key columns specified: 1
WARNING:Assuming group name as the table name for [document_category].
SQL datatype for column CATEGORY_TYPE_ID is INTEGER
# of columns: 1
# of primary key columns specified: 1
# of foreign key columns specified: 1
WARNING:Assuming group name as the table name for [document_category1].
# of groups defined in <dbschema> element: 2
Area VPath:/default/main/datadeploy/WORKAREA/work
Setting up TDbSchemaAgent.
>>> Loading drivers <<<
url : 10.101.1.210:1521:nlsup
login : brandon
login timeout=3
Connecting to the database...
Try connecting using jdbc Smiley Surprised

racle:thin:@10.101.1.210:1521:nlsup...

Connected to jdbc Smiley Surprised

racle:thin:@10.101.1.210:1521:nlsup
Driver Oracle JDBC driver
Version 9.0.1.1.0
Connected to [10.101.1.210:1521:nlsup]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
Building mappings cache...
Built mapping cache(s) successfully.
# column mappings: 0
# table mappings: 99
# view mappings: 18
# constraint mappings: 55
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
SELECT * FROM USER_TABLES WHERE TABLE_NAME='DOCUMENT_CATEGORY'
Table [document_category] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='DOCUMENT_CATEGORY1'
SELECT * FROM USER_TABLES WHERE TABLE_NAME='DOCUMENT_CATEGORY1'
Table [document_category1] does not exist. Creating..
CREATE TABLE document_category1(CATEGORY_TYPE_ID INTEGER NOT NULL , CONSTRAINT document_category1
_key PRIMARY KEY (CATEGORY_TYPE_ID))
Running deployment [DeployDocTypes]
extraction type=full
tuple mode=wide
area=/default/main/datadeploy/WORKAREA/work
/default/main/datadeploy/WORKAREA/work//templatedata/internet/multipleselectbox
Generate DirectoryContents start:Thu Jul 01 18:46:37 BST 2004
Generate DirectoryContents end :Thu Jul 01 18:46:37 BST 2004
Generate TFullEAExtractor start:Thu Jul 01 18:46:37 BST 2004
Generate TFullEAExtractor end :Thu Jul 01 18:46:37 BST 2004
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={TeamSite/Templating/DCR/Type=internet/multipleselectbox, IWOV_PROC_FLAG=true, state=Original,
path=templatedata\internet\multipleselectbox\data\multipleselectbox01}
ERROR:Values for PK column [CATEGORY_TYPE_ID] missing in [templatedata\internet\multipleselectbox\da
ta\multipleselectbox01].
ERROR:Exception occured: Values for PK column [CATEGORY_TYPE_ID] missing in [templatedata\internet\m
ultipleselectbox\data\multipleselectbox01].
com.interwoven.dd100.dd.InvalidSourceTupleException: Values for PK column [CATEGORY_TYPE_ID] missing
in [templatedata\internet\multipleselectbox\data\multipleselectbox01].
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmtForExistCheck(TDbSchemaGroupCfg.
java:2099)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2018)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForTuple(TDbSchemaCfg.java:1057)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1036)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:411)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:331)
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:962)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:464)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:487)
at com.interwoven.dd100.dd.IWDataDeploy.runDeploy(IWDataDeploy.java:527)
at com.interwoven.dd100.dd.IWDataDeploy.main(IWDataDeploy.java:508)
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source /templatedata/internet/multipleselectbox
ERROR:deployment [DeployDocTypes] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Stat for group [document_category]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [document_category1]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [10.101.1.210:1521:nlsup]...
Deployment[DeployDocTypes]
-----------------------------------
Files with EAs inserted : 0
Files with EAs updated : 0
Files with EAs deleted : 0
Files with EAs failed : 0
Files with EAs rolled back : 0
Files with EAs skipped : 0
-----------------------------------
Started : Thu Jul 01 18:46:36 BST 2004
Finished: Thu Jul 01 18:46:38 BST 2004

### IWDataDeploy FAILED ###

Any of you have a deployment configuration file which deploys a multiple select box item?

cheers,

AC

Find more posts tagged with

Comments

There are no comments yet