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; } } }

Data Deploy Deployment Issue

sabih

I am getting a " Failed to start DataDeploy" error message while deploying a DCR to database while running the following command:

./iwodcmd start TVListings_dd.xml -k iwdd=basearea -k mybasearea='/default/main/AETV_redesign/AETV_Content/WORKAREA/main' -k mytemplatepath='templatedata/TVlistings/Servies/data/test001'

Following is the error message from the log file:
--------------------------------------------------------

ENG: 2005-11-02 16:31:26 EST GMT-05:00 Proceed to execute the database deployment

ENG: 2005-11-02 16:31:26 EST GMT-05:00 Exec'ing [/teamsite/iw-home/Deploy/OpenDeployNG/lib/iwddexec iwdd=basearea mybasearea=/default/main/AETV_redesign/AETV_Content/WORKAREA/main mytemplatepath=templatedata/TVlistings/Servies/data/test001 cfg=/teamsite/iw-home/Deploy/OpenDeployNG/conf/TVListings_dd.xml need-result=yes depuuid=062d7830-4be8-11da-98ba-eef91f65132f leglabel=database svrlogfile=/teamsite/iw-home/Deploy/OpenDeployNG/log/src.TVListings_dd.basearea.cmsdev.to.database.log]
DD:In Thread: Thread[main,5,main]
DD:Run in Thread: Thread[DDThread,5,main]
DD Smiley Very Happy

atabase Vendor set to oracle
DD Smiley Frustrated

QL datatype for column id_show is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column genre is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column series_name is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column umbrella_name is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column display_on_allshows is VARCHAR(255)
DD:# of columns: 5
DD:# of primary key columns specified: 1
DD Smiley Frustrated

QL datatype for column id_episode is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column id_show is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column piece_title is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column tv_rating is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column closed_captioned is VARCHAR(255)
DD:# of columns: 5
DD:# of primary key columns specified: 1
DD Smiley Frustrated

QL datatype for column id_episode is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column start_time is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column duration is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column start_date is VARCHAR(255)
DD Smiley Frustrated

QL datatype for column duration is VARCHAR(255)
DD:# of columns: 5
DD:# of groups defined in <dbschema> element: 3
DD:[Wed Nov 02 16:31:28 EST 2005] Begin executing basearea
DD:Area VPath:/default/main/AETV_redesign/AETV_Content/WORKAREA/main
DD Smiley Frustrated

etting up TDbSchemaSynchronizer.
DD Smiley Embarassed

>> Loading drivers <<<
DD:url : jdbc Smiley Surprised

racle:thin:@192.168.211.19:1521:histcms
DD:login : AETN_WEB_RO
DD:login timeout=3
DD:Connecting to the database...
DD:Try connecting using jdbc Smiley Surprised

racle:thin:@192.168.211.19:1521:histcms...
DD:
Connected to jdbc Smiley Surprised

racle:thin:@192.168.211.19:1521:histcms
DD: Driver Oracle JDBC driver
DD: Version 8.1.7.0.0
DD:Connected to [192.168.211.19:1521:histcms]
DD Smiley Frustrated

ELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
DD:Building mappings cache...
DD:Built mapping cache(s) successfully.
DD:# column mappings: 0
DD:# table mappings: 0
DD:# view mappings: 0
DD:# constraint mappings: 0
DD:ERROR:Error: Failed to start DataDeploy
ENG: 2005-11-02 16:31:29 EST GMT-05:00 Database Deployment error state: false
ENG: 2005-11-02 16:31:29 EST GMT-05:00 Database deployment execution returned -1

ENG: 2005-11-02 16:31:29 EST GMT-05:00 <<< Completed database deployment Invocation>>>

ENG: 2005-11-02 16:31:29 EST GMT-05:00 Job ID=m17 Deployment leg=database Elapsed Time=2269 ms <<<
ENG: 2005-11-02 16:31:29 EST GMT-05:00 End logfile [/teamsite/iw-home/Deploy/OpenDeployNG/log/src.TVListings_dd.basearea.cmsdev.to.database.log]

Find more posts tagged with

Comments

Migrateduser

What's the version of DD/OD?

Is this happening consistently when rerunning the same deployment... i.e. DD appears to start, but then fails... is the error message happening at the same point each time?

Is this a user-defined schema (as opposed to a wide table deployment)?

Are you able to create tables in the database ... I *think* its failing somewhere in the database query/creation stage.

Mariam

sabih

-OD 6.02.
-Its happening each time I try to deploy.
-It is a Teamsite DCR.
-The tables is already created. I am just trying to populate those tables.

Data Deploy Config File for tables "tvlisting_show", "tvlisting_airing", "tvlisting_episode":
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<data-deploy-configuration>
<data-deploy-elements filepath="/teamsite/iw-home/Deploy/OpenDeployNG/etc/database.xml" />
<client>
<deployment name="basearea">
<source>

<teamsite-templating-records options = "wide" area = "$mybasearea">
<path name = "$mytemplatepath" visit-directory = "deep" />
</teamsite-templating-records>
</source>
<destinations>

<database use ="aetv-preview" update-type = "base" state-field = "state" deleted-tracker="yes">
<search results-suppress-vpath ="f" results-program = "" />
<dbschema>
<group name="TVLISTING_SHOW" table="tvlisting_show" root-group="yes">
<attrmap>
<column name="id_show" data-type="VARCHAR(255)" allows-null="no" is-url="no" value-from-field="series/0/seriesID" />

