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

Problem regarding setting up DAS

elin

Hi,

I am trying to set up DAS to work in my Teamsite environment: Teamsite 6.1 + DD 5.6a. And I have configured it to work partially. When I submit a changed DCRs, the DAS works fine and database get updated, but when I save a DCR, the DAS throw some errors.

Here is an example from iwddd.log file:

------------------Submit a DCR------------------------------------

TWorkItem: Smiley Very Happy

oIt --- sock=2345 id=9
msg [cfg="Y:\default\main\Microsite_Can_Eng\WORKAREA\wa_staging/templatedata/ctcmicrosite/answers/answers_dd.cfg" deployment=submitlist myarea="/default/main/Microsite_Can_Eng/WORKAREA/wa_staging" mytable=DEFAULT_CTCMICROSITE_ANSWERS__MAIN_MICROSITE_CAN_ENG_WORKAREA_WA_STAGING mybasetable=DEFAULT_CTCMICROSITE_ANSWERS__MAIN_MICROSITE_CAN_ENG_STAGING mybasetablenameprefix=DEFAULT_CTCMICROSITE_ANSWERS mybasetablenamesuffix=MAIN_MICROSITE_CAN_ENG_STAGING mytablenameprefix=DEFAULT_CTCMICROSITE_ANSWERS mytablenamesuffix=MAIN_MICROSITE_CAN_ENG_WORKAREA_WA_STAGING mysubmitlist=C:\ddtemp\sj8. ]
id=9 fDdArgs[0]=[cfg="Y:\default\main\Microsite_Can_Eng\WORKAREA\wa_staging/templatedata/ctcmicrosite/answers/answers_dd.cfg"]
id=9 fDdArgs[1]=[deployment=submitlist]
id=9 fDdArgs[2]=[myarea="/default/main/Microsite_Can_Eng/WORKAREA/wa_staging"]
id=9 fDdArgs[3]=[mytable=DEFAULT_CTCMICROSITE_ANSWERS__MAIN_MICROSITE_CAN_ENG_WORKAREA_WA_STAGING]
id=9 fDdArgs[4]=[mybasetable=DEFAULT_CTCMICROSITE_ANSWERS__MAIN_MICROSITE_CAN_ENG_STAGING]
id=9 fDdArgs[5]=[mybasetablenameprefix=DEFAULT_CTCMICROSITE_ANSWERS]
id=9 fDdArgs[6]=[mybasetablenamesuffix=MAIN_MICROSITE_CAN_ENG_STAGING]
id=9 fDdArgs[7]=[mytablenameprefix=DEFAULT_CTCMICROSITE_ANSWERS]
id=9 fDdArgs[8]=[mytablenamesuffix=MAIN_MICROSITE_CAN_ENG_WORKAREA_WA_STAGING]
id=9 fDdArgs[9]=[mysubmitlist=C:\ddtemp\sj8.]
Database Vendor set to oracle
SQL datatype for column Path is varchar(255)
SQL datatype for column IW_State is varchar(255)
SQL datatype for column QSTN_PATH is varchar2(255)
SQL datatype for column DSPL_ORD_NO is Number(10)
SQL datatype for column ANS_VLU_TXT is varchar2(2000)
# of columns: 5
# of primary key columns specified: 1
# of groups defined in element: 1
Area VPath:/default/main/Microsite_Can_Eng/WORKAREA/wa_staging
Setting up TDbSchemaSynchronizer.
Validating cached connection...
Cached connection OK
Connected to [turing.radius:1521:maxdb]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='TS_MC_ANS_TBL'
Table [TS_MC_ANS_TBL] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
Table [iwtracker] exists.
TS_MC_ANS_TBL registered
Running deployment [submitlist]
extraction type=full
tuple mode=wide
area=/default/main/Microsite_Can_Eng/WORKAREA/wa_staging
filelist=[C:\ddtemp\sj8.]
/default/main/Microsite_Can_Eng/WORKAREA/wa_staging/templatedata/ctcmicrosite/answers/data/ca_en_microsite/SearsContest/elainetest
Generate DirectoryContents start:Mon Nov 29 11:16:58 EST 2004
Generate DirectoryContents end :Mon Nov 29 11:16:58 EST 2004
Generate TDCRTupleProducer start:Mon Nov 29 11:16:58 EST 2004
Generate TDCRTupleProducer end :Mon Nov 29 11:16:58 EST 2004
Path not found -- interpret as 'NotPresent'
Building replicant order column information.
Building replicant order column information... Done.

