MITSTA_TRANSFORM_1 infinite loop issue has returned

Joe McHale

Happy new year everyone!

We noticed in one of our customer environments that the Fact-Warehouse space had got stuck during processing. After investigating, we can see the MITSTA_TRANSFORM_1 is looping

There is an old KB article from 2024 that addressed this issue (May 2024) .. ERP M3 - Long running processing of the Warehouse space - infinite looping of MITSTA_TRANSFORM_1 we put this workaround in at the time and it worked great. However with this latest loop, am wondering if it is failing or potentially a new issue has appeared?

Has anyone else encountered issues with their Fact-Warehouse space getting stuck during processing?

Thanks, Joe

Joe McHale

Hi Diane - we have an update on this actually

Looks like the previous workaround KB2204522 had been superseded by KB2243373

Original - KB2204522
ERP M3 - Long running processing of the Warehouse space - infinite looping of MITSTA_TRANFORM_1

Latest - KB2243373
ERP M3 - MITSTA_TRANSFORM_1 Infinite Loop Fix

By updating the MITSTRA_TRANSFORM_1 script to align with the latest SMD space, and adding a new scripted source in that was then referenced, the orchestration ran okay

Hope the above is useful! I guess there should be a note added to KB2204522 that KB2243373 is the latest and greatest

Thanks, Joe