<column name="genre" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="series/0/genre" />
<column name="series_name" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="series/0/seriesName" />
<column name="umbrella_name" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="series/0/umbrellaName" />
<column name="display_on_allshows" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="series/0/doNotDisplayOnAllShowsPage" />

</attrmap>
<keys >
<primary-key >
<key-column name="id_show" />
</primary-key>
</keys>
</group>
<group name="TVLISTING_EPISODE" table="tvlisting_episode" root-group="no">
<attrmap>
<column name="id_episode" data-type="VARCHAR(255)" value-from-field="episodedetail/0/PieceNumber" allows-null="yes" is-url="no"/>
<column name="id_show" data-type="VARCHAR(255)" value-from-field="episodedetail/0/SeriesID" allows-null="no" is-url="no"/>

<column name="piece_title" data-type="VARCHAR(255)" value-from-field="episodedetail/0/PieceTitle" allows-null="yes" is-url="no"/>
<column name="tv_rating" data-type="VARCHAR(255)" value-from-field="episodedetail/0/TVRating" allows-null="yes" is-url="no"/>
<column name="closed_captioned" data-type="VARCHAR(255)" value-from-field="episodedetail/0/ClosedCaptioned" allows-null="yes" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="id_episode"/>
</primary-key>
</keys>
</group>
<group name="TVLISTING_AIRING" table="tvlisting_airing" root-group="no">
<attrmap>
<column name="id_episode" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="airing/0/PieceNumber" />

<column name="start_time" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="airing/0/Airings/0/startTime" />
<column name="duration" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="airing/0/Airings/0/endTime" />
<column name="start_date" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="airing/0/Airings/0/startDate" />
<column name="duration" data-type="VARCHAR(255)" allows-null="yes" is-url="no" value-from-field="airing/0/Airings/0/endDate" />

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

Migrateduser

This looks like a typical deployment... so I can't tell anything without being able to reproduce it.

Do you have a case open with Support?

Mariam

sabih

I am listing the commands that I rab inorder to create my deployment config and to deploy my teamsite DCR. Please let me know if I missed any thing.

1. iwsyncdb -dbschemagen /default/main/XYZ_redesign/XYZ_Content/WORKAREA/main -dcfile /TVListings/Series (dbschema)
2. /iwsyncdb -ddgen /default/main/XYZ_redesign/XYZ_Content/WORKAREA/main TVListings/Series (creates TVListings_dd.cfg --> change to xml ext and copied over to odhome/OpenDeployNG/conf directory)
3. /iwodcmd start TVListings_dd.xml -k iwdd=basearea -k mybasearea='/default/main/XYZ_redesign/XYZ_Content/WORKAREA/main' -k mytemplatepath='templatedata/TVListings/Series/data/test001'
Getting a PK Column missing exeption error although that value is showing up in showing up in TUPLE info in the log file.

ERROR:
DD:ERROR:Values for PK column [id_show] missing in [templatedata/TVListings/Series/data/test001].
DD:ERROR:Exception occured: Values for PK column [id_show] missing in [templatedata/TVListings/Series/data/test001].
com.interwoven.dd100.dd.InvalidSourceTupleException: Values for PK column [id_show] missing in [templatedata/TVListings/Series/data/test001].
..
DD:ERROR:WriteTuple failure to consumer[0]
DD:ERROR:Unable to process TeamSite source templatedata/TVListings/Series/data/test001
DD:ERROR:deployment [basearea] FAILED
DD:Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DD:UPDATE iwtracker SET UPDATETIME='Thu Nov 03 18:01:34 EST 2005' WHERE NAME='TVLISTING_SHOW'
DD:1 row(s) updated.

DD Smiley Frustrated

tat for group [Series]:
DD:-----------------------------------
DD: Rows inserted : 0
DD: Rows updated : 0
DD: Rows deleted : 0
DD: Rows failed : 0
DD: Rows rolled back : 0
DD: Rows skipped : 0
DD:-----------------------------------
DD:Rollback database [192.168.211.19:1521:histcms]...
DD Smiley Very Happy

eployment[basearea]
DD:-----------------------------------
DD: DCRs inserted : 0
DD: DCRs updated : 0
DD: DCRs deleted : 0
DD: DCRs failed : 0
DD: DCRs rolled back : 0
DD: DCRs skipped : 0
DD:-----------------------------------
DD Smiley Frustrated

tarted : Thu Nov 03 18:01:32 EST 2005
DD:Finished: Thu Nov 03 18:01:34 EST 2005
ENG: 2005-11-03 18:01:34 EST GMT-05:00 Database Deployment error state: false
ENG: 2005-11-03 18:01:34 EST GMT-05:00 Database deployment execution returned -1

Migrateduser

>> Getting a PK Column missing exeption error although that value is showing up in showing up in TUPLE info in the log file.

I don't see the TUPLE info that you are referring to. can you attach the entire log, or post the part that shows what the value of the tuple is? Also post the DCR.

Mariam

jscalendar.zip

sabih

Attached is the datacapture.cfg.

sabih

Attached is the DataDeploy Config.

sabih

Attached is the error log file.

Migrateduser

The problem is that you need /0 at the end of your field names. ex: "series/0/id_show/0" instead of "series/0/id_show"

mquarles

If you aren't passing in the specific directory that contains your DCR(s) to be deployed, but rather passing in a parent directory, you might try passing in the specific directory. This solved my very similar issue, detailed in the post at the following URL:
http://devnet.interwoven.com/forums/cgi-bin/showflat.pl?Cat=&Board=PRODUCTS_OPENDEPLOY&Number=69717&page=0&view=collapsed&sb=5&o=&part=