TUPLE={state=NotPresent, path=templatedata\ctcmicrosite\answers\data\ca_en_microsite\SearsContest\elainetest}
TTableSchemaHelper object for [TS_MC_ANS_TBL] found in cache.
SELECT Smiley Frustrated

ELECT IW_State,QSTN_PATH,DSPL_ORD_NO,ANS_VLU_TXT,Path FROM TS_MC_ANS_TBL WHERE Path = ?
Recurse select: pIndex = 0, value = templatedata\ctcmicrosite\answers\data\ca_en_microsite\SearsContest\elainetest
BuildTuples:executeQuery returned valid result set
TTableSchemaHelper object for [TS_MC_ANS_TBL] found in cache.
BuildTuples:BuildRows returned: true
TTableSchemaHelper object for [TS_MC_ANS_TBL] found in cache.
DELETE: DELETE FROM TS_MC_ANS_TBL WHERE Path IN ( ?)
DoDelete: pIndex = 0, value = templatedata\ctcmicrosite\answers\data\ca_en_microsite\SearsContest\elainetest
-- Deleted
Filelist walk done
Filelist C:\ddtemp\sj8. deleted
UPDATE iwtracker SET UPDATETIME='Mon Nov 29 11:16:58 EST 2004' WHERE NAME='TS_MC_ANS_TBL'
1 row(s) updated.
Stat for group [answers]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 1
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Committing database [turing.radius:1521:maxdb]...
Deployment[submitlist]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 1
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Mon Nov 29 11:16:58 EST 2004
Finished: Mon Nov 29 11:16:58 EST 2004

### IWDataDeploy DONE ###

----------------------------Save a DCR---------------------------------

TWorkItem: Smiley Very Happy

