DataSync for ServiceNow Application 

Gold Patch 1 Hotfix 8 Release (TBD)

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. 

Gold Hotfix 15 Release (April 12, 2021)

Bug Fixes

  • Resending outbound messages for receipts will no longer have an incorrect action.

Gold Patch 1 Hotfix 7 Release (March 26, 2021)

Bug Fixes

  • Using share schema with table maps will now share out the schema of the table map, rather than the original table schema.

Gold Patch 1 Hotfix 6 Release (February 26, 2021)

Enhancements

  • Fixed an issue with using scripting custom code on a Table Map Field.

  • Fixed an issue with Import set subscribing not receiving all columns from inbound message.

Gold Patch 1 Hotfix 5 Release (January 20, 2021)

Bug Fixes

  • Fixed an issue where Common Document records are not inserted to the subscribe instance when sys_class_name is passed in from the source instance.

  • Fixed an issue with decimals being dropped from amount columns for InstanceSync.


Gold Patch 1 Hotfix 2.2 Release (January 8, 2021)

Enhancements

  • Added the ability to bulk share archived child records when sharing from an archive parent table.

Gold Patch 1 Hotfix 4 Release (December 17, 2020)

Bug Fixes 

  • Fixed an issue with scheduled sync record count to be only the number of records shared.
  • Scheduled sync up with dynamic share using flow will now honor conditions.

Gold Patch 1 Hotfix 2.1 Release (December 14, 2020)

Bug Fixes 

  • Re-shared records will now use encryption key found in queue if exists.

Gold Hotfix 14 Release (March 19, 2021)

Bug Fixes 

  • Fixed an issue with outbound messages not correctly decrypting in ServiceNow.

  • Fixed an issue with Files not correctly sending out from Salesforce to ServiceNow.

Gold Hotfix 13 Release (February 17, 2021)

Bug Fixes 

  • Fixed an issue with Import set subscribing not receiving all columns from inbound message.

Gold Hotfix 12 Release (December 10, 2020)

Bug Fixes 

  • Fixed an issue with scheduled sync record count to be only the number of records shared.

Gold Hotfix 11 Release (December 4, 2020)

Bug Fixes 

Gold Hotfix 10 Release (October 9, 2020)

Enhancements

Bug Fixes 

  • Setting an empty topic and type value in a table map will no longer set the topic and type fields as "undefined" in the outbound message when using conditional share with table map.

  • Dynamic / bulk shares with conditional shares and encryption method set to AES-256 will now use custom encryption keys from shared / subscribe queue.

Gold Patch 1 Hotfix 3 Release (September 28, 2020)

Bug Fixes 

  • Fixed an issue with the decryption of inbound messages from Agent sharer with encrypted_multibyte.

Gold Hotfix 9 Release (September 18, 2020)

Bug Fixes 

  • Import set subscribing will now pull all columns from inbound message

Gold Hotfix 8 Release (September 9, 2020)

Bug Fixes 

  • Dynamic shares with conditional shares using AES-256 will no longer stop the creation of outbound messages even with the right encryption key length. 

Gold Patch 1 Hotfix 1 Release (August 23, 2020)

Bug Fixes 

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

  • Using table maps with bulk share can now share the sys_audit table. 

  • Fixed an issue where Common Document records are not inserted to the subscribe instance when sys_class_name is passed in from the source instance 

Gold Patch 1 Release (July 17, 2020)

New Features

  • Select which related records you want to share using bulk share's share related list feature.

Enhancements

  • Upon cloning bulk shares, new clones will now honor only the latest time stamp and no longer append timestamps continuously.

  • Added warning messages to alert users that the use of custom tables and columns can impact previous shares when creating a custom schema.

  • Added the number of messages contained in the payload to the header for messages that are being sent from ServiceNow to the Perspectium Integration Mesh. 

  • Creating MultiOutput Jobs will now automatically delete jobs that were previously created by the Create MultiOutput Jobs tool. 

  • Additional information is available when monitoring your queue and tracking the history. With Track History, you can start viewing the metrics of your queue.

  • Alert messages are added to guarantee that both properties, Enable sending receipt functionality for data guarantee and Enable subscribing receipt functionality for data guarantee, are activated for Data Guarantee

  • Heartbeats sent by ServiceNow instances will now have attributes with the number of consumers on each active queue in the instance (i.e. queuename_consumers=1). If a queue has some sort of error and can't be access, that queue won't show in the heartbeat.

