Skip to main content
Solved

IFS Excel Add-In - MI_RETRIEVAL_ERROR

  • October 30, 2023
  • 6 replies
  • 312 views

Forum|alt.badge.img+5

Hello,

I receive below error when trying to execute a Excel Migration,

Any idea why?

Best answer by Nirogini Janstin

@himasha.abeywickrama , there is a known bug on 22R2 older versions for excel migration. It is fixed on 22.2.14 but you can try it by removing the source column of COMPANY_POS_STRUCTURE.BUSINESS_UNIT_TYPE_DB this field under the `source mapping` tab and re-generate excel migration.

 

6 replies

Nirogini Janstin
Do Gooder (Employee)
Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 50 replies
  • October 30, 2023

Can you share some detail on what view you used to create this excel migration job? and are you getting this error on 22R2 right?


Forum|alt.badge.img+5

Hi @Nirogini Janstin,

I’m using COMPANY_POS_STRUCTURE view. And yes the version is 22R2 SU9.


Nirogini Janstin
Do Gooder (Employee)
Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 50 replies
  • October 30, 2023

Are you getting this error when try to load the data in excel or when you execute a record in excel?


Forum|alt.badge.img+5

@Nirogini Janstin,

I get the same error when trying to load and when trying to execute.


Nirogini Janstin
Do Gooder (Employee)
Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 50 replies
  • Answer
  • October 31, 2023

@himasha.abeywickrama , there is a known bug on 22R2 older versions for excel migration. It is fixed on 22.2.14 but you can try it by removing the source column of COMPANY_POS_STRUCTURE.BUSINESS_UNIT_TYPE_DB this field under the `source mapping` tab and re-generate excel migration.

 


Forum|alt.badge.img+5

@Nirogini Janstin,

That worked! Thank you very much! You are awesome!