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 Metdatas n times

HAL

Hi all,
using dd560
well have a standalone deployment in a user schema database:
the config file generated dynamically is the following one :
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<data-deploy-configuration>
<client>
<deployment name="Business_Driver">
<source>
<teamsite-templating-records
options="wide"
area="/default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Business_Driver/data">
<path filelist ="/data/software/iw/iw-home/tmp/upc/publish/Business_Driver/Business_Driver.lst" visit-directory="deep" delete-after-use="no" />
</teamsite-templating-records>
</source>
<destinations>
<database db="wls.btwpd3.devenv1.bt.co.uk:1521:btwpd3" user="LINK_OWNER1" password="en3rgy61" vendor="oracle" update-type="standalone" state-field="state" log-level="3" delete-tracker="yes" enforce-ri="no">
<dbschema>
<group name="bdriver" table="UMPC_BUSINESS_DRIVER" root-group="yes">
<attrmap>
<column name="DCR_PATH" data-type="VARCHAR(500)" value-from-field="path"/>
<column name="BUSINESS_DRIVER_ID" data-type="NUMBER(9)" value-from-field="IDs/0/Id" allows-null="no" is-url="no"/>
<column name="ACTIVE_STATUS_ID" data-type="NUMBER(4)" value-from-field="Both/0/active_status" allows-null="no" is-url="no"/>
<column name="ADMIN_NAME" data-type="VARCHAR(300)" value-from-field="Both/0/Admin_Name" allows-null="no" is-url="no"/>
<column name="NAME" data-type="VARCHAR(200)" value-from-field="Both/0/Name" allows-null="no" is-url="no"/>
<column name="EXT_DESC_BLOCK1" data-type="VARCHAR(4000)" value-from-field="External/0/ExtDescription" allows-null="yes" is-url="no"/>
<column name="OLD_SIEBEL_ID" data-type="VARCHAR(15)" value-from-field="IDs/0/SiebelId" allows-null="yes" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="BUSINESS_DRIVER_ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="Proposition">
<source>
<teamsite-templating-records
options="wide"
area="/default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Proposition/data">
<path filelist ="/data/software/iw/iw-home/tmp/upc/publish/Proposition/PropositionDD.lst" visit-directory="deep" delete-after-use="no" />
</teamsite-templating-records>
</source>
<destinations>
<database db="wls.btwpd3.devenv1.bt.co.uk:1521:btwpd3" user="LINK_OWNER1" password="en3rgy61" vendor="oracle" update-type="standalone" state-field="state" log-level="3" delete-tracker="yes" enforce-ri="no">
<dbschema>
<group name="proposition" table="UMPC_PROPOSITION" root-group="yes">
<attrmap>
<column name="PROPOSITION_ID" data-type="NUMBER(9)" value-from-field="IDs/0/Id" allows-null="no" is-url="no"/>
<column name="ACTIVE_STATUS_ID" data-type="NUMBER(4)" value-from-field="Both/0/active_status" allows-null="no" is-url="no"/>
<column name="EXT_OVERVIEW" data-type="VARCHAR(2000)" value-from-field="External/0/ExtOverview" allows-null="no" is-url="no"/>
<column name="NAME" data-type="VARCHAR(200)" value-from-field="Both/0/Name" allows-null="no" is-url="no"/>
<column name="EXT_DESC_BLOCK1" data-type="VARCHAR(4000)" value-from-field="External/0/ExtDescription" allows-null="no" is-url="no"/>
<column name="OLD_SIEBEL_ID" data-type="VARCHAR(15)" value-from-field="IDs/0/SiebelId" allows-null="yes" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="PROPOSITION_ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="metadataBusiness_DriverToProposition0">
<source>
<teamsite-extended-attributes
options="wide"
area="/default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Business_Driver/data">
<path filelist ="/data/software/iw/iw-home/tmp/upc/publish/Business_Driver/Business_Driver.lst" visit-directory="deep" delete-after-use="no"/>
</teamsite-extended-attributes>
</source>
<destinations>
<database db="wls.btwpd3.devenv1.bt.co.uk:1521:btwpd3" user="LINK_OWNER1" password="en3rgy61" vendor="oracle" update-type="standalone" state-field="state" log-level="3" delete-tracker="yes" enforce-ri="no">
<dbschema>
<group name="bdrv_to_prod_link" table="UMPC_BUS_DRV_PROP_LINK" root-group="yes">
<attrmap>
<column name="DCR_PATH" data-type="VARCHAR(500)" value-from-field="path"/>
<column name="BUSINESS_DRIVER_ID" data-type="NUMBER(9)" value-from-field="TeamSite/Metadata/Id" />
<column name="PROPOSITION_ID" data-type="NUMBER(9)" value-from-field="TeamSite/Metadata/Proposition/Boost_revenues_with_more_accurate_INCA_billing.dcr/Id" />
<column name="LINK_VISIBILITY_ID" data-type="NUMBER(4)" value-from-field="TeamSite/Metadata/Visibility_Id" />
</attrmap>
<keys>
<primary-key>
<key-column name="BUSINESS_DRIVER_ID"/>
<key-column name="PROPOSITION_ID"/>
<key-column name="LINK_VISIBILITY_ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="metadataBusiness_DriverToProposition1">
<source>
<teamsite-extended-attributes
options="wide"
area="/default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Business_Driver/data">
<path filelist ="/data/software/iw/iw-home/tmp/upc/publish/Business_Driver/Business_Driver.lst" visit-directory="deep" delete-after-use="no"/>
</teamsite-extended-attributes>
</source>
<destinations>
<database db="wls.btwpd3.devenv1.bt.co.uk:1521:btwpd3" user="LINK_OWNER1" password="en3rgy61" vendor="oracle" update-type="standalone" state-field="state" log-level="3" delete-tracker="yes" enforce-ri="no">
<dbschema>
<group name="bdrv_to_prod_link" table="UMPC_BUS_DRV_PROP_LINK" root-group="yes">
<attrmap>
<column name="DCR_PATH" data-type="VARCHAR(500)" value-from-field="path"/>
<column name="BUSINESS_DRIVER_ID" data-type="NUMBER(9)" value-from-field="TeamSite/Metadata/Id" />
<column name="PROPOSITION_ID" data-type="NUMBER(9)" value-from-field="TeamSite/Metadata/Proposition/Audio_Conferencing.dcr/Id" />
<column name="LINK_VISIBILITY_ID" data-type="NUMBER(4)" value-from-field="TeamSite/Metadata/Visibility_Id" />
</attrmap>
<keys>
<primary-key>
<key-column name="BUSINESS_DRIVER_ID"/>
<key-column name="PROPOSITION_ID"/>
<key-column name="LINK_VISIBILITY_ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="metadataBusiness_DriverToProposition2">
<source>
<teamsite-extended-attributes
options="wide"
area="/default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Business_Driver/data">
<path filelist ="/data/software/iw/iw-home/tmp/upc/publish/Business_Driver/Business_Driver.lst" visit-directory="deep" delete-after-use="no"/>
</teamsite-extended-attributes>
</source>
<destinations>
<database db="wls.btwpd3.devenv1.bt.co.uk:1521:btwpd3" user="LINK_OWNER1" password="en3rgy61" vendor="oracle" update-type="standalone" state-field="state" log-level="3" delete-tracker="yes" enforce-ri="no">
<dbschema>
<group name="bdrv_to_prod_link" table="UMPC_BUS_DRV_PROP_LINK" root-group="yes">
<attrmap>
<column name="DCR_PATH" data-type="VARCHAR(500)" value-from-field="path"/>
<column name="BUSINESS_DRIVER_ID" data-type="NUMBER(9)" value-from-field="TeamSite/Metadata/Id" />
<column name="PROPOSITION_ID" data-type="NUMBER(9)" value-from-field="TeamSite/Metadata/Proposition/Automatic_Data_Back_Up.dcr/Id" />
<column name="LINK_VISIBILITY_ID" data-type="NUMBER(4)" value-from-field="TeamSite/Metadata/Visibility_Id" />
</attrmap>
<keys>
<primary-key>
<key-column name="BUSINESS_DRIVER_ID"/>
<key-column name="PROPOSITION_ID"/>
<key-column name="LINK_VISIBILITY_ID"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
<deployment name="multi" options="transactional">
<exec-deployment use="Business_Driver" />
<exec-deployment use="Proposition" />
<exec-deployment use="metadataBusiness_DriverToProposition0" />
<exec-deployment use="metadataBusiness_DriverToProposition1" />
<exec-deployment use="metadataBusiness_DriverToProposition2" />
</deployment>
</client>
</data-deploy-configuration>
the problem is that metadataBusiness_DriverToProposition0 get effectively inserted in the related table
but the other metadata....**** seem to be inserted then deleted ( see end log file trace ) :

