Version 

Release Date: January 13, 2023

This hotfix requires read replica and is an advanced feature that must be set up first by ServiceNow Support. Please contact Perspectium Support for further information. 

Enhancements

Bulk shares will use read replica database for querying for table records by using setCategory('perspectium').

Release Date: November 21, 2022

Bug Fixes

Fixed issues with Bulk Share's name, target queue and table name fields' ACLs not having roles/conditions.

Release Date: July 28, 2022

Enhancements

Updated Table Compare business rule with inserting record to run after to follow ServiceNow health scan best practices.

Removed DOM manipulation as possible to follow ServiceNow health scan best practices.

Updated client scripts and UI pages to use client data when possible to follow ServiceNow health scan best practices. 

Updated script includes to not use variables named gr to follow ServiceNow health scan best practices. 

Enabled unique index on number field of receipts table to follow ServiceNow health scan best practices. 

Updated Table Compares table to have proper ACLs to follow ServiceNow health scan best practices. 

Added Alert category to all Perspectium application notifications to follow ServiceNow health scan best practices.  

Removed deprecated business rules that weren't using condition field to follow ServiceNow health scan best practices.  

Release Date: July 28, 2022

Bug Fixes

Removed deprecated UI policy and business rules to follow ServiceNow health scan best practices.  

(info) NOTE: These objects are not included in Helium 6.1.0+. This release only removes these objects and is only needed if you have previously installed a version prior to Helium 6.1.0 and want to remove these records from your instance.

Release Date: May 8, 2022

Bug Fixes

Fixed display values for choice list fields are not shared if they are under specific domain for Dynamic Shares.

Release Date: May 1, 2022

Bug Fixes

Fixed an issue where the Dynamic Share "Sharing Setup" will change to default settings upon upgrade.

Release Date: April 25, 2022

Bug Fixes

Fixed the issue where glide list display values are not shared if using "Share only selected fields".

Fixed the issue where "Share selected fields" list of fields unexpectedly deleted from bulk shares.

Fixed display values for choice list fields are not shared if they are under specific domain.

Scheduled bulk shares will now function as expected upon upgrade.

Fixed an issue where the Bulk Share "Sharing Setup" will change to default settings upon upgrade.

Fixed an issue where custom table schema is not being honored when shared out to the agent.

Release Date: November 17, 2021

Bug Fixes

Added logic to skip bad queries on the attachment table so to not return all records for table and to enhance performance.

Release Date: September 24, 2021

New Features

You can now import previously downloaded Perspectium share configurations from the Download Share Configuration tool in one instance into another instance using the Import Share Configurations tool. 

Have additional logging with the property Generates detailed outgoing HTTP logging to help troubleshoot when connecting to the Integration Mesh. 

Enhancements

You can now share child records when cascade delete behavior "delete no workflow" is enabled and delete recovery listener or audit delete listener is enabled. 

You can now configure how often the Perspectium receipt table is rotated in your ServiceNow instance. 

Perspectium properties pages are updated to the He20 UI style. 

Removed Package calls in Perspectium script includes and replaced with Glide object equivalent as available. 

Optimize PerspectiumReplicator script include for better performance and troubleshooting. 

Perspectium Uninstall will now remove all Perspectium modules and tables.  

Additional logging statements is now available to notify users that the truncate command executed successfully in agent. 

A messageSequence attribute containing the Epoch time of when the message was created is now added to all outbound dynamic/bulk share messages. 

Additional tables can now be selected for the Table Monitoring tool.  

Error Notifications will not be overwritten when upgrading the Perspectium Core application. 

You now have the option to limit the number of records Attachments and Audit Outbound Processing job processes.

Removed custom table (u_psp_bulk_share_job) from Core application that is no longer being used. 

Scroll bars will now appear in UI pages for the Core application. 

Perspectium update sets will install everything needed on commit so running Finish Install is no longer be required. 

Heartbeat messages will now contain the UI version of the Core application in the attributes field, i.e. ui=He20, ui=legacy. 

Table compare feature now allows for comparing child tables as well.

Reset values in the related list when user changes a dynamic share table

Enhanced handling on display value fields for glide_list, glide_duration and choice fields in the Table Schema (compatible with DataSync Agent 6.1.0).

The following features are redesigned to fit the Helium (He20) style to improve user experience:

  • Table Monitoring 

  •  Create MultiOutput Jobs 

Added backwards compatibility support by using the table map Type field to look for table schema if no table found with a value matching the Target Table Map field.

Share on updated display value in dynamic shares will now only create one business rule for each reference table for multiple shares. 

Removed ETS references for script include optimization. 

When a bulk share is executed and debug logging is enabled, you will now be warned if the number of records shared is larger than the value specified in the Perspectium properties. 

Add display value language is now available for dynamic share using flow designer. 

Sharing scoped app tables is now available without manual setup. 

Support DataSync Agent's Validate Configuration to check the encryption methods in bulk/dynamic shares with the shared queue in the core and agent.xml. 

Enhanced validation for advance features for bulk and dynamic shares. 

Subscribed queues with bad credentials will now be deactivated when the Perspectium Inbound Subscribe job runs. 

Selecting the value "after" for "Business Rule When" will no be available when delete trigger is enabled. 

Bug Fixes

An alert will now appear in Download Share Configurations when there are no share configurations selected. 

Dynamic share using flow designer will no longer cause undefined outbound messages. 

When using the download share configuration tool, downloaded configurations will no longer be cached after multiple downloads while staying on the page. 

The selected sharing setup option will now be honored when running a bulk share from a dynamic share. 

Table Field mappings without parentId will no longer be downloaded into the u_psp_table_field_map.xml when downloading table map configurations using the Download Share Configurations tool. 

Validated journal fields are properly created when "Include journal fields" are enabled for custom schema or conditional shares. 

Updated scripting fields in Perspectium app (Bulk Shares, Dynamic Shares, etc.) to all work with GlideController and GlideScopedEvaluator. 

Bulk share history record will now account for additional records shared. 

Null pointer exception issue no longer appear when using Oracle Database in ServiceNow. 

Emojis will now always get captured when the property, com.perspectium.replicator.emoji_support, is enabled. 

Updated the Core application font to use Proxima-Nova. 

Bulk sharing SLA tables with conditions applied will not error in sharing records. 

Enhanced error handling in the Perspectium action used in flow designer dynamic shares to minimize system logs. 

Removed update on default ServiceNow Execute Now UI action to avoid upgradability issues. 

Upon execution of Uninstall Non-Observer Components with Helium core update set, he20 modules will no longer be present. 

A Table Map with String fields that have an html value will no longer cause the outbound message to have an empty value. 

If a share/subscribed queue is created with monitor check and attempts to save the form, the form will no longer throw a mandatory Endpoint URL error.

Release Date: September 22, 2021

Bug Fixes

Display values will now be included in the outbound message for list fields. 

Release Date: August 26, 2021

Enhancements

Table compare now supports the merged attachments table for fully built attachments.

IODateTimePlugin now supports the merged attachments table for fully built attachments.

Release Date: TBD

Bug Fixes

The start time and scheduled job interval in are now accurate when creating a scheduled table compare for audit shares and compare records by table. 

Release Date: August 12, 2021

Bug Fixes

Dynamic sharing with Use audit delete listener enabled will now trigger a delete outbound message.

Deleting a dynamic share with Use delete recovery listener enabled will now remove the business rule created for that share in the sys_delete_recovery table. 

The Resend Unacked Receipts job will no longer have issues resending messages for deletes. 

Release Date: April 20 2021

Bug Fixes

Upon installing Helium Core, the u_psp_heartbeat table will no longer get deleted.

Release Date: March 19, 2021

Enhancements

Removed the Getting Started page for better user experience since features on that page can be accessed through other modules.

Bug Fixes

Fixed an issue with attachments, comments, and sys audit records not sending out correctly with Data Guarantee.

Release Date: February 28, 2021 

New Features

Start comparing your records from ServiceNow to a Database or to another ServiceNow instance with Table Compare by share or by table/condition. With Audit Shares, you can compare records shared by bulk shares or dynamic shares with the records in your database. With Table Compare by Table/Condition, you can compare records that satisfy specified conditions with the same records in your database. You also have the option to be notified of discrepancies when table compare is run. 

