Error duplicating IntegrationHub ETL transform map

[ifeomau]

I'm trying to create a duplicate IntegrationHub ETL transform map. In the "Duplicate ETL transform map" dialog, I enter the name of the map I want to copy, the application name and the name of the new map.  After I enter the new data source name, I get this error:

"This map cannot be used as a copy source for the selected data source"

The new data source is a copy of the original map's data source.

Please help. Thanks.

[Pradeep Thipani]

Hi @ifeomau ,

I have experience working with Integration ETL Hub, but I have not tried to replicate the OOB Data source. I reviewed some articles below that may assist you in resolving your issue.

https://www.servicenow.com/community/sysadmin-forum/error-when-duplicating-etl-transform-maps-in-the...

https://www.servicenow.com/docs/bundle/zurich-servicenow-platform/page/product/configuration-managem...

Thanks,

Pradeep

[Bhuvan · Accepted solution]

@ifeomau 

Follow this knowledge article, it should resolve the issue.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0869518

Issue

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

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan