Solved

Migration Job (Excel) - Not Performing Updates

  • 14 April 2023
  • 6 replies
  • 149 views
V
Rank
Badge +3

I have the exact same Excel Migration Job over BUS_OBJ_REPRESENTATIVE in our DEV and TEST environments and they do not perform the same.   

The migration job in DEV will perform a modification as expected and return the “Updated” result.

The migration job in TEST will not perform the requested update and returns a result of “Business Object Representative already exists”.   of course it exits, I want to update the “Representative Type” associated with the record.

We have check all permissions and have no idea what would be causing the difference in functionality.

Any help is greatly appreciated.

 

Sincerely,

Vince

icon

Best answer by Makede 14 April 2023, 18:44

View original

6 replies

M
Rank
Userlevel 4
Badge +10

Hi @VT_VKOLB 
can you please post a harcopy of your migration job mapping
Thanks

V
Rank
Badge +3

 

M
Rank
Userlevel 4
Badge +10

@VT_VKOLB 

Since you have not mapped the key field BUSINESS_OBJECT_TYPE replace the Flag “K” with “-” in method list attribute (green marked K must be - )
 

 

V
Rank
Badge +3

THANKS!    Your recommendation seems to be working.  getting an “Updated” result now.  validating data to be sure the update actually took.   

this change was not required in the other environment that was updating the data. 

Are you able to explain why this change to Method List Attributes was needed in one IFS environment but not another?

 

Sincerely,

Vince

V
Rank
Badge +3

@VT_VKOLB 

Since you have not mapped the key field BUSINESS_OBJECT_TYPE replace the Flag “K” with “-” in method list attribute (green marked K must be - )
 

 

THANKS!    Your recommendation seems to be working.  getting an “Updated” result now.  validating data to be sure the update actually took.   

this change was not required in the other environment that was updating the data. 

Are you able to explain why this change to Method List Attributes was needed in one IFS environment but not another?

 

Sincerely,

Vince

M
Rank
Userlevel 4
Badge +10

@VT_VKOLB 
Since you do not have mapped the field the primary key field BUSINESS_OBJECT_TYPE you need to tell the tool that it should not look for this field when checking if a insert or update is needed. So the minus provides the information to the tool that the not mapped primary key field BUSINESS_OBJECT_TYPE should be ignored by taking the decision to perform an insert or update

Reply


Terms & ConditionsCookie settings