Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
datadeploy cannot populate DCR
nyan
DD cannot deploy, what I am expected is one row be added into database regarding a the DCR (xml file). Let me know if more information I can provide in solving this. The cmd and log as following. Thx in advance.
==================================================
Y:\>c:\dd-home\bin\iwdd.ipl cfg=C:\dd-home\conf\countryportal\countryportal.cfg
deployment=fragment
DataDeploy Version 5.5.2 Build 9275 Interwoven 20020617
TeamSite_Templating data_root is set to templatedata
Database Vendor set to ibm
SQL datatype for column FID is VARCHAR(128)
SQL datatype for column CREATOR is VARCHAR(32)
# of columns: 2
# of primary key columns specified: 1
# of groups defined in <dbschema> element: 1
Area VPath:/iw-mount/default/main/CountryPortal/Fragments/us_en/EDITION/0001
Setting up TDbSchemaAgent.
>>> Loading drivers <<<
Loading COM.ibm.db2.jdbc.app.DB2Driver ..
url : TS4IBM
login : ning
login timeout=3
Connecting to the database...
Try connecting using jdbc:db2:TS4IBM...
Connected to jdbc:db2:TS4IBM
Driver IBM DB2 JDBC 2.0 Type 2
Version 07.02.0003
Connected to [TS4IBM]
SELECT * FROM SYSIBM.SYSTABLES WHERE 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 SYSIBM.SYSTABLES WHERE NAME = 'IWDELTRACKER'
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'FRAGMENT'
Table [FRAGMENT] exists.
Running deployment [fragment]
extraction type=default
tuple mode=wide
area=/iw-mount/default/main/CountryPortal/Fragments/us_en/EDITION/0001
/iw-mount/default/main/CountryPortal/Fragments/us_en/EDITION/0001/xmlcontent/EMP
LOYEEDIR_TEXT/data/48.06c2fe300f1092a473e007fba-tfrg.xml
Generate DirectoryContents start:Tue Feb 04 17:04:16 EST 2003
Generate DirectoryContents end :Tue Feb 04 17:04:17 EST 2003
Generate TCustomDCRTupleProducer start:Tue Feb 04 17:04:17 EST 2003
Generate TCustomDCRTupleProducer end :Tue Feb 04 17:04:17 EST 2003
Path not found -- interpret as 'NotPresent'
Building replicant order column information.
Building replicant order column information... Done.
TUPLE={state=NotPresent, path=xmlcontent\EMPLOYEEDIR_TEXT\data\48.06c2fe300f1092
a473e007fba-tfrg.xml}
Starting SchemaHelper Cache Cleanup Thread...
TTableSchemaHelper not found in cache for [FRAGMENT]. Creating new.
SELECT NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = ?
SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA
= ?
0 PK values retrieved from iwdeltracker for xmlcontent\EMPLOYEEDIR_TEXT\data\48.
06c2fe300f1092a473e007fba-tfrg.xml, /iw-mount/default/main/CountryPortal/Fragmen
ts/us_en/EDITION/0001
DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
-- Deleted
Stat for group [EMPLOYEEDIR_PAGE]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Committing database [TS4IBM]...
Deployment[fragment]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 1
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Tue Feb 04 17:04:16 EST 2003
Finished: Tue Feb 04 17:04:18 EST 2003
### IWDataDeploy DONE ###
==================================================
Find more posts tagged with
Comments
Migrateduser
Can you double check your area and path elements, DD doesnt seem to find the xml file, based on the area/path provided in the config file
area=/iw-mount/default/main/CountryPortal/Fragments/us_en/EDITION/0001
/iw-mount/default/main/CountryPortal/Fragments/us_en/EDITION/0001/xmlcontent/EMP
LOYEEDIR_TEXT/data/48.06c2fe300f1092a473e007fba-tfrg.xml
Generate DirectoryContents start:Tue Feb 04 17:04:16 EST 2003
Generate DirectoryContents end :Tue Feb 04 17:04:17 EST 2003
Generate TCustomDCRTupleProducer start:Tue Feb 04 17:04:17 EST 2003
Generate TCustomDCRTupleProducer end :Tue Feb 04 17:04:17 EST 2003
Path not found -- interpret as 'NotPresent'
nyan
Yes, it does exist. Any syntax wrong? I did try by using '/' and '\'. Does any other debug method I can use?
Migrateduser
If you are sure the file exists, does the user running DD have permissions to access that specific file.
Migrateduser
One more thing that could be wrong:
You are deploying from a source which is <teamsite-extended-attributes> and you dont have any Extended attributes set on the file specified.
nyan
It seem no matter how i sepecify the 'area' and 'path', running process always in search 'Y:/default/main/...'. (My TS install in Window)
It should be 'Y:\default\main\...', I am wondering if this does the matter.
Migrateduser
When you said your path was =/iw-mount/default/main/CountryPortal/Fragments/us_en/EDITION/0001, I thought you were on solaris. If you are on solaris this path is fine. If you are on windows you should not add /iwmnt in your vpath, just /default/main/... should be fine.
nyan
1) my configuration file currently looks like following:
------
<deployment name="fragment">
<source>
<teamsite-templating-records
custom="yes"
area="/default/main/CountryPortal/Fragments/us_en/EDITION/0001"
options="wide">
<path name="xmlcontent/EMPLOYEEDIR_TEXT/data" />
</teamsite-templating-records>
</source>
....
----------------------------------------------------
2. Log msgs =====>
========================
....
# table mappings: 0
# view mappings: 0
# constraint mappings: 0
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'IWDELTRACKER'
SELECT * FROM SYSIBM.SYSTABLES WHERE NAME = 'FRAGMENT'
Table [FRAGMENT] exists.
Running deployment [fragment]
extraction type=default
tuple mode=wide
area=/default/main/CountryPortal/Fragments/us_en/EDITION/0001
/default/main/CountryPortal/Fragments/us_en/EDITION/0001/xmlcontent/EMPLOYEEDIR_
TEXT/data
Generate DirectoryContents start:Fri Feb 07 15:46:37 EST 2003
Generate DirectoryContents end :Fri Feb 07 15:46:38 EST 2003
Generate TCustomDCRTupleProducer start:Fri Feb 07 15:46:38 EST 2003
Generate TCustomDCRTupleProducer end :Fri Feb 07 15:46:38 EST 2003
No DCR's found in directory path [Y:/default/main/CountryPortal/Fragments/us_en/
EDITION/0001/xmlcontent/EMPLOYEEDIR_TEXT/data]
Stat for group [FRAGMENT]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Committing database [TS4IBM]...
Deployment[fragment]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Fri Feb 07 15:46:37 EST 2003
Finished: Fri Feb 07 15:46:38 EST 2003
### IWDataDeploy DONE ###
Migrateduser
Did you check if the Extended Attribute
TeamSite/Templating/DCR/Type=TYPE is set on the files in area Y:/default/main/CountryPortal/Fragments/us_en/
EDITION/0001/xmlcontent/EMPLOYEEDIR_TEXT/data?
DD checks if this EA value is set before processing. Where TYPE can be any value.
What version of DD are you using? If you are using DD5.6 you can just use <xml-source> instead of teamsite-templating-records in which case DD doesnt check for the existence of the above EA value
nyan
Yes, hit the target. Thx!