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

Datadeploy Error

dinsin

The following is the error i m getting in my DD script.

Env: TS 5.5.2 on solaris, DD 5.6 Oracle 8.1.7

Adding the datacapture.cfg file after the error message in continution..
Also attaching the deployment configuration file with this.

Pl. Help me to solve this error.

===========================================

DataDeploy Version 5.6.0 Build 14707 Interwoven 20021211
Database Vendor set to oracle
SQL datatype for column FEATURE_ID is DECIMAL(5)
SQL datatype for column FEATURE_MONTHLY_HIGHLIGHT is DECIMAL(1)
SQL datatype for column FEATURE_RELEASE_DATE is DATE(7)
SQL datatype for column FEATURE_EXPIRE_DATE is DATE(7)
SQL datatype for column FEATURE_BIG_PICTURE is VARCHAR(50)
SQL datatype for column FEATURE_SMALL_PICTURE is VARCHAR(50)
SQL datatype for column FEATURE_TITLE is VARCHAR(80)
SQL datatype for column FEATURE_BLURB is VARCHAR(2000)
ERROR:Invalid column element. name-from-field not allowed.
SQL datatype for column FEATURE_LANGUAGE_ID is DECIMAL(5)
# of columns: 9
# of primary key columns specified: 1
SQL datatype for column FEATURE_OBJECT_ID is DECIMAL(10)
SQL datatype for column FEATURE_ID is DECIMAL(10)
SQL datatype for column FEATURE_OBJECT_PARA is DECIMAL(3)
SQL datatype for column FEATURE_OBJECT_ALIGN is DECIMAL(1)
SQL datatype for column FEATURE_OBJECT is VARCHAR(50)
SQL datatype for column FEATURE_OBJECT_TYPE is VARCHAR(50)
# of columns: 6
# of primary key columns specified: 1
# of foreign key columns specified: 1
SQL datatype for column SHOW_ID is DECIMAL(10)
# of columns: 1
# of primary key columns specified: 1
SQL datatype for column FEATURE_DETAIL_ID is DECIMAL(5)
SQL datatype for column FEATURE_ID is DECIMAL(5)
SQL datatype for column SHOW_ID is DECIMAL(10)
# of columns: 3
# of primary key columns specified: 1
# of foreign key columns specified: 2
# of groups defined in <dbschema> element: 4
Area VPath:/default/main/test/WORKAREA/test
Setting up TDbSchemaAgent.
>>> Loading drivers <<<
url : 10.25.2.22:1521:WPDEV
login : interwoven
login timeout=3
Connecting to the database...
Try connecting using jdbc Smiley Surprised

racle:thin:@10.25.2.22:1521:WPDEV...

Connected to jdbc Smiley Surprised

racle:thin:@10.25.2.22:1521:WPDEV
Driver Oracle JDBC driver
Version 9.0.1.1.0
Connected to [10.25.2.22:1521:WPDEV]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
Building mappings cache...
Built mapping cache(s) successfully.
# column mappings: 0
# table mappings: 0
# view mappings: 0
# constraint mappings: 0
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
SELECT * FROM USER_TABLES WHERE TABLE_NAME='FEATURE'
Table [FEATURE] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='SHOW'
Table [SHOW] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='FEATURE_OBJECT'
Table [FEATURE_OBJECT] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='FEATURE_DETAIL'
Table [FEATURE_DETAIL] exists.
Running deployment [feature]
extraction type=default
tuple mode=wide
area=/default/main/test/WORKAREA/test
/default/main/test/WORKAREA/test/templatedata/starhub/feature/data
Generate DirectoryContents start:Fri Sep 05 16:25:36 SGT 2003
Generate DirectoryContents end :Fri Sep 05 16:25:36 SGT 2003
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={Feature Text=qwewqeqwe werr serf setf werf, Multimedia Section/0=, state=Original, Blurb=While some Asian stars have decided to
give Hollywood a big miss, these six are
keen on getting their slice of the
American pie., Title=Go West, Show Details/0/FEATURE_DETAIL_ID=698, Show Details/0/SHOW_ID=5, Expire Date=02/02/2003 10:20 AM, Multimedia Section/0/Picture=20030811155158_Feat-JolinTsai.jpg, FEATURE_ID=379, path=templatedata/starhub/feature/data/379, Release Date=02/02/2003 10:20 AM, tempA=698, Multimedia Section/0/Feature Object Type=1, Multimedia Section/0/FEATURE_OBJECT_ID=491, Small Picture=img_mid_GoWest.jpg, Language=3, Multimedia Section/0/Align With=1, Monthly Highlight=, temp=491, Multimedia Section/0/Alignment=3, IWOV_PROC_FLAG=true, Show Details/0=, Big Picture=big_GoWest.jpg}
TDbSchemaGroupCfg:RowsExistForTuple Smiley Frustrated

