Review the Dynamic Share/Bulk Share/Scheduled Bulk Share configuration for tables found in Step 1 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: Dynamic Share
Parent/Child Hierarchy > Child Table Only (Default)This DEFAULT setting is enabled if the 'Share base table only' and ' and Include all child tables' options options are NOT selected. It will share all Child Tables child tables 1 level below the specified Tabletable. This may be misleading as most people expect expect Dynamic Shares are auto-configured to share data from the Table table configured. Trigger Conditions Tab > Interactive OnlyThis option will only replicate data if a User user executed an insert/update/delete. It will NOT share data if a Background Job background job or Script script performed an operation against the table. Customers may not always be aware of Background Jobs background jobs or scripts performing actions on Tables tables they are attempting to sync to a Databasedatabase. 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 business rule does not capture the final version of a record. Ensure that the the Dynamic Share is configured to share the record after all Business Rules business rules and Workflows workflows are complete. Duplicate Perspectium Replicate Business RulesSometimes, a single 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 active Dynamic Shares such that only a single business rule is associated with each active Dynamic Share. Bulk Share
ConditionsReview the conditions and all options in this Tab 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/time shown in the 'Last share time ' Fieldfield. It simply modifies the query against the Base Table 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 this Bulk Share option that is fixed in Fluorine Plus Patch 1.1 and above.
Scheduled Bulk Shares
Check to see if the the Scheduled Bulk Share(s) are configuerd configured to execute as expected and the associated Bulk Shares are running at those times. Related Bulk Shares with filters using date/time stamps such as sys_updated_on can lead to data gaps if not properly configured based on the Repat 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 Known Issues section of this document as it contains additional information that may impact the Perspectium Shares from functioning properly
|