Deployment metadataBusiness_DriverToProposition2 ok
Stat for group [bdrv_to_prod_link]:
-----------------------------------
Rows inserted : 1
Rows updated : 0
Rows deleted : 1
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Committing database [wls.btwpd3.devenv1.bt.co.uk:1521:btwpd3]...
Deployment[metadataBusiness_DriverToProposition2]
-----------------------------------
Files with EAs inserted : 0
Files with EAs updated : 1
Files with EAs deleted : 0
Files with EAs failed : 0
Files with EAs rolled back : 0
Files with EAs skipped : 0
-----------------------------------
Stat for group [bdrv_to_prod_link]:
-----------------------------------
Rows inserted : 1
Rows updated : 0
Rows deleted : 1
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Deployment[metadataBusiness_DriverToProposition1]
-----------------------------------
Files with EAs inserted : 0
Files with EAs updated : 1
Files with EAs deleted : 0
Files with EAs failed : 0
Files with EAs rolled back : 0
Files with EAs skipped : 0
-----------------------------------
Stat for group [bdrv_to_prod_link]:
-----------------------------------
Rows inserted : 1
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Deployment[metadataBusiness_DriverToProposition0]
-----------------------------------
Files with EAs inserted : 1
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
-----------------------------------
Stat for group [proposition]:
-----------------------------------
Rows inserted : 0
Rows updated : 1
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Deployment[Proposition]
-----------------------------------
DCRs inserted : 0
DCRs updated : 1
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Stat for group [bdriver]:
-----------------------------------
Rows inserted : 1
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Deployment[Business_Driver]
-----------------------------------
DCRs inserted : 1
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
any idea why ..?

thanks

Find more posts tagged with

Comments

HAL

well looking the logs it seems it's doing an update for the metadat ....xx deployments when i expect a insert ...so strange ..!!

output.pdf

Migrateduser

Maybe there is already an entry in your tables for that particular key.

regarding delete+insert its because you havent set real-update attribute

RobotoSlab-Regular.zip

HAL

will try the real-update
actually the link table is made of three id's ( being primary keys).Well one of the id's will change when deploying into database so i'm expecting to have an insert ..but apparently dd sees one of the id's is the same ( the id for the major entity ) then it tries to update

what could be one solution ..?

HAL

why such behaviour ..?
how can i get an insert ..?
*****************************************************************
extraction type=default
tuple mode=wide
area=/default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Business_Driver/data
filelist=[/data/software/iw/iw-home/tmp/upc/publish/Business_Driver/Business_Driver.lst]
/default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Business_Driver/data/Brand.dcr
Generate DirectoryContents start:Fri Aug 08 11:00:45 BST 2003
Generate DirectoryContents end :Fri Aug 08 11:00:45 BST 2003
Generate TFullEAExtractor start:Fri Aug 08 11:00:45 BST 2003
Generate TFullEAExtractor end :Fri Aug 08 11:00:45 BST 2003
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={IWOV_PROC_FLAG=true, state=Original, TeamSite/Metadata/Proposition/Cut_the_risks_of_fraud.dcr/Id=5, TeamSite/Metadata/Proposition/Automatic_Data_Back_Up.dcr/Id=3, TeamSite/Templating/DCR/Type=contentupc/Business_Driver, TeamSite/Metadata/Proposition/Secure_data_assets_with_a_storage_network.dcr/Id=2, TeamSite/Metadata/Id=1, TeamSite/Metadata/Visibility_Id=0, path=templatedata/contentupc/Business_Driver/data/Brand.dcr, TeamSite/Metadata/Proposition/Ensure_continuity_for_your_business.dcr/Id=13}
Performing Real Update
TTableSchemaHelper object for [UMPC_BUS_DRV_PROP_LINK] found in cache.
SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'BUSINESS_DRIVER_ID','PROPOSITION_ID','LINK_VISIBILITY_ID')
3 PK values retrieved from iwdeltracker for templatedata/contentupc/Business_Driver/data/Brand.dcr, /default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Business_Driver/data
TTableSchemaHelper object for [UMPC_BUS_DRV_PROP_LINK] found in cache.
TTableSchemaHelper object for [UMPC_BUS_DRV_PROP_LINK] found in cache.
TTableSchemaHelper object for [UMPC_BUS_DRV_PROP_LINK] found in cache.
SelectCurrentRows Smiley Frustrated