Enable the Use Delete Recovery Listener feature to ensure that records that may have bypassed the ordinary delete business rule are included in your dynamic share. 

Enable sharing indexes of a table in ServiceNow for the DataSync Agent to create the same indexes in the database.

You can now ignore specific field mappings in table maps for cases where your conditions aren't met. 

Enable truncating table in the database by the DataSync Agent using Truncate Before Share.

Switch between the Legacy UI or the New UI with Switch UI versions.

Navigate through getting started with the DataSync for ServiceNow application with the Getting Started module. 

Request a Troubleshooting Report from another ServiceNow instance. 

You can now enable the use of multiple concurrently running scheduled jobs with the Create Inbound Processors tool. 

With the global variable, psp_name, you can change the table name in the name field before the outbound message is sent in a Before share scripts

To improve bulk share performance and increase throughput, you now have the option to choose the number of jobs to process the records shared. See Multiple Bulk Share Jobs.

Remove records that no longer exist in your instance from your agent database using Synchronize Deleted Records.

Choose or limit which child records will be dynamically shared with the Shared Child Tables list. 

You can now turn off receipts for a share if you don't want to generate receipts for a dynamic share or bulk share. 

Enhancements

Added additional Database Indexes to u_psp_log_message to enhance performance of specific queries. 

When sharing out a database view table via bulk share, there’s a ServiceNow limitation set to 10k records. There is now a warning message that will alert you on how to change that limit.

Renamed Perspectium Bulk Share Send Deferred scheduled job to Perspectium Check Deferred Bulk Shares to better reflect functionality.

If a queue gets deactivated due to a 401 error, the status field of the queue will display a message explaining why the queue is deactivated. You can also check Perspectium Logs for more details. 

Records will now be shared upon changing the display field for a reference table with Share on updated display values.

The sys_user_has_role can now be chosen for dynamic share using flow designer

Encryption Mode is now available for shared queues. 

Re-share records with a bulk share configuration in Compare Records by Table/Condition

Most recent update of a record will be checked for in Table Compare. If the most recent record is not found, the record will be re-shared.

You can be notified using ServiceNow email notifications when the Agent or Meshlet has an error processing a record.

Scheduled jobs such as Perspectium MultiOutput Processing and Replicator Subscriber will no longer get stuck when no Perspectium properties are populated. 

Reset your data cleaner rules for situations where the outbound messages are unable to clear up. See Troubleshooting DataSync for ServiceNow Issues.

Information message added to further explain the next step when enabling monitoring queues. 

Perspectium Data Cleaner (u_psp_data_cleaner) table is added to the Clone Exclude Table (clone_data_exclude). 

Added attribute to receipt messages to indicate the receipt has been re-shared. 

Counter messages will no longer exceed byte limit.

Removed Perspectium tables no longer being used to reduce custom table countu_psp_message_set_activity, u_shared_queue_group, u_psp_repl_reg, u_psp_ets_out_message.

Bulk share's timezone will now match the current user's timezone. 

Navigate through all of the available outbound messages modules with the Outbound module.

Access all sharing options with the Shares module.

Troubleshooting features are now accessible in one module: Troubleshooting

The Properties module now contains an easy access to the General Settings and the DataSync Settings.

Features that will be deprecated in future releases, but are still accessible in the application will be accessible through Legacy Features

Troubleshooting Report now separates bulk share, dynamic share, and shared/subscribed queues reports. 

Access all tools features with the Tools module.

Enhanced module arrangements for a clear user experience when navigating the app. See How to Use DataSync for ServiceNow for the updated arrangements!

Added support for sending Troubleshooting Report to another ServiceNow instance in addition to Perspectium Support. 

Enhanced list view to better show relevant information for multiple Perspectium tables including dynamic shares, bulk shares, and inbound/outbound messages. 

MultiOutput jobs can now be created by outbound queues or outbound table sys_id. 

Include multiple processing jobs for attachments and audits when creating MutltiOutput jobs.

Added property to opt out on updating dynamic share record counts to optimize dynamic share performance.

Starting with ServiceNow's Paris release, setWorkflow applies to Flow Designers to prevent flows from executing. Upon the creation of a dynamic share using flow, a message will appear to inform you on how to continue using setWorkflow without stopping your Flow Designer. See Can I configure it so setWorkflow doesn't prevent my flow designers from running?

