The CreatorCon Call for Content is officially open! Get started here.

Robust Transform Map - IdentifierEntrySysId: Unknown

Willie
Tera Expert

We're implementing IRE in our organization and building a testing framework to validate identification rules. As part of this, we're trying to report on entries in the [cmdb_identifier_entry] table based on payloads processed via IRE.

 

In my PDI, when executing IRE through a Robust Transform Map configured via IntegrationHub ETL, the logs show that a match and update occurred. However, the SysId for cmdb_identifier_entry is not returned in the logs—it appears as "unknown", even though the identification rule was triggered.

 

Willie_1-1759178312711.png

 

 

 

 

 

Interestingly, when I run the createOrUpdate API via a background script, the SysId for the cmdb_identifier_entry is exposed and searchable in the table.

 

Willie_2-1759178331738.png

 

Has anyone encountered this behavior? Is there a known limitation or configuration that affects visibility of the identifier entry SysId in Robust Transform Map logs?
 
Any insights or suggestions would be appreciated. I've attached my notes, logs, and sample data.

 

2 REPLIES 2

Willie
Tera Expert

I think what's happening is that Identifier Rules get skipped because an Object Source ID was already created from the first payload, so then IRE references Object Source

 

Willie_0-1759260887197.png

 

 

When I delete the Object Source IDs above and then rerun IRE via import set, the IdentifierSysID is reported.

 

Willie_1-1759260967711.png

 

Can someone explain this behavior or reasoning behind the design?

drelo
Tera Contributor

Hi Willie,

Not sure if you've stumbled across this KB yet? I've found it really useful for troubleshooting IRE issues that are a bit more complex.

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