question Error loading this ETL transform map in CMDB forum

Error loading this ETL transform map

Jbelter — Tue, 13 Feb 2024 14:40:39 GMT

Build: glide-utah-12-21-2022__patch7a-09-28-2023 (using a PDI)
I am trying to adjust the Robust Transform Map for the Service Graph Connector for Tanium (v1.5.0) using the IntegrationHub ETL (v3.2.1) app. However, whenever try to load up the "SG Tanium Hardware and Software" ETL Transform Map, I get the following error:

I have tried re-installing both plugins (even having them delete the tables on the uninstall), but no luck. I also tried looking at the suggestion in this article...
https://www.servicenow.com/community/cmdb-articles/ih-etl-faq-in-guided-set-up-page-it-shows-error-loading-this-etl/ta-p/2300438

I noticed that there was a duplicate record in one of the tables so I deleted that, otherwise I am not sure what the correct mappings would be for the operations table. I have attached both tables mentioned in the article to this post just in case.

Is anyone else having this issue with the Tanium Service Graph Connector Transform Map?

Re: Error loading this ETL transform map

Ashish37 — Sat, 08 Jun 2024 15:05:22 GMT

Hi, Were you able to find the solution for this error? I am also facing the same error for Service Graph Connector for Excel"

Re: Error loading this ETL transform map

FrédéricS — Wed, 10 Jul 2024 08:40:08 GMT

Hi, I am also facing the same error for Service Graph Connector.

Re: Error loading this ETL transform map

Richard Shively — Fri, 01 Nov 2024 13:45:45 GMT

Check this article out and see if running through these helps, I was able to resolve the same error by going to the 'sys_rte_eb_operation' table and deleting the entry that was showing a sys_id instead of a field name.

Re: Error loading this ETL transform map

Richard Shively — Fri, 01 Nov 2024 13:46:38 GMT

https://www.servicenow.com/community/cmdb-articles/ih-etl-common-error-scenarios/ta-p/2301140
https://www.servicenow.com/community/cmdb-articles/ih-etl-faq-in-guided-set-up-page-it-shows-error-loading-this-etl/ta-p/2300438

Re: Error loading this ETL transform map

Callum Spiers — Fri, 14 Feb 2025 16:44:09 GMT

Deleting the most recent import set (we had an import set stuck in 'loaded') cleared up the issue.

All deleting all import sets worked too for a different ETL.

Re: Error loading this ETL transform map

Pierre-Yves BG — Tue, 08 Apr 2025 23:29:52 GMT

Thank you so much!

Deleting only the Loaded ones was not enough as well, I had to delete all import sets / concurrent import sets and it resolved the issue!