Enhanced installation script to avoid Preview errors upon importing the application's update set. 

A weekly Troubleshooting Report will now be sent to Perspectium Support. 

When using MBS 3.0, you can use the mesh_entry_id field to verify that the outbound message is saved to a file in a queue in the Perspectium Integration Mesh.

Child tables can now be included with Data obfuscation.

Scheduled sync up can now capture deletes that may have been missed with Activate delete sync 

Logging and naming of Perspectium scheduled jobs and script includes have been updated for better understanding and reflection of what each do. 

Starting in ServiceNow's Paris release, Flow Designer will capture changes from the selected table and its extended tables. With Helium release, you will no longer see additional Flow Designer's created for extended records.

Set a time that when reached will delete pending receipts. See Deleting receipts

You can now limit the number of receipts created in the DataSync Settings.

Updated information messages for Get Queue Status in shared queues to be more consistent and concise.

Updated logging messages for queue heartbeats for better troubleshooting. 

Fixed issue with display values that affects add display value language feature.

Adding a 'share_type' attribute to messages will allow for dynamic share messages to be processed in a single lane to guarantee messages are processed in order. 

Legacy table compare for ServiceNow to database/ServiceNow is now part of a separate update set. 

Bulk and dynamic share forms are enhanced for better user experience. 

Receipts for Data Guarantee now only requires one option to be enabled.

Bug Fixes

Modifying the encoded query on the business rule the bulk share creates on the shared table will proceed to share all records.

Fixed to display proper error message (and not TypeError null) when doing Get Queue Status on a queue where the URL is invalid.

Upon creation of a scheduled bulk share, a message will pop up stating the there is another scheduled bulk share running at the given time even though no other scheduled bulk share is running at the same time. This message will no longer appear if there are no other scheduled bulk share running at the same time.

If a table map is set in your dynamics share, records with an attachment or message size greater than 5 MB will not be shared out.

Showing record encryption key in a default subscribed queue will no longer display an undefined value. 

Creating a dynamic share will no longer set unnecessary text in the Notes field.

Purge Queue will no longer reset the encryption key in a default subscribe queue.  

Emojis will no longer be removed in the outbound messages when at lease one custom schema feature is used (tablename, column_name, _dv suffix). 

Creating a group share will no longer exclude tables that was added on top of the template selected. 

Fixed inconsistent placement of name field upon creating a new queue. 

Updated description for concurrent scheduled bulk shares in properties page. 

Fixed previous, i.e. previous.short_description, in before/after share script returning NullPointer Exception and not previous GlideRecord object's properties. 

Fixed current, i.e. current.operation(), in before/after share script returning NullPointer Exception and not previous GlideRecord object's properties. 

When the Include referenced field records option is enabled, a schema message will now be sent out for referenced tables, i.e. sys_user.schema

Improved error notifications to provide better user experience and removed those that are no longer needed.

More Info documentation link updated for built-in template group shares

Bulk shares with conditional shares and encryption method set to AES-256 will now use custom encryption keys from the selected shared queue.

Embedded Table Maps will no longer have a null value for empty values. 

Admin role will no longer be required to run actions for confirmation features, i.e. Finish Install.

Scheduled sync up with dynamic share using Flow will now honor conditions applied in the share. 

The number of records synced last interval will now only reflect records that are shared. 

The name field in shared and subscribed queues will no longer accept invalid queue name, i.e. psp.out..servicenow.sample. 

Records will no longer be created in the u_psp_bulk_share_job when the records are not being used.

UI actions exclusive to a related list will not appear in other related lists that reference the same table.

When sharing the ast_contract table, decimal values in the amount column will no longer be removed in the subscribing instance. 

Error logs related to queues will now state the queue name related to the issue. 

Business Rule When after is now removed for delete triggers.

Only online nodes that Perspectium jobs can be scheduled to run on will be selectable in the Nodes to run on option and used to determine free resources when running scheduled bulk shares.

Enabling Monitor and Track History for multiple queues will now successfully get each queue's history.

Removed Features

Ready to Run 

Removed legacy table compare from Group Share.

Open in High Charts Cloud link has been removed in the Queue History graph.