Manufacturer field on hardware model records shows a sys_id instead of the manufacturer name after Service Graph Connector import - Support and Troubleshooting

Manufacturer field on hardware model records shows a sys_id instead of the manufacturer name after Service Graph Connector import Issue .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: ; } } Following the import of hardware Configuration Items (CIs) via Service Graph Connectors (SGC), such as SG-SCCM and SG-Intune, the Manufacturer field on Hardware Product Model records exhibits a system ID (sys_id) instead of the manufacturer name. The referenced sys_id is absent from the Company (core_company) table, leading to a dangling reference. Additionally, duplicate model records are generated during subsequent import processes.

Symptoms .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: ; } } Hardware Product Model records show a manufacturer sys_id with a blank display value. The sys_id in the Manufacturer field does not correspond to any existing record in the Company (core_company) table. New duplicate model records are created on each import run instead of matching existing records. The import log records a database error: 'duplicate key value violates unique constraint "core_company_hash_key" as below. 2026-07-27 06:09:10 (993) worker.4 worker.4 txid=da74f01a83de GlideRecordITable *** ERROR *** FAILED TRYING TO EXECUTE ON CONNECTION glide.11 (connpid=3609888): INSERT INTO core_company ("country","publicly_traded","sys_mod_count","sys_updated_on","canonical","sys_class_name","manufacturer","sys_id","sys_updated_by","sys_created_on","vendor","name","u_preferred_language","sys_created_by","hash","primary","customer") VALUES('country','0',0,'2026-07-27 13:09:10+00','1','core_company','0','aa74381a83de4790565455c0deaad33d','user','2026-07-27 13:09:10+00','0','XXXXX','English','user','BT9CxrrjQyyuJw6pePfmOA==','0','0') /* node008, gs:glide.scheduler.worker.4, tx:da74f01a83de4790565455c0deaad3e7, hash:177827830 */ Unique Key violation detected by database (ERROR: duplicate key value violates unique constraint "core_company_hash_key" Detail: Key (hash)=(BT9CxrrjQyyuJw6pePfmOA==) already exists.) org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "core_company_hash_key" Large numbers of Hardware Product Model records accumulate with a populated manufacturer but an empty 'manufacturer.sys_id'. Release .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 currently supported releases where Normalization Data Services is enabled.

Cause .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: ; } } When Normalization Data Services (NDS) is activated but its guided setup remains incomplete, existing core_company records are not designated as canonical. Since these records are not normalized, the Make and Model process cannot match the manufacturer to an existing company record during import. As a result, it attempts to insert a new company record each time. However, this insertion fails due to the unique hash constraint on the Company table, as the matching hash already exists. Consequently, no new company record is created; however, the model record continues to be saved with a manufacturer reference pointing to a sys_id that was never committed, resulting in an orphaned reference. This issue arises from configuration or data preparation errors rather than a defect in the product.

Resolution .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: ; } } Complete the Normalization Data Services (NDS) guided setup so that core company records are normalized with the canonical flag set to true. Confirm the guided setup finishes fully; a partially completed setup leaves core company records unnormalized and reproduces the issue. Trigger a new import from the affected data source (for example, Intune). Confirm that newly created model records now resolve the manufacturer to the correct company name. Clean up the existing orphaned model records by building a delete job on the Hardware Product Model table filtered where Manufacturer is not empty and Manufacturer's sys_id is empty. Export the affected records before deleting so they can be restored if needed; some records may not delete if they have dependent related records. Monitor subsequent imports to confirm no new orphaned manufacturer references are created. Related Links .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: ; } } Implementing normalization data services using guided setup Work with hardware normalization