Summary shows a different number of implicit deleted objects - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

Problem

When submitting a job in Data Validator Job Management, the implicit delete summary and the actual implicit delete report show different numbers of implicit deleted objects.

Solution

The counts can differ between the implicit delete summary and the actual implicit delete report if the underlying dataset changes, such as:

  • When a number of new objects have been loaded in the target system between the report being generated and the report being approved. Ensure you always approve an implicit delete report before loading any new objects.

  • When the implicit delete fails due to a database connection issue and the process continues after reconnection.

    For example, each implicit delete process is split into batches. If the second batch fails due to a database connection failure and then continues on reconnection, the first batch may have removed some of the items from the second batch due to cascading deletes. Therefore, the number of items in the implicit deleted summary shows fewer items than the actual implicit delete report count.

  • When two implicit delete rules have the same items flagged. When implicit delete is processed, the items are only deleted once.

    For example, the first rule deletes items by plant (all tags in plant) and the second rule deletes items by class (all centrifugal pump tags). When implicit delete is processed, the second rule would show less tags in the implicit delete summary as the first rule deleted the items.

SHARED Tip Always refer to the implicit delete report for the correct numbers of implicit deleted objects.