Bug Fixes

  • Issue fixed with bulk share state staying as "Running" when Data Obfuscation is enabled.

  • Reduced the amount of global property query to help improve performance for subscribe records in large bulk.

  • In Group Share, clicking Create a new group share like this one no longer leads you to the previous page visited.

Known Issues

  • Import set subscribing does not work with .insert .update messages and conflicts with SIAM approach for import sets

Gold Hotfix 7 Release (August 18, 2020)

Bug Fixes

  • Fixed an issue where Common Document records are not inserted to the subscribe instance when sys_class_name is passed in from the source instance 

Gold Hotfix 6 Release (July 17, 2020)

Bug Fixes

  • Fixed an issue where values were not saving into the import set table correctly when subscribe configuration is using a field prefix.

Gold Hotfix 5 Release (July 15, 2020)

Bug Fixes

  • Fixed an issue where record were not saving into the import set table correctly.

Gold Hotfix 4 Release (June 22, 2020)

Bug Fixes

  • Fixed an issue of primary key violations occurring on bulk actions on subscribe in ServiceNow.

  • Added better handling of Observer messages for invalid queries.

Gold Hotfix 3 Release (May 15, 2020)

Bug Fixes

  • Fixed an issue where certain database view tables are not processing correct out of ServiceNow
  • Fixed an issue where database view tables returns a syntax error when previewed

Gold Hotfix 2 Release (April 27, 2020)

Bug Fixes

  • Added the ability to for Jira meshlet to select different Jira projects

Gold Hotfix 1 Release (March 19, 2020)

Bug Fixes

  • Fixed an issue where querying business rules were preventing bulk share from sharing the expected number of records.

Gold Release (March 3, 2020)

New Features

  • Manually reshare records from your ServiceNow instance from a period of three days or less for situations where all records were not received. 

  • Specify how many bulk shares can run simultaneously in a scheduled bulk shareThis is useful if you don't want all the bulk shares listed in this scheduled bulk share to try and run immediately based on the number of scheduled workers you have available. 

  • Upon creating shared queues or subscribed queues, you can choose a queue type that will automatically prepend a queue prefix to your queue name for easier creation and setup. 

  • Enable debug logging for a specified time frame in the Perspectium properties to obtain additional informations when using the Perspectium application. 

  • Fanout queues are used to broadcast messages across multiple queues. When creating a shared queue, you now have the option to send to a fanout queue. Monitoring receipts for fanout queues is also available. 

  • When include audit log is checked in dynamic share or bulk share, you have an option to choose which audit log records will be shared by checking Filter audit fields

  • Monitor tables such as inbound messages, outbound messages, outbound attachments, and outbound audits in your ServiceNow instance by setting up email notifications using Table Monitoring

  • If you are sending a high volume of messages to a single queue or spreading your messages across a high volume of queues, you can now use Multiple MultiOutput Jobs

  • To improve data alignment, you now have an option to use these new features:
    • Post Immediately: In a sharing instance, dynamic share messages will be posted as soon as the outbound message is created instead of waiting for the MultiOutput processor scheduled job to send all the outbound messages in bulk. 
    • Skip delayed updates: In a subscribing instance, inbound messages will be skipped if the message has a later updated time than the target record.

Enhancements

  • Improved dynamic share's scheduled sync up feature with notifying users when to create indexed columns for the selected table in dynamic share. For more information on indexing columns, see Create a table index.

  • Receipt messages are now an opt-in feature and can be enabled in the u_psp_properties table by modifying the value of the com.perspectium.enable_receipts property.

  • Database views tables is now available for group sharing out a combination of dynamic and bulk shares from one ServiceNow instance to another.

  • When a table map is set in a dynamic share, you will now be notified to use "before" in the business rule when field to ensure Service Gateway integration. 

  • Catalog Tasks PSP Template is available as a template selection for group share. This template includes data related to service catalog requests that requires approval.

  • Optimized performance for querying outbound records by the shared queue.

Bug Fixes

  • View History in shared and subscribed queues is now compatible with enabled monitor and track history.

  • Preview output in table map now correctly process HTML fields with single lines.

Removed Features

  • In dynamic share, you are no longer restricted from using Include Journal Fields when Business Rule When is set to "before". Instead, a warning message is displayed to notify users that Include Journal Field should not be checked when sharing to another ServiceNow instance or SIAM integration.

  • Removed Perspectium ETS scheduled jobs (Perspectium ETS feature is no longer available).

Known Issues

  • Auxillary records (audit log, journal fields, etc.) are not re-sending when Resend Message is clicked on the record's receipt. 

DataSync Agent

Gold 5.0.9 Release (November 14, 2022)

Enhancements


Gold 5.0.8 Release (September 2, 2021)

Enhancements

Bug Fixes

  • Dynamic insert datetime columns date/time value for a record will remain the value as on insert when the Agent receives an update of the same record.

  • Sharer Agent will no longer share old messages each time the queue should be flushed. 

Gold 5.0.7 Release (May 10, 2021)

Bug Fixes

  • Agent will now retry messages if prepared statements timeout.

Gold 5.0.6 Release (April 26, 2021)

Bug Fixes

  • DataSync agent will no longer recognize certain script includes as schema messages.

Gold 5.5.0 Release (April 7th, 2021)

Bug Fixes

  • When retrying a delete in the DataSync Agent, the Agent will no longer retry as an upsert.

Gold 5.0.4 Release (March 26, 2021)

Enhancements

  • Create Report in DataSync Agent will now create a folder of log files that are 7 days old. Any log files older than 7 days will be deleted. 

  • Reference fields will be created with a length of 32 to match ServiceNow.

  •  Temporal will check field values if the updated time is the same from the previous share with <skip_duplicates check_all_fields=”true”/.

  • Enhanced error recovery when using temporal and the table does not exist in the database.

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

Bug Fixes

  • Emojis will no longer be removed in incoming messages to the DataSync Agent when at lease one custom schema feature is used (table name, column name or _dv suffix). 

  • After adding a string field with a default value in a ServiceNow table, executing a bulk share will no longer generate a timestamp error. 

  • After deleting a field from a ServiceNow table, the old value of that field will no longer be inserted into the database. 

Gold 5.0.3.3 Release (January 8th, 2021)

New Features

  • Customize your temporal database table's archive date and time stamp in the psp_valid_to column with <archive_datetime/>

Enhancements

  • Added the ability to bulk share archived child records when sharing from an archive parent table.

Gold 5.0.3.2 Release (December 14, 2020)

Enhancements

  • Column lengths now match ServiceNow field lengths upon ServiceNow schema change.

Bug Fixes

  • Fixed an issue where the number or cursors used constantly goes up when compare messages are processed.

Gold 5.0.3.1 Release (November 11, 2020)

New Features

  • <use_instance_credentials/> is now available to use instead of access keys in AWS S3 Subscriber Agent to use IAM roles when uploading to the S3 buckets.

Enhancements

  • AWS S3 Subscriber Agent now supports sending receipts back to ServiceNow. 

  • The <region> directive in the AWS S3 Subscriber Agent is now optional and no longer required. 

  • AWS S3 Subscriber Agent logging extended for different levels. 

  • Using <skip_duplicates update_on_bulk="true"/> will now skip duplicates in the DataSync Agent based on the message action.

Gold 5.0.2 Release (September 16, 2020)

New Features

Enhancements

Gold 5.0.1 Release (June 15, 2020)

Enhancements

  • In the DataSync Agent, running too many threads can slow down the process. To avoid this, a warning will appear when more than 64 threads are created. 

Gold 5.0.0 Release (April 30, 2020)

New Features

Enhancements

  • Configure the number of times the DataSync agent will retry after a SQL error with <sql_retries> in the agent.xml.

  • Improved better error handling for DataSync agent when messages have empty values.

  • The agent.xml configuration file's <database_parms> directive has been standardize.

  • Added machine's hostname, internal IP address, Java version and OS version to DataSync Agent's heartbeat.

  • Updated DataSync Agent to utilize 3.9.0 Snowflake JDBC driver.

  • Configure your DataSync Agent with sorting your database columns in alphabetical order with <column_sort> in the agent.xml. 

  • Polling interval is now limited to 5 seconds or greater. If the polling interval is set to less than 5 seconds, it will default to 5 seconds.

  • To ensure multibyte or foreign characters are saved properly for string column types, the DataSync Agent creates column types that can store unicode string data. Changing the data type to your configuration is now available.

  • You can now add the tag <skip_duplicates/> to the agent.xml to skip adding temporal rows for duplicate records. 

  • S3 file subscriber now allows multiple layers of folders following the bucket name. See the <s3_bucket> directive for more information. 

  • Default <skip_table_stats/> when installing SQL Agent through the installer.

Bug Fixes

  • Tasks pointing to the same database and server will allocate and start only one table stats collector to avoid placing excessive load on the agent and the database.

  • The DataSync Agent's database directive, <database_parms>, now includes another default value (autoReconnect=true) that will save records in the database even when there is no activity in the instance. 

  • Fixed an issue where the Agent only ran table stats once instead of intervals

Known Issues

  • <batch_insert> and <batch_update> commands do not work properly when reading messages from a queue that has records from different tables. To use these commands, the queue should only have records from one table.

DataSync for SnowFlake

5.0.11.4 Release (September 30, 2021)

Bug Fixes

  • Fix 400 error status when retrieving schema from ServiceNow with subsequent calls.

5.0.11.3 Release (April 15, 2021)

Enhancements

  • Specifying the maximum string size for the entire collection is available through the maxStringSize configuration.

  • Any meshlet log files older than 14 days will be rotated.

  • Allow user to set connection properties (username, password and role) through connection URL.

  • Default to TIMEZONE session parameter to connect to Snowflake in order to save all timestamps in UTC.

5.0.11.2 Release (January 26, 2021)

Enhancements

  • Meshlet will continue to retry and recover the AMQP/S connection between the meshlet and the Perspectium Integration Mesh is lost.

Bug Fixes

  • Fixed an issue where sys_audit records are not being consumed in configured batch values.

5.0.11.1 Release (September 16, 2020)

Enhancements

  • Added the ability to share updates and deletes from ServiceNow.


5.0.11 Release (July 24, 2020)

New Features

  • Added the to ability to enable and support data guarantee.

5.0.4.1 Release (June 3, 2020)

New Features

  • DataSync for Snowflake, a single-direction (ServiceNow to Snowflake) integration that leverages bulk shares for a one time migration for the collection of ServiceNow data into a Snowflake data warehouse.

DataSync for Splunk

5.0.5.2 Release (June 26, 2020)

Bug Fixes

  • Fixed an issue where the password value is not encrypting correctly for Windows environment.

5.0.5.1 Release (June 5, 2020)

Enhancements

  • Splunk Meshlets will now process referenced field values such as assigned_to, company, etc. 

5.0.5 Release (May 15, 2020)

Enhancements

  • Include all the data for a record's fields in the event field when configuring your Splunk meshlet by using saveInEvent

  • Configure your Splunk meshlet to dynamically set table name by adding $table value in sourceType

Gold Release (April 1, 2020)

New Features

  • Modify meshlet logs by setting the rolling policy in the logback file Perspectium Support will provide to you.  

DataSync for ServiceNow (Meshlet) 

Gold 5.0.11 Release (TBD)

Bug Fixes

  • Typo fix in Meshlet message when retrieving ServiceNow schema. 

DataSync Express

5.0.2 Release (September 1, 2020)

Enhancements

  • Multiple bulk shares can now be executed at the same time.

  • Included a new set up page, adding more information on DataSync Express

  • DataSync Express will no longer install a global script to use the application. 

  • Removed Portal/MBS password from the sys_properties table.

Known Issues

  • Troubleshooting report may not run properly if both DataSync Express and DataSync Free scoped apps are installed on the same instance.

5.0.0 Release (April 1, 2020)

New Features

DataSync Free

5.0.3 Release (TBD)

Enhancements

  • Be able to modify your bulk share settings after bulk share is executed using reset bulk share.

  • Removed Portal/MBS password from the sys_properties table.

Removed Features

  • Bulk share fields are removed e.g., Include Embedded Images/Videos, View Name, Target Queue, Notes, and Team.

  • Shared Queue, Start All Shares and Stop All Shares modules are removed. 

Known Issues

  • Troubleshooting report may not run properly if both DataSync Express and DataSync Free scoped apps are installed on the same instance.

5.0.1 Release (May 26, 2020)

New Features

Can't find the feature you're looking for?  

See release notes for earlier releases.


Contents