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.



<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.

ALL

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.

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.

01794637,AC-3201