Solved

IFS Excel Add-In - MI_RETRIEVAL_ERROR

  • 30 October 2023
  • 6 replies
  • 148 views

Userlevel 2
Badge +5

Hello,

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

Any idea why?

icon

Best answer by Nirogini Janstin 31 October 2023, 03:08

View original

6 replies

Userlevel 1
Badge +5

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?

Userlevel 2
Badge +5

Hi @Nirogini Janstin,

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

Userlevel 1
Badge +5

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

Userlevel 2
Badge +5

@Nirogini Janstin,

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

Userlevel 1
Badge +5

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

 

Userlevel 2
Badge +5

@Nirogini Janstin,

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

Reply