Skip to main content
Solved

Migration Job (Excel) - Not Performing Updates


Forum|alt.badge.img+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

Best answer by Makede

@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 - )
 

 

View original
Did this topic help you find an answer to your question?

6 replies

Forum|alt.badge.img+10
  • Hero (Employee)
  • 98 replies
  • April 14, 2023

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


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 8 replies
  • April 14, 2023

 


Forum|alt.badge.img+10
  • Hero (Employee)
  • 98 replies
  • Answer
  • April 14, 2023

@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 - )
 

 


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 8 replies
  • April 14, 2023

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


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 8 replies
  • April 14, 2023
Makede wrote:

@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


Forum|alt.badge.img+10
  • Hero (Employee)
  • 98 replies
  • April 24, 2023

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings