Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
issue with DD in TS 6.5 replicant items parsing...
motlnt
Hi All,
I am facing this issue with following env...
TS 6.5
OD 6.0.1
Win2k
Issue is during DD the OD process hangs for forever at this line in log..
===============================================
DD:Building Row map tree for group [MHR_STATE].
DD:This may take a while....
===============================================
My Deployment config XML defines this..
================================================
<dbschema>
<group name="MHR_REGION" table="MHR_REGION" root-group="yes">
<attrmap>
<column name="REGION_ID" data-type="NUMBER(9)" value-from-field="CATEGORY/0/ID" allows-null="no"/>
<column name="REGION_NAME" data-type="varchar2(255)" value-from-field="CATEGORY/0/NAME" allows-null="no"/>
<column name="VISIBLE" data-type="CHAR(1)" value-from-field="CATEGORY/0/VISIBLE" allows-null="no"/>
<column name="URL_ALIAS" data-type="VARCHAR2(4000)" value-from-field="CATEGORY/0/META_CONTAINER/0/URL_ALIAS" allows-null="yes"/>
<column name="TITLE" data-type="VARCHAR2(4000)" value-from-field="CATEGORY/0/META_CONTAINER/0/TITLE" allows-null="yes"/>
<column name="KEYWORDS" data-type="VARCHAR2(4000)" value-from-field="CATEGORY/0/META_CONTAINER/0/KEYWORDS" allows-null="yes"/>
<column name="DESCRIPTION" data-type="VARCHAR2(4000)" value-from-field="CATEGORY/0/META_CONTAINER/0/DESCRIPTION" allows-null="yes" />
</attrmap>
<keys>
<primary-key>
<key-column name="REGION_ID"/>
</primary-key>
</keys>
</group>
<group name="MHR_STATE" table="MHR_STATE" root-group="no">
<attrmap>
<column name="STATE_ID" data-type="NUMBER(12)" is-replicant="yes" value-from-field="CATEGORY/0/CATEGORY/[0-29]/CATEGORY/[0-19]/CATEGORY/[0-59]/ID" allows-null="no"/>
<column name="STATE_NAME" data-type="varchar2(255)" is-replicant="yes" value-from-field="CATEGORY/0/CATEGORY/[0-29]/CATEGORY/[0-19]/CATEGORY/[0-59]/NAME" allows-null="no"/>
<column name="VISIBLE" data-type="CHAR(1)" is-replicant="yes" value-from-field="CATEGORY/0/CATEGORY/[0-29]/CATEGORY/[0-19]/CATEGORY/[0-59]/VISIBLE" allows-null="no"/>
<column name="COUNTRY_ID" data-type="NUMBER(12)" is-replicant="yes" value-from-field="CATEGORY/0/CATEGORY/[0-29]/CATEGORY/[0-19]/ID" allows-null="no"/>
<column name="SUB_REGION_ID" data-type="NUMBER(12)" is-replicant="yes" value-from-field="CATEGORY/0/CATEGORY/[0-29]/ID" allows-null="no"/>
<column name="REGION_ID" data-type="NUMBER(12)" value-from-field="CATEGORY/0/ID" allows-null="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="STATE_ID"/>
</primary-key>
<foreign-key parent-group="MHR_COUNTRY">
<column-pair parent-column="COUNTRY_ID" child-column="COUNTRY_ID"/>
</foreign-key>
</keys>
</group>
</dbschema>
==================================================================================================
it works fine for rest of the gropus and hangs at MHR_STATE table.....
any comments?
thx in advance...
JM
Find more posts tagged with
Comments
motlnt
find attached the datacapture.cfg...
JM
Migrateduser
Probably a memory issue. Looking at the replicant sizes you have 0-59, 0-29, 0-19... that's a lot of combinations that have to be calculated when DD builds the row map tree. So it would make sense that it will take a while.
Did you try creating a row map file first, by running iwsyncdb -rowmapgen ... (see the OD or DD DTD reference for the exact syntax). You would refer to this external file from within your deployment config. From the manual:
DataDeploy builds and traverses data tree structures to compute the number of
rows it needs to process for tables that map nested elements in DCRs. To speed the
process, DataDeploy can be configured to “serialize” (cache in a file) the Java objects
produced by such tree traversing, and to read in those objects during actual
deployments. When this feature is enabled, DataDeploy builds the serialized Java
objects in row maps (contained in a row map cache file) for those group elements in
a dbschema definition that contain replicants from various nested levels which are
mapped to table columns.
-Mariam
Bill Klish
The word rowmapgen does not even appear in the DD 6.0.2 manual. Where is this documented?
cross.jpg
Migrateduser
It should have been doc'd better. It's on the bug list for OD 6.1. For now, you have to rely on the CLT help and row-map-cache-file description in the OpenDeploy reference manual. Sorry for the inconvenience.
Mariam
RajatChopra
Hi Mariam,
Is there any update on this? Can we refer some documentation on how to implement row-map-cache-file?
-Rajat
kajjubee
Mariam,
I am running into this same issue in TS 6.7.1 and OD 6.2 I even tried the rowmapgen as documented in the manual but the group with replicant inside a replicant is totally ignored. Has there been a resolution on this?
Thanks,
K