Foundation Data Sync import set rows are set to Ignore when syncing a non-CMDB table via Service BridgeIssue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Foundation Data Sync (FDS) import set rows land in the staging table on the provider instance but are set to Ignore after the transform runs. No error message appears on the rows and no records are written to the target table. This occurs when a Robust Transform Engine (RTE) has been manually created and linked to the same data source as the FDS-generated transform map for a non-CMDB table. Symptoms<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } All import set rows on the provider instance show state Ignore after the transform runs.The Error column is empty on all affected rows.The Target record column is empty on all affected rows.The Import Set Runs tab on the affected import set shows the Robust Transformer column populated with the name of a manually created RTE, and the Transform Map column is empty.Data is confirmed present in the staging table, meaning transmission from the consumer is functioning correctly.No records are written to the target non-CMDB table on the provider instance.Downstream tables that reference the affected table may show rows in state Skipped with errors such as: Reference field value for <table>.<field> rejected: <value>The import set completes in seconds regardless of row count, indicating no meaningful processing is occurring. Facts<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Affects Foundation Data Sync (FDS) via Service Bridge between a consumer instance and a provider instance.The affected table is a non-CMDB table. Non-CMDB tables in FDS include but are not limited to: Product Model (cmdb_model - does not extend cmdb_ci despite the name), Asset, User, Group, Location, Company, Department, Stockroom, Knowledge, Hardware Model, Consumable Model, Hardware, and Consumable. Non-CMDB tables are defined as tables that do not extend cmdb_ci.FDS automatically creates a standard transform map for non-CMDB subscription items during setup. This transform map is sufficient and does not require supplementation with an RTE.An RTE was manually created via the CMDB Integration Studio ETL Transform Map Assistant and linked to the same data source as the FDS transform map. The ETL Transform Map Assistant is intended for CMDB CI tables only.The RTE was incompletely configured — the target class was not added in Step 3 of the ETL setup.The platform behavior when both a transform map and an RTE are linked to the same data source is that the RTE always takes precedence, regardless of whether it is correctly configured.Both instances were on Zurich Patch 7 at time of investigation. Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Zurich Patch 7. This behavior applies to all releases supporting Foundation Data Sync Service Bridge v2. Cause<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Foundation Data Sync uses different transform mechanisms depending on the table type: CMDB tables (tables that extend cmdb_ci): processed via the Identification and Reconciliation Engine (IRE) using an RTE configured through the CMDB Integration Studio ETL Transform Map Assistant.Non-CMDB tables: processed via a standard transform map that FDS auto-generates when the subscription item is created. IRE and RTE are not applicable to these tables. When a non-CMDB subscription item is set up via FDS, the ETL Transform Map Assistant remains accessible in the interface. If this assistant is used to create an RTE for a non-CMDB data source — for example, if the setup was performed following documentation intended for CMDB tables — an RTE is created alongside the existing FDS transform map. The platform gives the RTE precedence over the transform map whenever both are linked to the same data source. If the RTE is misconfigured — for example, because the target class was not added in Step 3 of the ETL setup — it produces an empty IRE payload. The scheduled import job runs, selects the RTE, generates no output, and sets all import set rows to Ignore silently. The correct FDS transform map is bypassed entirely and no records are written to the target table. Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } On the provider instance, open the CMDB Integration Studio by navigating to <instance-name>.service-now.com/$cmdb_integration_studio.do.Identify the RTE linked to the affected non-CMDB data source. The RTE will appear in the list grouped under the relevant CMDB Application. Note the Name and Data source columns to confirm it matches the failing subscription item.Click the RTE name to open the ETL Transform Map record.Confirm the record is the correct one to delete by checking: The name matches the RTE identified in step 2.The Data source field matches the FDS subscription item data source (for example, <SITM_number>-Product Model Data Source). Click Delete and confirm the deletion prompt. Administrator access to the provider instance is required to complete this step.Return to the affected inbound subscription item record (sn_fds_pro_inbound_subscription_item).Click Transform Map to confirm the FDS-generated transform map is still present and opens a valid map record. This map will now be used for all subsequent import runs.Re-trigger the import by navigating to the data source record linked to the subscription item and running Load All Records, or wait for the next scheduled import run.Check the import set rows for the affected subscription item. Rows should now show state Inserted or Updated, and the Robust Transformer column should be empty.If downstream tables were also failing with reference field errors, re-trigger those subscription items after the primary table has successfully synced. Reference field errors on dependent tables typically resolve once records exist in the target table on the provider instance.Check whether any other subscription items on the same provider instance have an RTE linked to a non-CMDB data source and repeat steps 2–9 for each one found. Note The ETL Transform Map Assistant button remains visible on non-CMDB inbound subscription item records. Using this button for non-CMDB tables creates an RTE that conflicts with the FDS transform map. For non-CMDB tables, use the Transform Map button only to review or modify the FDS-generated transform map. Documentation context The setup steps documented at the following page describe using the ETL Transform Map Assistant for CMDB table subscriptions: https://www.servicenow.com/docs/r/service-bridge/service-bridge-v2-fds-validate-subs-items-provider.html This page does not explicitly distinguish between the correct setup path for CMDB tables and non-CMDB tables. If following this documentation for a non-CMDB subscription item such as Product Model (cmdb_model), do not use the ETL Transform Map Assistant. Use the Transform Map button instead to verify the FDS-generated transform map. No additional RTE configuration is required for non-CMDB tables. Related Links<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Foundation data sync overview https://www.servicenow.com/docs/r/service-bridge/service-bridge-v2-explore-foundation-data-sync.html Validate subscription items as a provider https://www.servicenow.com/docs/r/service-bridge/service-bridge-v2-fds-validate-subs-items-provider.html Using Foundation Data Sync as a provider (Zurich) https://www.servicenow.com/docs/bundle/zurich-service-bridge/page/product/tmt-service-bridge-2/concept/service-bridge-v2-using-foundation-data-sync.html IntegrationHub ETL https://www.servicenow.com/docs/r/servicenow-platform/integration-hub-etl/integrationhub-etl.html Foundation Data Synch and CMDB collaboration (Community) https://www.servicenow.com/community/technology-blog/foundation-data-synch-and-cmdb-collaboration/ba-p/3359949