oIt --- sock=2345 id=12
msg [cfg="Y:/default/main/Microsite_Can_Eng/WORKAREA/wa_staging/templatedata/ctcmicrosite/answers/answers_dd.cfg" deployment=deltaupdate myarea="/default/main/Microsite_Can_Eng/WORKAREA/wa_staging" mybasearea="/default/main/Microsite_Can_Eng/STAGING" mytable=DEFAULT_CTCMICROSITE_ANSWERS__MAIN_MICROSITE_CAN_ENG_WORKAREA_WA_STAGING mybasetable=DEFAULT_CTCMICROSITE_ANSWERS__MAIN_MICROSITE_CAN_ENG_STAGING mybasetablenameprefix=DEFAULT_CTCMICROSITE_ANSWERS mybasetablenamesuffix=MAIN_MICROSITE_CAN_ENG_STAGING mytablenameprefix=DEFAULT_CTCMICROSITE_ANSWERS mytablenamesuffix=MAIN_MICROSITE_CAN_ENG_WORKAREA_WA_STAGING myfilelist=C:\ddtemp\s2to. ]
id=12 fDdArgs[0]=[cfg="Y:/default/main/Microsite_Can_Eng/WORKAREA/wa_staging/templatedata/ctcmicrosite/answers/answers_dd.cfg"]
id=12 fDdArgs[1]=[deployment=deltaupdate]
id=12 fDdArgs[2]=[myarea="/default/main/Microsite_Can_Eng/WORKAREA/wa_staging"]
id=12 fDdArgs[3]=[mybasearea="/default/main/Microsite_Can_Eng/STAGING"]
id=12 fDdArgs[4]=[mytable=DEFAULT_CTCMICROSITE_ANSWERS__MAIN_MICROSITE_CAN_ENG_WORKAREA_WA_STAGING]
id=12 fDdArgs[5]=[mybasetable=DEFAULT_CTCMICROSITE_ANSWERS__MAIN_MICROSITE_CAN_ENG_STAGING]
id=12 fDdArgs[6]=[mybasetablenameprefix=DEFAULT_CTCMICROSITE_ANSWERS]
id=12 fDdArgs[7]=[mybasetablenamesuffix=MAIN_MICROSITE_CAN_ENG_STAGING]
id=12 fDdArgs[8]=[mytablenameprefix=DEFAULT_CTCMICROSITE_ANSWERS]
id=12 fDdArgs[9]=[mytablenamesuffix=MAIN_MICROSITE_CAN_ENG_WORKAREA_WA_STAGING]
id=12 fDdArgs[10]=[myfilelist=C:\ddtemp\s2to.]
Database Vendor set to oracle
SQL datatype for column Path is varchar(255)
SQL datatype for column IW_State is varchar(255)
SQL datatype for column QSTN_PATH is varchar2(255)
SQL datatype for column DSPL_ORD_NO is Number(10)
SQL datatype for column ANS_VLU_TXT is varchar2(2000)
# of columns: 5
# of primary key columns specified: 1
ERROR:base-table attribute must be specified for .
ERROR:Exception4: java.lang.NullPointerException
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.IsPathColumnInGroup(TDbSchemaUtils.java:164)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.CheckReplicantOrderAsKeyCondition(TDbSchemaGroupCfg.java:377)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.(TDbSchemaGroupCfg.java:176)
at com.interwoven.dd100.dd.TDbSchemaCfg$TDbSchemaChildVisitor.VisitNode(TDbSchemaCfg.java:291)
at com.interwoven.dd100.dd.TConfiguration.TraverseChildElements(TConfiguration.java:925)
at com.interwoven.dd100.dd.TConfiguration.TraverseChildElements(TConfiguration.java:868)
at com.interwoven.dd100.dd.TDbSchemaCfg.(TDbSchemaCfg.java:67)
at com.interwoven.dd100.dd.TDatabaseCfg$TDatabaseChildVisitor.VisitNode(TDatabaseCfg.java:2366)
at com.interwoven.dd100.dd.TConfiguration.TraverseChildElements(TConfiguration.java:925)
at com.interwoven.dd100.dd.TConfiguration.TraverseChildElements(TConfiguration.java:868)
at com.interwoven.dd100.dd.TDatabaseCfg.ExtractAttributesAndVisitChildren(TDatabaseCfg.java:1901)
at com.interwoven.dd100.dd.TDatabaseCfg.(TDatabaseCfg.java:1568)
at com.interwoven.dd100.dd.TDeploymentCfg$TDestListChildVisitor.VisitNode(TDeploymentCfg.java:726)
at com.interwoven.dd100.dd.TConfiguration.TraverseChildElements(TConfiguration.java:925)
at com.interwoven.dd100.dd.TConfiguration.TraverseChildElements(TConfiguration.java:868)
at com.interwoven.dd100.dd.TDeploymentCfg$TDeploymentChildVisitor.VisitNode(TDeploymentCfg.java:473)
at com.interwoven.dd100.dd.TConfiguration.TraverseChildElements(TConfiguration.java:925)
at com.interwoven.dd100.dd.TConfiguration.TraverseChildElements(TConfiguration.java:868)
at com.interwoven.dd100.dd.TDeploymentCfg.(TDeploymentCfg.java:278)
at com.interwoven.dd100.dd.TConfiguration.GetDeployment(TConfiguration.java:209)
at com.interwoven.dd100.dd.IWDataDeploy.DetermineModes(IWDataDeploy.java:358)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:474)
at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:151)
at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:32)
at java.lang.Thread.run(Thread.java:479)

I noticed that when the deployment is "submitlist", it went through fine. But when the deployment is "deltaupdate", it fails.

And the following post is my ****_dd.cfg file for "submitlist" and "deltaupdate"

Do you know what else I need to do in order to make this deltaupdate deployment works?

Thanks a lot for help!!!

Edited by elin on 11/29/04 09:22 AM (server time).

Find more posts tagged with

Comments

elin

Here is my submitlist and deltaupdate sample

----------------------------submitlist-----------------------------------------
<deployment name="submitlist">
<source>
<teamsite-templating-records options= "full,wide" area= "$myarea" base-area= "$mybasearea">
<path filelist="$myfilelist" visit-directory= "deep" delete-after-use= "yes" />
</teamsite-templating-records>
</source>
<destinations>
<database use="ctc-mc-staging" update-type= "delta" state-field= "state">
<dbschema>
<group name="answers" table="ts_mc_ans_tbl" root-group="yes">
<attrmap>
<column name="Path" data-type="varchar(255)" value-from-field="path"/>
<column name="IW_State" data-type="varchar(255)" value-from-field="state"/>
<column name="QSTN_PATH" data-type="varchar2(255)" value-from-field="QuestionPath" allows-null="no"/>
<column name="DSPL_ORD_NO" data-type="Number(10)" value-from-field="Rank" allows-null="yes"/>
<column name="ANS_VLU_TXT" data-type="varchar2(2000)" value-from-field="AnswerText" allows-null="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Path"/>
</primary-key>
</keys>
</group>
</dbschema>

</database>
</destinations>
</deployment>

-----------------------------------------deltaupdate-----------------------

<deployment name="deltaupdate">
<source>
<teamsite-templating-records options= "full,wide" area= "$myarea" base-area= "$mybasearea" >
<path filelist= "$myfilelist" visit-directory="deep" delete-after-use="yes" />
</teamsite-templating-records>
</source>
<destinations>
<database use="ctc-mc-staging" update-type="delta" state-field="state" >
<dbschema>
<group name="answers" table="ts_mc_ans_tbl" root-group="yes">
<attrmap>
<column name="Path" data-type="varchar(255)" value-from-field="path"/>
<column name="IW_State" data-type="varchar(255)" value-from-field="state"/>
<column name="QSTN_PATH" data-type="varchar2(255)" value-from-field="QuestionPath" allows-null="no"/>
<column name="DSPL_ORD_NO" data-type="Number(10)" value-from-field="Rank" allows-null="yes"/>
<column name="ANS_VLU_TXT" data-type="varchar2(2000)" value-from-field="AnswerText" allows-null="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="Path"/>
</primary-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>

Edited by elin on 11/29/04 09:22 AM (server time).

elin

I have discover the problem myself. When the update-type is "delta", need to define base-table in the group.

Thanks!

jkm

I am getting similar exception in DataDeploy. I have given base table as you mentioned above but its still the same.

Here is the exception
DBD: CREATE INDEX iwdelt_idx ON IWDELTRACKER( PATH , AREA )
DBD: IWDELTRACKER created successfully.
DBD: ERROR:Exception4: java.lang.NullPointerException
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.GetParentGroupNames(TDbSchemaUtils.java:297)
at com.interwoven.dd100.dd.TDbSchemaGroupInfoNode.Process(TDbSchemaGroupInfoNode.java:56)
at com.interwoven.dd100.dd.TDbSchemaGroupInfoNode.<init>(TDbSchemaGroupInfoNode.java:45)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.Init(TDbSchemaGroupInfo.java:50)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.<init>(TDbSchemaGroupInfo.java:35)
at com.interwoven.dd100.dd.TDbSchemaAgent.Prepare(TDbSchemaAgent.java:174)
at com.interwoven.dd100.dd.TDbSchemaAgent.<init>(TDbSchemaAgent.java:131)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:513)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:586)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:191)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:542)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD:
### IWDataDeploy FAILED ###

DD Config file:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<data-deploy-configuration>
<data-deploy-elements filepath="/opt/Interwoven/OpenDeployNG/etc/database.xml"/>
<client>
<deployment name="basearea">
<source>
<teamsite-templating-records options="wide" area="/default/main/ORPG/WORKAREA/work">
<path name="templatedata/pagetemplates/template01/data/test.dcr" visit-directory = "deep" />
</teamsite-templating-records>
</source>
<destinations>
<database use="oracle-db" delete-tracker="yes" update-type="standalone">
<dbschema>
<group name="temp_page" table="temp_page" root-group="yes">
<attrmap>
<column name="PageID" data-type="varchar(5)" value-from-field="template/FileInfo"/>
<column name="Title" data-type="varchar(255)" value-from-field="template/filepath"/>
<column name="Page_Loc" data-type="VARCHAR(100)" value-from-field="template/title"/>
</attrmap>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

Command Line

/opt/Interwoven/OpenDeployNG/bin/iwodcmd start ddconfig -k iwdd=basearea

Env Solaris 8 + TS 6.5 + OD 6.0.2

Any assistance on this please is appreciated

jkm

This was happening because I was using DTD 6.0 and DCT of XML type. I turned this to IWOV type and created my DCT with DTD 5.0 and it works fine as given in examples which is really weird because I didnt see anywhere in the dev guide to use 5.0.

Another question about DD
I want to deploy data to my table in which I need to populate two types of data.

One is fixed data provided in DCR ( which should go to different rows in table) like I have heading ID and heading html, search ID and search html. This should go to two different rows and then in the same table my data from replicants should go. I am able to insert the data using replicants only but for the above records i am not able to insert the data. Do I need to make multiple groups and then insert these columns or any other suggestion

second question: I need to run my store procedure after insertion of data. Do I need to write a different dd config file for that or can I perform this operation in the same config file only. I checked the dd guide but there is nothing specific about this.

Any clues are appreciated.

OD6.0.2 + Solaris + TS6.5