Error loading this ETL transform map

Jbelter
Tera Guru

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:

Jbelter_0-1707833552562.png


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

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?

6 REPLIES 6

Callum Spiers
Tera Contributor

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.

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!