Review the Dynamic Share, Bulk Share, and/or Scheduled Bulk Share configuration for tables found in the discrepancies Review the configuration to ensure it is configured to capture everything expected. Here a couple things to keep in mind when reviewing the share options:
Parent/Child Hierarchy > Child Table Only (Default)This DEFAULT setting is enabled if the Share base table only and Include all child tables options are NOT selected. It will share all child tables one level below the specified table. This may be misleading as most people expect dynamic shares are auto-configured to share data from the table configured. Trigger Conditions Tab > Interactive OnlyThis option will only replicate data if a user executed an insert, update, or delete. It will NOT share data if a background job or script performed an operation against the table. Background jobs or scripts performing actions on tables users are attempting to sync to a database may not always be visible. Filter and Enrichment TabReview the conditions and all options in this tab to ensure nothing prevents replication from occurring for an expected record. Business Rule order and Business Rule whenThere is a possibility that the Perspectium Replicate business rule does not capture the final version of a record. Ensure that the dynamic share is configured to share the record after all business rules and workflows are complete. Duplicate Perspectium Replicate Business RulesSometimes, a single dynamic share can have two or more business rules associated to it. This will lead to sharing the source record multiple times. The Dynamic Share Business Rules Dashboard allows you to quickly identify any duplicates and you can Reset the Dynamic Share Business Rules to re-create all business rules for your active dynamic shares such that only a single business rule is associated with each active dynamic share.
ConditionsReview the conditions and all options in this tab to ensure nothing prevents replication from occurring for an expected record. Share updates since thenThis will only share records that have been inserted or updated since the date or time shown in the Last share time field. It simply modifies the query against the base table to capture records updated since the last execution time. This option is typically used with scheduled bulk shares. NOTE: There is a Known Issue with this bulk share option that is fixed in Fluorine Plus Patch 1.1 and above.
Check to see if the scheduled bulk share(s) are configured to execute as expected and the associated bulk shares are running at those times. Related bulk shares with filters using date or time stamps, such as sys_updated_on, can lead to data gaps if not properly configured based on the Repeat Interval of the scheduled bulk share. Ensure that the bulk share condition is configured to capture records update since the start time of the scheduled bulk share.
NOTE: Please review the Known Issues section of this document as it contains additional information that may impact the shares from functioning properly. |