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

Deploying 0-to-many relationship using UDS

bikerider

DataDeploy Version 5.6.0 Build 19499 Interwoven 20030506
Version 5.5.1 Build 11146 SYM Interwoven 20020829
Core version 'Interwoven MetaTagger 3.5.0 BN:15791'

Is there no way to deploy a zero-to-many relationship using DD UDS? The following code produces the following error when there is no replicant data provided:

<deployment name="sd_sw_catalog">
<source>

<teamsite-extended-attributes
options = "differential,wide"
area = "$myarea"
base-area = "$mybasearea">
<path name = "$mytemplatepath"
visit-directory = "deep" />
</teamsite-extended-attributes>
</source>
<destinations>
<database use="IWUI"
update-type="standalone"
real-update="yes"
delete-tracker="yes"
log-level="3">

<dbschema>
<group name="software_catalog"
table="$tableprefix^SOFTWARE_CATALOG" root-group="yes">
<attrmap>
<column name="id" data-type="NUMBER" value-from-field="sw_catalog_id" allows-null="no"/>
<column name="default_short_name" data-type="VARCHAR2(2000)" value-from-field="TeamSite/Metadata/default_short_name" allows-null="yes"/>
<column name="default_display_name" data-type="VARCHAR2(2000)" value-from-field="TeamSite/Metadata/default_display_name" allows-null="yes"/>
<column name="default_description" data-type="VARCHAR2(2000)" value-from-field="TeamSite/Metadata/default_description" allows-null="yes"/>
<column name="file_name" data-type="VARCHAR2(2000)" value-from-field="file_name" allows-null="yes"/>
<column name="file_type" data-type="VARCHAR2(2000)" value="FILE_NAME_APP" allows-null="yes"/>
<column name="version" data-type="VARCHAR2(250)" value-from-field="TeamSite/Metadata/version" allows-null="yes"/>
<column name="url" data-type="VARCHAR2(2000)" value-from-field="path" allows-null="yes"/>
<column name="file_size" data-type="NUMBER" value-from-field="size" allows-null="yes"/>
<column name="timestamp" data-type="VARCHAR2(250)" value-from-field="TeamSite/Metadata/timestamp" allows-null="yes"/>
<column name="app_spaces" data-type="number" value-from-field="TeamSite/Metadata/app_spaces" allows-null="yes"/>
<column name="DATE_CREATED" data-type="DATE" value-from-field="crdate" data-format="MM/dd/yyyy HH:mm:ss" allows-null="no"/>
<column name="CREATED_BY" data-type="varchar2(60)" value-from-field="creator" allows-null="no"/>
<column name="DATE_MODIFIED" data-type="DATE" value-from-field="moddate" data-format="MM/dd/yyyy HH:mm:ss" />
<column name="MODIFIED_BY" data-type="VARCHAR2 (60)" value-from-field="lastuser" />
<column name="last_update_date" data-type="DATE" value-from-field="TeamSite/Metadata/last_update_date" data-format="MM/dd/yyyy" allows-null="yes"/>
</attrmap>
<keys>
<primary-key>
<key-column name="id"/>
</primary-key>
</keys>
</group>

<group name="related_software"
table="$tableprefix^RELATED_SOFTWARE" root-group="no">
<attrmap>
<column name="related_software_id" data-type="NUMBER" value-from-field="TeamSite/Metadata/related_software_rep/[0-30]/related_software_id"
is-replicant="yes" allows-null="yes"/>
<column name="software_id" data-type="NUMBER" value-from-field="sw_catalog_id" allows-null="no"/>
<column name="DATE_CREATED" data-type="DATE" value-from-field="crdate" data-format="MM/dd/yyyy HH:mm:ss" allows-null="no"/>
<column name="CREATED_BY" data-type="varchar2(60)" value-from-field="creator" allows-null="no"/>
<column name="DATE_MODIFIED" data-type="DATE" value-from-field="moddate" data-format="MM/dd/yyyy HH:mm:ss" />
<column name="MODIFIED_BY" data-type="VARCHAR2 (60)" value-from-field="lastuser" />
</attrmap>
<keys>
<primary-key>
<key-column name="related_software_id"/>
</primary-key>
</keys>
<foreign-key parent-group="software_catalog" ri-constraint-rule="ON DELETE CASCADE">
<column-pair parent-column="id"
child-column="software_id"/>
</foreign-key>
</group>

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

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Error produced:
SelectCurrentRows Smiley Frustrated

ELECT software_id,TO_CHAR(DATE_CREATED,'MM/DD/YYYY HH24:MI Smiley Frustrated

S') AS DATE_CREATED,CREATED_BY,TO_CHAR(DATE_MODIFIED,
'MM/DD/YYYY HH24:MI Smiley Frustrated

S') AS DATE_MODIFIED,MODIFIED_BY,related_software_id FROM RELATED_SOFTWARE WHERE ORDER BY related_software_id

*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-00936: missing expression

Vendor Error Code: 936
SQL state: 42000
*******************************************************

Find more posts tagged with

Comments

Migrateduser

0-to-many is not supported by DD.