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
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
racle:thin:
@10.25.2.22:1521:WPDEV...
Connected to jdbc
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:Thu Sep 04 20:47:09 SGT 2003
Generate DirectoryContents end :Thu Sep 04 20:47:09 SGT 2003
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={Feature Text=Feature text Trial for Database, 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, Multimedia Section/0/Feature Object ID=491, Show Details/0/SHOW_ID=5, Show Details/0/Feature Detail ID=698, Expire Date=02/02/2003 10:20 AM, Multimedia Section/0/Picture=20030811155158_Feat-JolinTsai.jpg, FeatureID=379, path=templatedata/starhub/feature/data/379, Release Date=02/02/2003 10:20 AM, tempA=698, Multimedia Section/0/Feature Object Type=1, Small Picture=img_mid_GoWest.jpg, Language=3, Multimedia Section/0/Align With=1, Monthly Highlight=1, temp=491, Multimedia Section/0/Alignment=3, IWOV_PROC_FLAG=true, Show Details/0=, Big Picture=img_big_GoWest.jpg}
TDbSchemaGroupCfg:RowsExistForTuple
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: FeatureID, Index: 1,Converting '379' to DECIMAL
Column: FEATURE_MONTHLY_HIGHLIGHT, field: Monthly Highlight, Index: 2,Converting '1' 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 'img_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
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 : Thu Sep 04 20:47:08 SGT 2003
Finished: Thu Sep 04 20:47:09 SGT 2003
### IWDataDeploy FAILED ###