ELECT COUNT(*) FROM FEATURE WHERE FEATURE_ID IN ( ? )
TTableSchemaHelper not found in cache for [FEATURE]. Creating new.
TTableSchemaHelper object for [FEATURE] found in cache.
INSERT:INSERT INTO FEATURE(FEATURE_ID,FEATURE_MONTHLY_HIGHLIGHT,FEATURE_RELEASE_DATE,FEATURE_EXPIRE_DATE,FEATURE_BIG_PICTURE,FEATURE_SMALL_PICTURE,FEATURE_TITLE,FEATURE_BLURB,FEATURE_LANGUAGE_ID) VALUES (?,?,?,?,?,?,?,?,?)
Column: FEATURE_ID, field: FEATURE_ID, Index: 1,Converting '379' to DECIMAL
Column: FEATURE_MONTHLY_HIGHLIGHT, field: Monthly Highlight, Index: 2,Converting '' to DECIMAL
Column: FEATURE_RELEASE_DATE, field: Release Date, Index: 3,Converting '02/02/2003 10:20 AM' to TIMESTAMP
Column: FEATURE_EXPIRE_DATE, field: Expire Date, Index: 4,Converting '02/02/2003 10:20 AM' to TIMESTAMP
Column: FEATURE_BIG_PICTURE, field: Big Picture, Index: 5,Converting 'big_GoWest.jpg' to VARCHAR
Column: FEATURE_SMALL_PICTURE, field: Small Picture, Index: 6,Converting 'img_mid_GoWest.jpg' to VARCHAR
Column: FEATURE_TITLE, field: Title, Index: 7,Converting 'Go West' to VARCHAR
Column: FEATURE_BLURB, field: Blurb, Index: 8,Converting 'While some Asian stars have decided to
give Hollywood a big miss, these six are
keen on getting their slice of the
American pie.' to VARCHAR
Column: FEATURE_LANGUAGE_ID, field: Language, Index: 9,Converting '3' to DECIMAL
TTableSchemaHelper not found in cache for [SHOW]. Creating new.
INSERT:INSERT INTO SHOW(SHOW_ID) VALUES (?)
Column: SHOW_ID, field: Show Details/0/SHOW_ID, Index: 1,Converting '5' to DECIMAL

*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-00001: unique constraint (INTERWOVEN.SHOW_PK) violated

Vendor Error Code: 1
SQL state: 23000
*******************************************************

*******STACK TRACE*************
ERROR Smiley Very Happy

oInsert() failed for group [SHOW].
-- Failed
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source templatedata/starhub/feature/data
ERROR:deployment [feature] FAILED
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Stat for group [FEATURE]:
-----------------------------------
Rows inserted : 1
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [FEATURE_OBJECT]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [SHOW]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [FEATURE_DETAIL]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [10.25.2.22:1521:WPDEV]...
Deployment[feature]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Fri Sep 05 16:25:35 SGT 2003
Finished: Fri Sep 05 16:25:37 SGT 2003

### IWDataDeploy FAILED ###

================================
==================================
DATACAPTURE>CFG(DCT)
====================================
====================================

<?xml version="1.0" encoding="UTF-8" ?>
<data-capture-requirements type= "content" name= "feature">


<ruleset name= "feature">

<description>Feature Entry Form</description>

<item name="Monthly Highlight">
<database data-type="NUMBER(1)"/>
<checkbox required="f" >
<option value="1" label="" />
</checkbox>
</item>

<item name="FEATURE_ID">
<description>User will get the Auto generated FeatureId-Not To Be DELETED !!</description>

<database data-type="NUMBER(5)"/>
<inline command="/export/interwoven/iw-home/iw-perl/bin/iwperl /export/interwoven/iw-home/iw-perl/bin/feature_id.ipl"/>

</item>

<item name="Title">
<database data-type="VARCHAR2(80)" />
<text required="t" maxlength="80" size="35"/>
</item>

<item name="Big Picture" >
<database data-type="VARCHAR2(50)" />
<browser extns=".gif,.jpg" initial-dir=".*" >
<cgi-callout url="/iw-bin/iw_cgi_wrapper.cgi/Preview_Image.cgi" label="Preview" window-features="width=720, height=300,resizable=yes,toolbar=no,scrollbars=yes"/>
</browser>
</item>

<item name="Small Picture" >
<database data-type="VARCHAR2(50)" />
<browser extns=".gif,.jpg" initial-dir=".*" >
<cgi-callout url="/iw-bin/iw_cgi_wrapper.cgi/Preview_Image.cgi" label="Preview" window-features="width=720, height=300,resizable=yes,toolbar=no,scrollbars=yes"/>
</browser>
</item>

