Missing relationship, MSSQL Availability Group Replica [cmdb_ci_mssql_ag_replica] Contains::Contained by MS SQL Database [cmdb_ci_db_mssql_database] - Known Error

Missing relationship, MSSQL Availability Group Replica [cmdb_ci_mssql_ag_replica] Contains::Contained by MS SQL Database [cmdb_ci_db_mssql_database] Description IRE mistakes the current payload as duplicates when there are multiple Availability Groups with similar names and relations to different databases.

Steps to Reproduce

Run "MSSql DB On Windows" pattern discovery with extension section "Collect MSSQL HADR - Availability Group Info" pattern. Observe missing relationship between Databases [cmdb_ci_db_mssql_database] and Availability Group Replicas [cmdb_ci_mssql_ag_replica], and fewer than expected discovered Availability Groups. Debug Step 4.14 "Create relationship between mssql replica and mssql database" and observe the missing relationships between similarly named Availability Groups and Databases.

Workaround This problem has no workaround, is currently under review and targeted to be fixed in a future release. Subscribe to this Known Error article to receive notifications when more information will be available.