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)
data deploy
vinylrecord
hi,
i am having a problem that the values of the dcrs,a re not getting stored in the database.
i am using iwsyncdb.ipl command.., the tables are created, but it is blank.
plz if anyone can help me out.........
my cfg file looks like this........
<?xml version="1.0" encoding = "UTF-8" standalone="no"?>
<!DOCTYPE datacapture SYSTEM "datacapture5.0.dtd">
<data-capture-requirements type="content" name="template2">
<ruleset name="template2">
<description>
Survey
</description>
<item name="SURVEYNAME">
<label>Survey Name</label>
<database data-type="VARCHAR(50)"/>
<text required="t" size="50"/>
</item>
<item name="REPLICANT_0">
<label>Links</label>
<replicant min="1" max="30">
<item name="QUESTION">
<label>Question</label>
<database data-type="VARCHAR(50)"/>
<text required="t" size="50"/>
</item>
<item name="TYPE">
<select required="t" multiple="f">
<option value= "TEXT" label="TEXT"/>
<option value="CHECKBOX" label="CHECKBOX"/>
<option value="RADIO" label="RADIO"/>
</select>
</item>
<item name="ANSWERS">
<label>Answers</label>
<database data-type="VARCHAR(50)"/>
<text required="t" size="50"/>
</item>
</replicant>
</item>
</ruleset>
</data-capture-requirements>
**************************
the dbschema.cfg is as
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <dbschema>
- <group name="coursestructure" root-group="yes">
- <attrmap>
<column name="COURSENAME" data-type="VARCHAR(30)" value-from-field="COURSENAME" allows-null="no" is-url="no" />
<column name="COURSEDESCRIPTION" data-type="VARCHAR(30)" value-from-field="COURSEDESCRIPTION" allows-null="no" is-url="no" />
<column name="DATEOFCREATION" data-type="VARCHAR(30)" value-from-field="DATEOFCREATION" allows-null="no" is-url="no" />
<column name="CUSTOMERNAME" data-type="VARCHAR(30)" value-from-field="CUSTOMERNAME" allows-null="no" is-url="no" />
</attrmap>
- <keys>
- <primary-key>
<key-column name="COURSENAME" />
</primary-key>
</keys>
</group>
- <group name="REPLICANT_0" root-group="no">
- <attrmap>
<column name="MODULENAME" data-type="VARCHAR(30)" value-from-field="REPLICANT_0/[0-4]/MODULENAME" is-replicant="yes" allows-null="no" is-url="no" />
<column name="MODULEDESCRIPTION" data-type="VARCHAR(30)" value-from-field="REPLICANT_0/[0-4]/MODULEDESCRIPTION" is-replicant="yes" allows-null="no" is-url="no" />
<column name="PAGELINK" data-type="VARCHAR(20)" value-from-field="REPLICANT_0/[0-4]/REPLICANT_0/[0-4]/PAGELINK" is-replicant="yes" allows-null="no" is-url="no" />
<column name="COURSENAME" data-type="VARCHAR(30)" value-from-field="COURSENAME" allows-null="no" is-url="no" />
</attrmap>
- <keys>
- <primary-key>
<key-column name="MODULENAME" />
<key-column name="COURSENAME" />
</primary-key>
- <foreign-key parent-group="coursestructure">
<column-pair parent-column="COURSENAME" child-column="COURSENAME" />
</foreign-key>
</keys>
</group>
</dbschema>
plzzz reply soon, if anyone knows the solution
thanks
Find more posts tagged with
Comments
Migrateduser
You are saying you are using iwsyncdb.ipl , are using DAS??? Did you run -initial command to register base and staging tables?
Please post your ddconfig file, logfile and how you are trying to invoke deployments.
vinylrecord
hi,
vinylrecord
hi,
my ddconfig file is attached.
i am using das, as iwsyncdb.ipl was not generating the tables.
log output is
user: root
The uid is 0
Child Process ID: 13822
TeamSite_Templating data_root is set to templatedata
vpath :/default/main/course/WORKAREA/courseworkarea dcrtype : coursecategory/coursestructure
nomdc : false
Run Initial on /default/main/course/WORKAREA/courseworkarea
Workarea name: /default/main/course/WORKAREA/courseworkarea
DCR-Type : coursecategory/coursestructure
Workarea area name: /default/main/course/WORKAREA/courseworkarea DCR-type: coursecategory/coursestructure
Initializing /default/main/course/WORKAREA/courseworkarea
UnRegister Triggers if present
Stop DataDeploy daemon
##############################################
###### GENERATING TEMPLATING DD CFG'S #######
##############################################
Workarea name : /default/main/course/WORKAREA/courseworkarea
[/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg] does not exist
[/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/datacapture.cfg] exists.
----------------------------------------------
Generated [/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg]
----------------------------------------------
#################################################
#### SUBMIT & PUBLISH TEMPLATING EDITION ########
#################################################
Run Submit
/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata: ERROR:02016: Conflicts prevent operation
Start DataDeploy Daemon
EventSubsystem is not enabled, Register Triggers
#################################################
####### CREATING INITIAL DB TABLES ##########
#################################################
/iwmnt/default/main/course/STAGING/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg exists
Basetable name : DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_STAGING
basetable pref: DEFAULT_COURSECATEGORY_COURSESTRUCTURE
baseTable suff: MAIN_COURSE_STAGING
ExecDDCmd
DD command deployment=basearea cfg=/iwmnt/default/main/course/STAGING/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg mytemplatepath=templatedata/coursecategory/coursestructure/data mybasetablenameprefix=DEFAULT_COURSECATEGORY_COURSESTRUCTURE mybasetable=DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_STAGING mybasearea=/default/main/course/STAGING mybasetablenamesuffix=MAIN_COURSE_STAGING
SerialDaemon dispatch from MessageListener
Area name: /default/main/course/WORKAREA/courseworkarea
Base area name: /default/main/course/STAGING
Table name: DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_WORKAREA_COURSEWORKAREA
BaseTable name: DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_STAGING
Basetable Prefix: DEFAULT_COURSECATEGORY_COURSESTRUCTURE
Basetable Suffix: MAIN_COURSE_STAGING
Mytable Prefix: DEFAULT_COURSECATEGORY_COURSESTRUCTURE
Mytable Suffix: MAIN_COURSE_WORKAREA_COURSEWORKAREA
/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg exists
DD command deployment=deltagen mybasetablenameprefix=DEFAULT_COURSECATEGORY_COURSESTRUCTURE mytemplatepath=templatedata/coursecategory/coursestructure/data mytablenamesuffix=MAIN_COURSE_WORKAREA_COURSEWORKAREA myarea=/default/main/course/WORKAREA/courseworkarea mytable=DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_WORKAREA_COURSEWORKAREA mybasearea=/default/main/course/STAGING mytablenameprefix=DEFAULT_COURSECATEGORY_COURSESTRUCTURE cfg=/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg mybasetablenamesuffix=MAIN_COURSE_STAGING mybasetable=DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_STAGING
SerialDaemon dispatch from MessageListener
iwsyncdb.ipl -initial DONE
Opening >> /softwares/interwoven/iw-home/datadeploy/log/iwsyncdb.log
res=[0]
*** iwsyncdb.ipl DONE ***
view output is
***************
user: root
The uid is 0
Child Process ID: 13822
TeamSite_Templating data_root is set to templatedata
vpath :/default/main/course/WORKAREA/courseworkarea dcrtype : coursecategory/coursestructure
nomdc : false
Run Initial on /default/main/course/WORKAREA/courseworkarea
Workarea name: /default/main/course/WORKAREA/courseworkarea
DCR-Type : coursecategory/coursestructure
Workarea area name: /default/main/course/WORKAREA/courseworkarea DCR-type: coursecategory/coursestructure
Initializing /default/main/course/WORKAREA/courseworkarea
UnRegister Triggers if present
Stop DataDeploy daemon
##############################################
###### GENERATING TEMPLATING DD CFG'S #######
##############################################
Workarea name : /default/main/course/WORKAREA/courseworkarea
[/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg] does not exist
[/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/datacapture.cfg] exists.
----------------------------------------------
Generated [/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg]
----------------------------------------------
#################################################
#### SUBMIT & PUBLISH TEMPLATING EDITION ########
#################################################
Run Submit
/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata: ERROR:02016: Conflicts prevent operation
Start DataDeploy Daemon
EventSubsystem is not enabled, Register Triggers
#################################################
####### CREATING INITIAL DB TABLES ##########
#################################################
/iwmnt/default/main/course/STAGING/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg exists
Basetable name : DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_STAGING
basetable pref: DEFAULT_COURSECATEGORY_COURSESTRUCTURE
baseTable suff: MAIN_COURSE_STAGING
ExecDDCmd
DD command deployment=basearea cfg=/iwmnt/default/main/course/STAGING/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg mytemplatepath=templatedata/coursecategory/coursestructure/data mybasetablenameprefix=DEFAULT_COURSECATEGORY_COURSESTRUCTURE mybasetable=DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_STAGING mybasearea=/default/main/course/STAGING mybasetablenamesuffix=MAIN_COURSE_STAGING
SerialDaemon dispatch from MessageListener
Area name: /default/main/course/WORKAREA/courseworkarea
Base area name: /default/main/course/STAGING
Table name: DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_WORKAREA_COURSEWORKAREA
BaseTable name: DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_STAGING
Basetable Prefix: DEFAULT_COURSECATEGORY_COURSESTRUCTURE
Basetable Suffix: MAIN_COURSE_STAGING
Mytable Prefix: DEFAULT_COURSECATEGORY_COURSESTRUCTURE
Mytable Suffix: MAIN_COURSE_WORKAREA_COURSEWORKAREA
/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg exists
DD command deployment=deltagen mybasetablenameprefix=DEFAULT_COURSECATEGORY_COURSESTRUCTURE mytemplatepath=templatedata/coursecategory/coursestructure/data mytablenamesuffix=MAIN_COURSE_WORKAREA_COURSEWORKAREA myarea=/default/main/course/WORKAREA/courseworkarea mytable=DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_WORKAREA_COURSEWORKAREA mybasearea=/default/main/course/STAGING mytablenameprefix=DEFAULT_COURSECATEGORY_COURSESTRUCTURE cfg=/iwmnt/default/main/course/WORKAREA/courseworkarea/templatedata/coursecategory/coursestructure/coursestructure_dd.cfg mybasetablenamesuffix=MAIN_COURSE_STAGING mybasetable=DEFAULT_COURSECATEGORY_COURSESTRUCTURE__MAIN_COURSE_STAGING
SerialDaemon dispatch from MessageListener
iwsyncdb.ipl -initial DONE
Opening >> /softwares/interwoven/iw-home/datadeploy/log/iwsyncdb.log
res=[0]
*** iwsyncdb.ipl DONE ***
plz reply soon
Edited by vinylrecord on 02/13/03 08:55 PM (server time).
Migrateduser
Pl mail your iwddd.log file located in your DD log directory.
If solaris it should be in ddhome/log on windows by default it goes to ddhome or user specified directory during install