Error duplicating IntegrationHub ETL transform map

ifeomau
Tera Contributor

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.

 

1 ACCEPTED SOLUTION

Bhuvan
Tera Sage

@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

View solution in original post

2 REPLIES 2

Pradeep Thipani
Mega Sage

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

 

 

"If this response was useful, please select 'Accept as Solution' and mark it as 'Helpful.' This helps me provide better answers and assists the community ".

Regards,
Pradeep

Bhuvan
Tera Sage

@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