Review the Dynamic Share/, Bulk Share, and/or Scheduled Bulk Share configuration for tables found in Step 1 (ServiceNow)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 1 one level below the specified table. This may be misleading as most people expect Dynamic Shares 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. Customers may not always be aware of background Background jobs or scripts performing actions on tables they 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 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 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 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 active dynamic shares such that only a single business rule is associated with each active Dynamic Sharedynamic 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 scheduled bulk shares. NOTE: There is a Known Issue with this Bulk Share this bulk share option that is fixed in Fluorine Plus Patch 1.1 and above.
Check to see if the Scheduled Bulk Sharethe scheduled bulk share(s) are configured to execute as expected and the associated Bulk Shares bulk shares are running at those times. Related Bulk Shares 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 Repat Repeat Interval of the Scheduled Bulk Sharescheduled bulk share. Ensure that the Bulk Share bulk share condition is configured to capture records update since the start time of the Scheduled Bulk Sharescheduled bulk share.
NOTE: Please review the Known Issues Issues section of this document as it contains additional information that may impact the Perspectium Shares shares from functioning properly.
|