<item name="Language">
<database data-type="NUMBER(5)" />
<select required="t">
<option value="2" label="Chinese" />
<option value="3" label="English" />
<option value="7" label="French" />
<option value="4" label="German" />
<option value="6" label="Indian" />
<option value="8" label="Japanese" />
<option value="16" label="Korean" />
<option value="5" label="Malay" />
<option value="9" label="Others" />
</select>
</item>

<item name="Blurb">
<database data-type="VARCHAR2(2000)" />
<textarea cols="40" required="f" rows="3" rtf="f" wrap="off" maxlength="2000" />
</item>

<item name="Release Date">
<database data-type="DATE" />
<description>Date and Time Format: MM/dd/YYYY hh:mm AM/PM</description>
<text required="t" maxlength="20" size="30"
validation-regex="^[0-1][0-9]/[0-3][0-9]/[0-9][0-9][0-9][0-9] [0-1][0-9]:[0-6][0-9] [A P]$" />
</item>

<item name="Expire Date">
<database data-type="DATE" />
<description>Date and Time Format: MM/dd/YYYY hh:mm AM/PM</description>
<text required="t" maxlength="20" size="30"
validation-regex="^[0-1][0-9]/[0-3][0-9]/[0-9][0-9][0-9][0-9] [0-1][0-9]:[0-6][0-9] [A P]$" />
</item>

<item name="Feature Text">
<database data-type="LONG" />
<textarea cols="40" required="f" rows="5" />
</item>


<item name="Multimedia Section">
<database deploy-column="f" />
<replicant min="1" max="5">

<item name="FEATURE_OBJECT_ID" >
<description>Please Get the Auto generated Feature Object Id</description>
<database data-type="NUMBER(10)" />
<text required="t" maxlength="10" size="10" >
<cgi-callout url="/iw-bin/iw_cgi_wrapper.cgi/feature_object_id.cgi" label="Get ObjectID" window-features="width=1, height=1,resizable=no,toolbar=no,scrollbars=no"/>
</text>
</item>

<item name="Feature Object Type">
<database data-type="VARCHAR2(50)" />
<select required="f">
<option label="--Please select---" />
<option value="1" label="Type1" />
<option value="2" label="Type2" />

</select>
</item>

<item name="Picture" >
<database data-type="VARCHAR2(50)" />
<browser extns=".gif,.jpg" initial-dir=".*" >
<cgi-callout url="/iw-bin/iw_cgi_wrapper.cgi/Preview_Image.cgi" label="Preview" window-features="width=720, height=300,resizable=yes,toolbar=no,scrollbars=yes"/>
</browser>
</item>

<item name="Align With">
<database data-type="NUMBER(3)" />
<select required="f">
<option value="1" label="Paragraph 1" />
</select>
</item>

<item name="Alignment">
<database data-type="NUMBER(1)" />
<select required="f">
<option value="2" label="Center" />
<option value="3" label="Left" />
<option value="1" label="Right" />
</select>
</item>
</replicant>
</item>



<item name="Show Details">
<database deploy-column="f" />
<replicant min="1" max="5">

<item name="FEATURE_DETAIL_ID" >
<description>Please Get the Auto generated Feature Detail Id</description>
<database data-type="NUMBER(5)" />
<text required="t" maxlength="5" size="5" >
<cgi-callout url="/iw-bin/iw_cgi_wrapper.cgi/feature_detail_id.cgi" label="Get DetailID" window-features="width=1, height=1,resizable=no,toolbar=no,scrollbars=no"/>
</text>
</item>

<item name="SHOW_ID">
<description>Please Get the Auto generated Show ID</description>
<database data-type="NUMBER(10)" />
<text required="t" maxlength="10" size="10" >
<cgi-callout url="/iw-bin/Related_show.cgi" label="Related Show" window-features="width=600,height=400,resizable=yes,toolbar=no,scrollbars=yes" />
</text>
</item>

</replicant>
</item>

<item name="temp">
<hidden>
<description>used for auto generating the Feature object id</description>
<text size="30"/>
</hidden>
</item>

<item name="tempA">
<hidden>
<description>used for auto generating the Feature Detail id</description>
<text size="30"/>
</hidden>
</item>

</ruleset>
</data-capture-requirements>

Find more posts tagged with

Comments

Migrateduser

Choose keys correctly, Table show has only one key show_id which does not seem to be unique. Please Fix your Relational schema wrt your DCT.
- <group name="SHOW" table="SHOW" root-group="no">
- <attrmap>
<column name="SHOW_ID" data-type="DECIMAL(10)" value-from-field="Show Details/[0-4]/SHOW_ID" is-replicant="yes" allows-null="no" is-url="no" />
</attrmap>
- <keys>
- <primary-key>
<key-column name="SHOW_ID" />
</primary-key>
</keys>
</group>

dinsin

hi,

Thks psank !!

Could you please elaborate on the "Relational schema wrt my DCT". I'm unable to get your point properly.

Also my dbschema.cfg is not getting validated with respect to DCT.

Thks again.