Error when duplicating ETL Transform Maps in the IntegrationHub ETL

Katie Meadows
Tera Contributor

I'm trying to upgrade our SCCM plugin to the SG-SCCM. We have two SCCM servers, one for servers and one for workstations. We'll call them Server-SCCM and Client-SCCM. I've successfully configured both connections (no integrated authentication) and both connect and send back the test data. 

 

When I use IntegrationHub ETL to setup the mapping it has the default SG-SCCM Computer Identity, etc.. ETL Transform Maps each associated with the appropriate default SG-SCCM data sources. I do not want to alter these. I want to create duplicates, one each for the Server-SCCM data sources and one each for the Client-SCCM data sources. When I try to create a duplicate I get an error: 

 

 

Data source table already associated with 'SCCM Computer Identity' ETL Map.

 

 

(Screenshot of error message below.) Earlier I had a similar problem and renamed everything down the line all the way to and including the Import set table label and Import set table name. In the process I lost the OOB transform maps. I created such a mess I ended up uninstalling everything and started again once I found out you can duplicate ETL transform maps via the labeled button on the IntegrationHub ETL.

 

Before I uninstalled everything, I had all of the Client SCCM site working correctly but couldn't get the Server site to work. I've spent hours searching online and the best I found was this forum post: https://www.servicenow.com/community/cmdb-blog/service-graph-connector-for-microsoft-sccm-faq-and/ba... Says SG-SCCM supports multiple SCCM with version 3.0.x (I installed v3.4.0) and they named one SG-SCCM-A and one SG-SCCM-B. I've tried that and keep hitting walls. I'm open to any and all assistance.

 

Thank you in advance!

 

UPDATE: I think I have the two connections setup correctly. The problem I'm having is setting up the different transforms in the IntegrationHub ETL. I want to use the OOB SG-SCCM maps as a starting point by duplicating them but I keep getting the error.

3 REPLIES 3

Bob Hage
Tera Expert

I am having the same issue with a single SCCM server. Were you able to correct this?

UndertoadNW
Tera Contributor

I was having the same issue, but found this article that directs you to mark the transform map as inactive. This worked for me.

Description:  Creation of ETL Map only allows creation of new map only for import set tables are not being used.
Cause: Customer may have a lot of transform maps (in "sys_transform_map" table) already using existing data sources' import set table. ETL only allows to create new map if the data source's import set table is not being used.

Resolution: Check existing transform maps in sys_transform_map table. Mark the map which is using import set table as inactive if customer wants to create ETL Mapping.

deanmpage
Giga Expert

I recently ran into the same issue when trying to use the IntegrationHub ETL to test some minor customisations to the SCCM Computer Identity transform mappings, and this is the solution that I was able to figure out:

 

  1. Make sure you're in the "Service Graph Connector for Microsoft SCCM" Application Scope.
  2. Navigate to 'System Import Sets > Administration > Robust Import Set Transformers' (or direct navigate to sys_robust_import_set_transformer.list). 
  3. Locate and open "SCCM Computer Identity", or whichever ETL Transform Map is causing the issue; in the original example this would be a custom duplicate of the OOB SCCM Computer Identity.
  4. Open the referenced Transformer definition record ("SG-SCCM Computer Identity" for OOB SG-SCCM).
  5. Update the Data Source reference field in the CMDB Integration Studio Application Data Source record to your preferred SCCM Computer Identity data source record; you can find the list under 'Service Graph Connectors > SCCM > Data Sources'. 

You should then be able to return to the IntegrationHub ETL and have the Data Source you need in the ETL Transform Map setup.

 

I hope this helps anyone else running into this issue.