ELECT BUSINESS_DRIVER_ID,PROPOSITION_ID,LINK_VISIBILITY_ID FROM UMPC_BUS_DRV_PROP_LINK WHERE BUSINESS_DRIVER_ID IN (? ) AND PROPOSITION_ID IN (? ) AND LINK_VISIBILITY_ID IN (? ) ORDER BY BUSINESS_DRIVER_ID,PROPOSITION_ID,LINK_VISIBILITY_ID
Index: 1, value: 1
Index: 2, value: 3
Index: 3, value: 0
SelectCurrentRows: 1 rows selected.
TTableSchemaHelper object for [UMPC_BUS_DRV_PROP_LINK] found in cache.
GetCurrentRowsFromGroupInfo: 1 rows selected from UMPC_BUS_DRV_PROP_LINK
INSERT INTO UMPC_BUS_DRV_PROP_LINK(BUSINESS_DRIVER_ID,PROPOSITION_ID,LINK_VISIBILITY_ID) VALUES (?,?,?)
Column: BUSINESS_DRIVER_ID, field: TeamSite/Metadata/Id, Index: 1,Converting '1' to DECIMAL
Column: PROPOSITION_ID, field: TeamSite/Metadata/Proposition/Cut_the_risks_of_fraud.dcr/Id, Index: 2,Converting '5' to DECIMAL
Column: LINK_VISIBILITY_ID, field: TeamSite/Metadata/Visibility_Id, Index: 3,Converting '0' to DECIMAL
DELETE FROM UMPC_BUS_DRV_PROP_LINK WHERE BUSINESS_DRIVER_ID = ? AND PROPOSITION_ID = ? AND LINK_VISIBILITY_ID = ?
Column: BUSINESS_DRIVER_ID, field: null, Index: 1,Converting '1' to DECIMAL
Column: PROPOSITION_ID, field: null, Index: 2,Converting '3' to DECIMAL
Column: LINK_VISIBILITY_ID, field: null, Index: 3,Converting '0' to DECIMAL
DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
3 rows inserted into iwdeltracker for templatedata/contentupc/Business_Driver/data/Brand.dcr, /default/main/bt/btw/upc/90_tsdev0/STAGING/templatedata/contentupc/Business_Driver/data
-- Updated
Filelist walk done
Deployment metadataBusiness_DriverToProposition2 ok
************************************************************************

output.pdf

Migrateduser

There is already an entry in the database for the keys you are specifying hence an update. If DD finds an entry for the keys you specify we will definitely do an update , insert with same keys will cause a unique constraint violation

HAL

there's already an entry for one of the keys not the three keys ...i'm sorry but i think it should be an insert whatever ...
how to figure the following situation
one "product" instance( one specific ID) linked to many isntances of another data type ( with their own ID)

IDprod01 IDSegment01 0
IDprod01 IDSegment04 1
IDprod01 IDSegment02 0

thanks