Metadata Export Input map does not contain "Delete Relationships Only" Parameter

Metadata Export Input map does not contain "Delete Relationships Only" Parameter

book

Article ID: KB0077353

calendar_today

Updated On:

Products Versions
TIBCO MDM 9.1.0 HF-02 & FC 4.0.2

Description

While exporting the Repository Metadata along with Input maps through Export Metadata(Wizard) option on UI,The Output file(DataServiceQuery.xml) does not have "Delete Relationships Only" parameter.

IM With Delete Relationships Only

<CatalogInputMap Name="IM_AFF_PRODUCT_CHA_DEL" Catalog="PRODUCT">
          <Name>IM_AFF_PRODUCT_CHA_DEL</Name>
          <Description>Deletes association between product and characteristic</Description>
          <Mergedata>true</Mergedata>
          <Incremental>true</Incremental>
          <ApprovalOption>D</ApprovalOption>
          <SourceID/>
          <CommonKey/>
          <DataSource Name="DS_AFF_RELATIONSHIP_CHA_DEL">
            <PrimarySource>false</PrimarySource>
          </DataSource>


Importing the same(Above Exported) Metadata into another environment/same environment leads to metadata corruption("Delete Relationship Only" option is unavailable for the Input Maps) as below.

IM Without Delete Relationships Only

Issue/Introduction

While Exporting the Metadata through Export Metadata(Wizard) option,The Input maps does not contain "Delete Relationships Only" parameter in the generated DataServiceQuery Output file.

Environment

ALL

Resolution

This is a Bug at Product Level and will be fixing through future hotfixes.

As a workaround,We need to add the Parameter( DELETERELATIONSHIPS) in the generated output DataServiceQuery xml file and import the same as a ZIP file into another environment.

<CatalogInputMap Name="IM_AFF_PRODUCT_CHA_DEL" Catalog="PRODUCT">
          <Name>IM_AFF_PRODUCT_CHA_DEL</Name>
          <Description>Deletes association between product and characteristic</Description>
          <Mergedata>true</Mergedata>
          <Incremental>true</Incremental>
          <ApprovalOption>D</ApprovalOption>
          <SourceID/>
          <CommonKey/>
          <DBLoaderMode>DELETERELATIONSHIPS</DBLoaderMode>
          <DataSource Name="DS_AFF_RELATIONSHIP_CHA_DEL">
            <PrimarySource>false</PrimarySource>
          </DataSource>
After importing the updated Metadata xml the parameter is visible on UI as below.

User-added image

Additional Information

01794637,AC-3201

Attachments

Metadata Export Input map does not contain "Delete Relationships Only" Parameter get_app
Metadata Export Input map does not contain "Delete Relationships Only" Parameter get_app
Metadata Export Input map does not contain "Delete Relationships Only" Parameter get_app