How to address error "Invalid Mapping Data" with mappings deleted messages during reviewing and completing any OOB transform map in IntegrationHub ETL


When trying to review and complete any OOB transform map in IntegrationHub ETL, you will see error "Invalid Mapping Data" with message like "One of more RTE mappings have been automatically deleted due to..." please see



Release or Environment

All releases. 


This should not have any impact on conventional imports and robust transforms. The message that shows is expected.
This SCCM integration is build before IHETL was available and so there might be some invalid mappings that were accidentally created. They don’t have any affect, its just ETL cleaning up unused RTE metadata.




This is expected message and the error is showing the reason (IRE rule missing for the mentioned look up item). The message/error can be ignored due to no impact. 

Additional Information

Similar question here

This may help with more info: