RSS

Tag Archives: import

DIXF – How to regenerate target entities

There is time when you add custom fields to staging table and they do not appear in your Target when you promote data from STAGING to TARGET. The reason the new fields do not appear in TARGET because it does not know there are new fields that we need to regenerate field mapping for the target.

There are 2 ways to do this, I’m going to show you both LONG WAY and SHORT WAY

LONG WAY

1. Go to the DIXF area page. Click on Target entities.

image

2. Find the entity in the list.

clip_image001[5]

3. Click on the “Modify target mapping” at the top:

image

4. Click on “Mapping Details”

image

5. Click on “Generate mapping”

clip_image001

6.  Answer “Yes” to prompt

image

7. You should see your new fields in the list

clip_image001[13]

SHORT WAY

Run either one of the 2 jobs below

This jobs run for all entities

static void regenerateDMFTargetMapping(Args _args)
{
    DMFTargetXMLToEntityMap     dmfTargetXMLToEntityMap;
    DMFEntity                   dmfEntity;
 
    // delete all target Mappings
    ttsBegin;
        delete_from dmfTargetXMLToEntityMap;
    ttsCommit;
 
    // Regenerate Target Mapping for all Entities
    while select dmfEntity
    {
        DMFTargetXMLToEntityMap::generateMapping(dmfEntity);
    }
 
    info("All Done!");
}

This one run for  one entity. Make sure to replace your <Entity Name> with your entity

static void regenerateDMFTargetMapping(Args _args)
{
    DMFTargetXMLToEntityMap     dmfTargetXMLToEntityMap;
    DMFEntity                   dmfEntity;
 
    // delete specified target Mapping
    ttsBegin;
        delete_from dmfTargetXMLToEntityMap where dmfTargetXMLToEntityMap.Entity = <EntityName>;
    ttsCommit;
 
    // Regenerate Target Mapping for specified Entity
    while select dmfEntity where dmfEntity.EntityName = <EntityName>
    {
        DMFTargetXMLToEntityMap::generateMapping(dmfEntity);
    }
 
    info("All Done!");
}

ADVANTAGE OF USING JOBS

Sometimes it is not possible to regenerate the target mapping for a particular entity as clicking on “Modify target mapping” generates an error.   This error typically reads along the lines of

“Duplicate assignment found for the following target field <some field name>”

DMFDuplicateAssignment

“Cannot create a record in Target XML (DMFTargetXML)”

image

Run the job will fix these issues.

 
2 Comments

Posted by on August 26, 2014 in Development

 

Tags: , , , , , , ,

How to upgrade a new model file form an ISV with conflict

Step 1: Install a model

  1. axutil.exe delete /model:YOUR_EXITING_MODEL_ID /config:”YOUR_AOS”
  2. axutil.exe import /config:”YOUR_AOS” /file:”C:\YOUR_PATH\YOUR_MODEL_FILE.axmodel” /conflict:push /verbose

Step 2: Find Conflict  model

The process will create a conflict model if found image

image

Step 3: Create a project from a conflict model

  1. Open the Development Workspace.
  2. Choose Tools > Model management > Create project from model.
  3. Select the model that will be used as the source of the project content.
  4. Supply the name of the new project to be created.
  5. Click OK. The project will be created that has the elements from the model.

A project will provide project name will be created in private project

Step 4: Resolve conflicts

Go to your project and start selecting a resource that has conflict.

Compare to see the differences between the resource in the patch layer and the resource in the main layer.

There are many ways to resolve the conflict, depending on the resource type and the actual conflict. Some of the ways to resolve the conflict include the following:

  • Use the information and the available actions from the Comparison window to merge changes from the conflict model into an existing layer.
  • Make a change in the resource in an existing model in the current layer. For example, if two different models in the layer have modified the same resource, you could consider creating a new “shared” model in the layer that contains a single version of the resource that can be used by both of the other models.
  • Switch to the patch layer and modify the resource there. In some cases, this is the easiest way to resolve the conflict.

Repeat this process until there isn’t any object to resolve.

 
1 Comment

Posted by on January 15, 2014 in Installation and Configuration

 

Tags: , , , ,

 
%d bloggers like this: