We are trying to convert DCR datadeploy to EA's datadeploy.
I have set all the extended attributes and try to data deploy to my database.
Here is the output of datadeploy which i get(I've attached the configuration file):
DataDeploy Version 5.6.0 Build 14707 Interwoven 20021211
Database Vendor set to oracle
Max Identifier length set to 28 characters.
SQL datatype for column documentid is VARCHAR(128)
SQL datatype for column id is VARCHAR(32)
SQL datatype for column code is VARCHAR(32)
SQL datatype for column content_owner is VARCHAR(8)
SQL datatype for column configmgmt is VARCHAR(50)
SQL datatype for column name is VARCHAR(255)
SQL datatype for column filesize is NUMBER(11)
SQL datatype for column popiclassification is VARCHAR(50)
SQL datatype for column lastrevlevel is VARCHAR(50)
SQL datatype for column disclaimertype is VARCHAR(50)
SQL datatype for column registrationtype is VARCHAR(60)
SQL datatype for column releaselevel is VARCHAR(20)
SQL datatype for column moderator_txt is VARCHAR(50)
SQL datatype for column keywords is VARCHAR(4000)
SQL datatype for column iw_vpath is VARCHAR(500)
SQL datatype for column LOGON_REQUIRED is CHAR(1)
SQL datatype for column linkurl is VARCHAR(512)
SQL datatype for column SECURED_CONTENT is CHAR(1)
SQL datatype for column SEARCH_SUMMARY is CHAR(1)
SQL datatype for column keywords is VARCHAR(4000)
SQL datatype for column description is VARCHAR(4000)
SQL datatype for column IMAGE_DISPLAY_FLAG is CHAR(1)
# of columns: 22
# of primary key columns specified: 1
SQL datatype for column COLLATERAL_ID is VARCHAR(32)
SQL datatype for column COMPANY_ID is VARCHAR(32)
SQL datatype for column CREATE_USERID is VARCHAR(8)
# of columns: 3
# of primary key columns specified: 2
# of foreign key columns specified: 1
# of groups defined in element: 2
Area VPath:/default/main/sps/external/documentation/WORKAREA/workarea
Setting up TDbSchemaAgent.
>>> Loading drivers <<<
url : ebizvhdev.sps.mot.com:50004
PSDEC
login : ebizdev_workarea
login timeout=3
Connecting to the database...
Try connecting using jdbc
racle:thin:
@ebizvhdev.sps.mot.com:50004
PSDEC...
Connected to jdbc
racle:thin:
@ebizvhdev.sps.mot.com:50004
PSDEC
Driver Oracle JDBC driver
Version 9.0.1.1.0
Connected to [ebizvhdev.sps.mot.com:50004
PSDEC]
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'
SQL Exists check: SELECT SYSDATE FROM DUAL
Table [COLLATERAL] exists.
SQL Exists check: SELECT SYSDATE FROM DUAL
Table [COLLATERAL_VENDOR] exists.
Running deployment [ea_to_db]
extraction type=full
tuple mode=wide
area=/default/main/sps/external/documentation/WORKAREA/workarea
filelist=[/u03/iw-home/tmp/sps_wf_docs_119562.lst]
/default/main/sps/external/documentation/WORKAREA/workarea/32bit/doc/users_guide
/MC92600UM.pdf
Generate DirectoryContents start:Mon Oct 11 09:23:53 MST 2004
Generate DirectoryContents end :Mon Oct 11 09:23:53 MST 2004
Generate TFullEAExtractor start:Mon Oct 11 09:23:53 MST 2004
Generate TFullEAExtractor end :Mon Oct 11 09:23:53 MST 2004
Path not found -- interpret as 'NotPresent'
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={state=NotPresent, path=32bit/doc/users_guide/MC92600UM.pdf}
TTableSchemaHelper not found in cache for [COLLATERAL]. Creating new.
SELECT
ELECT documentid,code,content_owner,configmgmt,name,filesize,popiclassif
ication,lastrevlevel,disclaimertype,registrationtype,releaselevel,moderator_txt,
keywords,iw_vpath,LOGON_REQUIRED,linkurl,SECURED_CONTENT,SEARCH_SUMMARY,keywords
,description,IMAGE_DISPLAY_FLAG,id FROM COLLATERAL WHERE iw_vpath = '32bit/doc/u
sers_guide/MC92600UM.pdf'
BuildTuples:executeQuery returned valid result set
TTableSchemaHelper object for [COLLATERAL] found in cache.
BuildTuples:BuildRows returned: true
-- Deleted
Filelist walk done
Stat for group [collateral]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [collateral_vendor]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Committing database [ebizvhdev.sps.mot.com:50004
PSDEC]...
Deployment[ea_to_db]
-----------------------------------
Files with EAs inserted : 0
Files with EAs updated : 0
Files with EAs deleted : 1
Files with EAs failed : 0
Files with EAs rolled back : 0
Files with EAs skipped : 0
-----------------------------------
Started : Mon Oct 11 09:23:51 MST 2004
Finished: Mon Oct 11 09:23:54 MST 2004
### IWDataDeploy DONE ###
It doesn't give me any error but it doesn't push the record in the database.
Could someone please help me out in this.
Thanx.
