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

Ashish37
Mega Guru

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

FrédéricS
Tera Contributor

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

Richard Shively
Tera Contributor

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.