Wikis - Page

(UCMDB) Support Tip: TQL query result discrepancy between a Pattern Based Model (PBM) model and a pattern view

0 Likes

Rerported in UCMDB 23.4
 

Situation

A Pattern Based Model (PBM) model "PBM1" was created from a pattern view "PV1".

Open PV1 > Calculate > the number of Nodes in the PV1 view is N1.

Open PBM1 > Get related Nodes of PBM1 model > Get the number of Nodes N2.

When N1 and N2 are not equal all the time, the discrepancy issue occurs.
 

Resolution

  • Do not use the same TQL with a Pattern-based mode and a Pattern view OpenText Documentation Portal (microfocus.com)
  • Delete the Pattern-based model and recreate it.
  • Documentation for the PBM Pattern Based Model Wizard - Universal Discovery and CMDB (microfocus.com) but under the Modelling Studio there pages related to all resources types
  • Re-evaluate the TQL definition or re-create the PBM if an error occurs at run. The PBM can be re-calculated on demand by JMX method from Business View Enrichment Service calculateAdHocEnrichment and checking the cmdb.enrichment.log for the output.
  • Invoke retrieveTqlNames JMX method > search for the problematic query PV1. Below is an example:
Patter_view_name - Active, NOT Persistent, MED_PRIORITY, Group=3
  • If the TQL is active, invoke listAllGates to get the TQL name and breakTqlGate JMX method for the TQL.
  • If there are a lot of the queries used by the PBMs are ACTIVE, invoke deactivateAllBusinessViewEnrichmentTqls JMX method from Business View Enrichment Services.
  • For cleanup purpose, invoke runEnrichmentCleanup JMX method from Business View Enrichment Services.

Labels:

Support Tips/Knowledge Docs
Comment List
Related
Recommended