Hi,
I am trying to deploy the dcr content to database. For that I am taking the difference between two editions and creating an xml dump out of it .Then I am deploying to database usiing the xml dump file.
I am getting the following error while deploying to database.
...................................
...................................
DAS:# of columns: 5
DAS:# of primary key columns specified: 2
DAS:# of groups defined in <dbschema> element: 1
DAS:[Tue Jan 11 07:00:54 EST 2005] Begin executing multi
DAS
etting up TDbSchemaSynchronizer.
DAS:Validating cached connection...
DAS:Cached connection OK
DAS:Connected to [10.8.56.19:1521:atlsdcg1]
DAS
ELECT * FROM USER_TABLES WHERE TABLE_NAME='CMS_SRD_GUIDE_TUTORIALS'
DAS:Table [CMS_SRD_GUIDE_TUTORIALS] exists.
DAS
ELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
DAS:Table [iwtracker] exists.
DAS:CMS_SRD_GUIDE_TUTORIALS registered
DAS:Consumer setup for deployment [CMS_ServiceRawDetail] ok
DAS:Running deployment [multi]
DAS:Xml source[/opt/appl/cms/temp/CMS_ServiceRawDetail.dump]
DAS:ERROR:WriteTuple failure to consumer[0]
DAS:ERROR
eployment [CMS_ServiceRawDetail] FAILED
DAS:ERROR:multi-deployment [multi] FAILED
DAS:Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DAS
tat for group [CMS]:
DAS:-----------------------------------
DAS: Rows inserted : 0
DAS: Rows updated : 0
DAS: Rows deleted : 0
DAS: Rows failed : 0
DAS: Rows rolled back : 0
DAS: Rows skipped : 0
DAS:-----------------------------------
DAS:Rollback database [10.8.56.19:1521:atlsdcg1]...
DAS
eployment[CMS_ServiceRawDetail]
DAS
tarted : Tue Jan 11 07:00:54 EST 2005
DAS:Finished: Tue Jan 11 07:00:54 EST 2005
DAS:
### IWDataDeploy FAILED ###
My data deploy configuration file looks like this:
<?xml version="1.0"?>
<data-deploy-configuration>
<data-deploy-elements filepath="/opt/appl/cms/build/backup/database.xml" />
<client>
<deployment name="CMS_ServiceRawDetail">
<source>
<xml-formatted-data file="$dumparea^/$dumpdir^/CMS_ServiceRawDetail.dump">
</xml-formatted-data>
</source>
<destinations>
<database use = "prodDB"
clear-table = "$myclearflag"
state-field="state"
update-type="base"
>
<!-- -->
<!-- BEGIN { Database sub-elements for WIDE tables -->
<!-- -->
<dbschema>
<group name="CMS" table="CMS_SRD_GUIDE_TUTORIALS" root-group="yes">
<attrmap>
<column name="Path" value-from-field="path" data-type="VARCHAR2(255)" allows-null="no" />
<column name="iw_state" value-from-field="state" data-type="VARCHAR2(30)" allows-null="yes"/>
<column name="id_repOrder" data-type="NUMBER(2)" allows-null="yes" replicant-order-column="yes" value-from-field="not-used" />
<column name="nme_gt_linklabel" data-type="VARCHAR2(255)" allows-null="yes" is-replicant="yes" is-url="no" value-from-field="serviceRawDetail/0/guidesTutorials/0/link/[0-2]/linkLabel/0" />
<column name="nme_gt_selectfile" data-type="VARCHAR2(4000)" allows-null="yes" is-replicant="yes" is-url="no" value-from-field="serviceRawDetail/0/guidesTutorials/0/link/[0-2]/selectFile/0" />
</attrmap>
<keys>
<primary-key>
<key-column name="Path"/>
<key-column name="id_repOrder"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="multi" transactional="yes" >
<exec-deployment use="CMS_ServiceRawDetail" />
</deployment>
</client>
</data-deploy-configuration>
Any pointers.
Regards,
Deepa
