IH-ETL FAQ - In guided set-up page, it shows “Error loading this ETL transform map” error

[Siyou Li]

This error means that your transform map metadata is incorrect or corrupted. If you are using an OOB ETL transform map installed from store, please try repairing or reinstalling the OOB ETL transform map. 

• Make sure required source or target fields in “sys_rte_eb_operation” table are correctly mapped

• Make sure there is no duplicate entity in "sys_rte_eb_entity" table

• If your nested payload has array of primitive values (array of string, number etc), there is a fixed PRB1472891 related to this issue, please make sure your instance is upgraded to latest patch

• If using IH-ETL version older than 2.0 to load nested payload, it will trigger this error. Please upgrade to latest IH-ETL version to load nested payload

Additional Resources

Landing page

Common error scenarios

[SHansen1]

I figured out a fix for this error with Service Graph Connector for Excel and wanted to share it, since I can't find it online.  Simply delete the old import sets and the error goes away. 

[irvinglemus]

Thank you SHanse1, deleting the old import set related to Service Graph connector, removes the error, I found this useful for Service Graph Connector for Azure, the setup guide doesn't show the error anymore, I will try to follow with the setup.