Page History

Versions Compared

Old Version 102

changes.mady.by.user user-1bc08

Saved on Aug 31, 2021

compared with

New Version Current

changes.mady.by.user Paul Nguyen

Saved on Jan 14, 2023

Key

This line was added.
This line was removed.
Formatting was changed.

Version

HTML
<style> .version { height: 25px; width: 200px; border-radius: 5px; border: 1px solid #ddd; } </style> <select class="version" id="version" onchange="showContent()"> <option value="6.1.0">6.1.0</option> <option value="6.0.814" selected>6.0.<15</option> <option value="6.0.714">6.0.7<14</option> <option value="6.0.613">6.0.6<13</option> <option value="6.0.512">6.0.5<12</option> <option value="6.0.411">6.0.4<11</option> <option value="6.0.310">6.0.3<10</option> <option value="6.0.29">6.0.2<9</option> <option value="6.0.18">6.0.1<8</option> <option value="6.0.07">6.0.0<7</option> </select> <script> function showContent() { var<option dropdown = document.getElementById("version"); var tabs = document.getElementsByClassName("rwui_tab_content"); for (var i = 0; i < tabs.length; i++) { if (tabs[i].getAttribute("data-name") == dropdown.value) { tabs[i].style.display = ""; } else { tabs[i].style.display = "none"; } } } </script>
<script>value="6.0.6">6.0.6</option> <option value="6.0.5">6.0.5</option> <option value="6.0.4">6.0.4</option> <option value="6.0.3">6.0.3</option> <option value="6.0.2">6.0.2</option> <option value="6.0.1">6.0.1</option> <option value="6.0.0">6.0.0</option> </select> <script> function showContent() { var dropdown = document.getElementById("version"); var tabs = document.getElementsByClassName("rwui_tab_content"); for (var i = 0; i < tabs.length; i++) { if (tabs[i].getAttribute("data-name") == "6.0.7"dropdown.value) { tabs[i].style.display = ""; } else { tabs[i].style.display = "none"; } } } </script>

HTML

<style> 
.version {
	height: 25px;
    width: 200px;
    border-radius: 5px;
    border: 1px solid #ddd;
}
</style>
<select class="version" id="version" onchange="showContent()">
	<option value="6.1.0">6.1.0</option>
	<option value="6.0.814" selected>6.0.<15</option>
	    <option value="6.0.714">6.0.7<14</option>
	<option value="6.0.613">6.0.6<13</option>   
	<option value="6.0.512">6.0.5<12</option>
	<option value="6.0.411">6.0.4<11</option>   
	<option value="6.0.310">6.0.3<10</option>
 	<option value="6.0.29">6.0.2<9</option>
	<option value="6.0.18">6.0.1<8</option>
    	<option value="6.0.07">6.0.0<7</option>
</select>
<script> 
function showContent() {
	var<option dropdown = document.getElementById("version"); 
	var tabs = document.getElementsByClassName("rwui_tab_content");
	for (var i = 0; i < tabs.length; i++) {
		if (tabs[i].getAttribute("data-name") == dropdown.value) {
			tabs[i].style.display = "";
		}
		else {
			tabs[i].style.display = "none";
		}
	}
}
</script>

HTML

<script>value="6.0.6">6.0.6</option>
	<option value="6.0.5">6.0.5</option>
	<option value="6.0.4">6.0.4</option>
	<option value="6.0.3">6.0.3</option>
	<option value="6.0.2">6.0.2</option>
	<option value="6.0.1">6.0.1</option>
    <option value="6.0.0">6.0.0</option>
</select>
<script> 
function showContent() {
	var dropdown = document.getElementById("version"); 
	var tabs = document.getElementsByClassName("rwui_tab_content");
	for (var i = 0; i < tabs.length; i++) {
		if (tabs[i].getAttribute("data-name") == "6.0.7"dropdown.value) {
			tabs[i].style.display = "";
		}
		else {
			tabs[i].style.display = "none";
		}
	}
}
</script>

API plugins will not be disabled on failure and will retry until services are restored

UI Tab

title	6.1.0

Release Date: July 19, 2021TBD

New Features

Added File DataSync option for DataSync Type in the Agent installer to support manual configuration for file subscribing.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-12695

Set a dynamic file name using <file_prefix>$table_$d{yyyyMMdd}_$i</file_prefix> upon setting up DataSync Agent to share to AWS S312694Validate Configuration will now validate the encryption keys set for the DataSync Agent

Enhancements

Enhanced handling on display value fields for glide_list, glide_duration and choice fields in the Table Schema (compatible with Core 6.1.0)Additional logging statements added to notify users that the truncate command executed successfully in the Agent.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1145919215

Enhanced handling on display value fields for glide_list, glide_duration and choice fields in the Table Schema (compatible with Core 6.1.0)Added logs to alert user when record payloads have fewer columns than database table.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-16783

11459

Added logs to alert user when record payloads have fewer columns than database table.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

16783

Set a dynamic file name using <file_prefix>$table_$d{yyyyMMdd}_$i</file_prefix> upon setting up DataSync Agent to share to AWS S3

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-12694

Validate Configuration will now validate the encryption keys set for the DataSync Agent

17267

Use the update_column_only tag in the IO Datetime Plugin for DataSync Agent to update the psp_per_update_dt column only when records are updated.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-15472

Bug Fixes

17267

Improved logging details for SQLRecoverableException errors

Use the update_column_only tag in the IO Datetime Plugin for DataSync Agent to update the psp_per_update_dt column only when records are updated

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-15262

AgentConfigValidator Error in logging for DataSync Agent will no longer appear.

15472

Release Date: TBD

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

Enhancements

Bug Fixes

Improved logging details for SQLRecoverableException errors.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-18220

CSV file

15262

AgentConfigValidator Error in logging for DataSync Agent will no longer appear.

is no longer missing a header for CSV File Subscriber.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1836618220

CSV file is no longer missing a header for CSV File Subscriber.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-18366

Sharing all records to one file with the agent will no longer need the Sharing all records to one file with the agent will no longer need the <separate_files> tag.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-18387

Agent will now retry messages if statements timeout.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-19460

UI Tab

title	6.0.8

Fixed Perspectium Support link in Agent installer for Manual Configuration.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

23069

17760

UI Tab

title	6.0.715

Release Date:

August 26, 2021

January 13, 2022

Bug Fixes
Fix NullPointerException that may occur when Agent is connected to Oracle for a long duration.

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

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

key,

Enhancements

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

Show If

special	@authenticated

Jira

server	JIRA
columnscolumnIds	keyissuekey,summary,typeissuetype,created,updated,dueduedate,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-22615

Show If

special	@authenticated

Jira

server

JIRA

columns

key
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d

DEV-22616

UI Tab

title	6.0.6

	INC-5604

Upgrade to commons-text-1.10.jar to fix CVE-2022-42889.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype

Release Date: August 13, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

You can now specify how many times an attachment will be tried to be built until it's skipped and removed from the sys_attachment table with the <attachment_retries> tag.

key,summary,typeduee15725ca-3b2bDEV22436

Enhancements

Show If

special	@authenticated

Jira

server

JIRA

columns

,created,updated,

duedate,assignee,reporter,priority,status,resolution

serverId

key
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d

INC-

5605

UI Tab

title	6.0.514

Release Date:

August 2, 2021 NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

November 14, 2022

Azure KeyVault is now accessible with custom wrapper API.

key,Dynamic insert datetime columns will now have the same date/time that the record is first received by the Agent on insert and remain the same when the Agent receives an update of the same record

Enhancements

Enhanced error handling for Voltage Encryption failures.

Support for Java 18

Show If

special	@authenticated

Jira

server	JIRA
columnscolumnIds	keyissuekey,summary,typeissuetype,created,updated,dueduedate,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-22100

Show If

special	@authenticated

Jira

server

JIRA

columns

key
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d

DEV-22100

Bug Fixes

QA-1209

Journal field entries will now be encrypted with the Voltage plugin in DataSync Agent.

UI Tab

title	6.0.13

Release Date: December 15, 2021

Enhancements

Users can now configure how many messages are in a batch when the messages get sent to the Integration Mesh (MBS). See Troubleshooting synchronized delete in table compare.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

21914

UI Tab

title	6.0.4

25821

Bug Fixes
Records will no longer get skipped in SQL Server after adding a new column in ServiceNow.

Release Date: July 26, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

Enhancements

Show If

special	@authenticated

Jira

server	JIRA

columns

columnIds

key

issuekey,summary,

type

issuetype,created,updated,

due

duedate,assignee,reporter,priority,status,resolution

serverIde15725ca-3b2b-

columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

21883

25759

UI Tab

title	6.0.312

Release Date:

July 22

October 29, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

Bug Fixes

Agent will no longer get stuck in a loop after receiving a truncate message.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype

New Features

You can now choose which SQL Server schema to use in the DataSync Agent with the <database_schema> directive.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,dueduedate,assignee,reporter,priority,status,resolution	serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-18305

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-21666-25094

UI Tab

title	6.0.11

Release Date: October 15, 2021

Bug Fixes

Re-queued delete messages will no longer throw decryption error

Enhancements

When using Voltage for encrypting your data, the host_name parameter within the plugin directive will be the name of the computer or machine that the agent is running on

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-2164224192

UI Tab

title	6.0.210

Release Date: July 19, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

September 20, 2021

Bug Fixes

Enhance performance for index checking in the agent.

Enhancements

For decrypting Edge Encrypted content, you can now access Azure KeyVault through a proxy.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-21564-23842

UI Tab

title	6.0.9

Release Date: September 8, 2021

Enable Voltage encryption with the com.perspectium.replicator.sql.plugin.SQLSubscriberVoltageEncrypterPlugin plugin.

Bug Fixes

IODateTimePlugin inserts will no longer have a null insert time.

Show If

special	@authenticated

Jira

server	JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-23386

UI Tab

title	6.0.8

Release Date: September 1, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

21456

With Voltage encryption, you can specify trace ID as a parameter to track your API traffic.

Enhancements

Show If

special	@authenticated

API plugins will not be disabled on failure and will retry until services are restored.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-23069

UI Tab

title	6.0.7

Release Date: August 26, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

21432

Attachments can now be encrypted with Voltage.

21480

Enhancements

Show If

special	@authenticated

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

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

UI Tab

title	6.0.1

22615

Release Date: July 6, 2021

Edge Decryption plugin is now available for DataSync Agent to handle Edge Encrypted values in your ServiceNow instance.

18941jira

New Features

Show If

special	@authenticated

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

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

22616

UI Tab

title	6.0.6

Release Date: August 13, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

Attachments can now be processed by the DataSync Agent with SysAttachmentHandler18917

Enhancements

You can now specify how many times an attachment will be tried to be built until it's skipped and removed from the sys_attachment table with the <attachment_retries> tag

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-18965

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

22436

UI Tab

title	6.0.05

Release Date:

March 11, 2021

August 2, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

Enhancements
Enhanced error handling for Voltage Encryption failures

Use <custom_primary_key/> to create an auto-incrementing column and set the column as the primary key

Optimize throughput and ensure message ordering with Key Set Processing for DataSync Agent.

New Features

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-22100

Jira

Azure KeyVault is now accessible with custom wrapper API.

8399

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-22100

Use <batch_flush_interval> for the number of seconds that will trigger a batch SQL statement execution with batch processing

Bug Fixes
Dynamic insert datetime columns will now have the same date/time that the record is first received by the Agent on insert and remain the same when the Agent receives an update of the same record	CE-168

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-972021914

UI Tab

title	6.0.4

Release Date: July 26, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

Enhancements

Journal field entries will now be encrypted with the Voltage plugin in DataSync AgentUse <skip_performance_tag> to stop the Agent from reporting performance metrics (statsx) to the Integration Mesh.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1062121883

UI Tab

title	6.0.3

Release Date: July 22, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

Enable truncating table in the database by the DataSync Agent using Truncate Before Share9448<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.14515Customize your temporal database table's archive date and time stamp in the psp_valid_to column with <archive_datetime/>

New Features

You can now choose which SQL Server schema to use in the DataSync Agent with the <database_schema> directive

Show If

special	@authenticated

Jira

server

JIRA

columns

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

18305

Jira

columns
server	JIRA

key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

21666

13182

Enhancements

When using Voltage for encrypting your data, the host_name parameter within the plugin directive will be the name of the computer or machine that the agent is running on.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

21642

UI Tab

title	6.0.2

Release Date: July 19, 2021

NOTE: This release is a specific release for Voltage encryption support. Contact Perspectium Support for more information.

Specify the character set for database encoding and truncate the data based on this character set by using <database_truncate_encoding>.

DEV-9446

Enhancements

For decrypting Edge Encrypted content, you can now access Azure KeyVault through a proxy.

Show If

special	@authenticated

Jira

server

JIRA

columns

key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution

serverId

e15725ca-3b2b-32f6-914c-89477a90901d

key

Show If

special	@authenticated

DataSync Agent can now run as a container in Azure.

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

20851

The DataSync Agent Installer will now use HTTPS as a protocol by default in <message_connection>10785Snowflake DataSync Agent will automatically have parameter values to default to uppercase characters after installation.

21564

Enable Voltage encryption with the com.perspectium.replicator.sql.plugin.SQLSubscriberVoltageEncrypterPlugin plugin.

Enhancements

Improved SQL server performance.

Added PostgresSQL as a DataSync Type option in the Agent installer.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-12079

21456

With Voltage encryption, you can specify trace ID as a parameter to track your API traffic.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

21432

Attachments can now be encrypted with Voltage.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-21480

UI Tab

title	6.0.1

Release Date: July 6, 2021

If the agent.xml file is invalid (i.e. bad file format, missing field characters, etc), an error message will now display on the log with a description of the error.

key

New Features

Edge Decryption plugin is now available for DataSync Agent to handle Edge Encrypted values in your ServiceNow instance

10932Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-10966

18941

Jira

server	JIRA
columns	key

Show If

special	@authenticated

Jira

server

JIRA

columns

,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-18965

Attachments can now be processed by the

9588Match text field lengths in your

DataSync Agent with

<match_field_lengths/>.

SysAttachmentHandler.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-18917

DEV11688When a table already exists upon an integration, the new reference fields will now have length of 3211738<enableerror_log/> will now keep track of the number of invalid records and save the error count in the generated audit file

ui-tab

title	6.0.0

Release Date: March 11, 2021

New Features

Use <custom_primary_key/> to create an auto-incrementing column and set the column as the primary key.

11753

Check the fields values if the updated time is the same from the previous share in your DataSync Agent with <skip_duplicates check_all_fields=”true”/> .

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-11615

Using <column_sort>alpha</column_sort> in your DataSync Agent will now sort new fields.

Show If

special	@authenticated

8399

Show If

special	@authenticated

Optimize throughput and ensure message ordering with Key Set Processing for DataSync Agent.

Jira

key
server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d

CE-

168

Use <batch_flush_interval> for the number of seconds that will trigger a batch SQL statement execution with batch processing.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

9720

Use <skip_

performance_tag> to stop the Agent from reporting performance metrics (statsx) to the Integration Mesh.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-10621

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

12003

<close_file_interval> is added to set the amount of time the Agent will wait for tmp files to be modified.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-118619448

<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 bucketsEnhanced error recovery when using temporal and the table does not exist in the database.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1205814515

Customize your temporal database table's archive date and time stamp in the psp_valid_to column with <archive_datetime/>AWS S3 Subscriber Agent now supports sending receipts back to ServiceNow.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1470913182

Specify the character set for database encoding and truncate the data based on this character set by using <database_truncate_encoding>The <region> directive in the AWS S3 Subscriber Agent is now optional and no longer required.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-14709

AWS S3 Subscriber Agent logging extended for different levels.

9446

Show If

special	@authenticated

DataSync Agent can now run as a container in Azure.

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-20851

agent log a warning message that a queue will be created when messages are shared if the agent gets a 404 (queue not found) status.9580 now supports Java 14.9593DataSync Agent now supports Java 15.Sharing records from a database to the Integration Mesh will now be consumed without errors. 16147Set your MySQL database with utf8mb4 character set and collation to accept multibyte characters in the agent.xml with <database_table_character_set> and <database_table_collation>. 13006Error when inserting/updated a record into a SAP HANA table that has 2 billion+ rows because of metadata query.9192The attribute, use_basic_consume, in the agent.xml will reflect on the protocol given upon the configuration in DataSync Agent installer11395Emojis will no longer be removed in incoming messages to the DataSync Agent when at lease one custom schema feature is used (tablename, column_name, _dv suffix)11990Removed the following DataSync Type options in the DataSync Agent Installer that are no longer being used: Rabbit MQ and Other.

Enhancements

Improved SQL server performance.

Added PostgresSQL as a DataSync Type option in the Agent installer

14709

Using <update_on_bulk/> will now skip duplicates in the DataSync Agent based on the message action.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1356212079

The

DataSync Agent Installer will now

use HTTPS as a protocol by default in <message_connection>.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

10785

Snowflake DataSync Agent

will automatically have parameter values to default to uppercase characters after installation.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

10932

Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-10966

If the agent.xml file is invalid (i.e. bad file format, missing field characters, etc), an error message will now display on the log with a description of the error.

11071The DataSync Agent Installer will now allow you to enter FedRAMP URLs for your ServiceNow instance information.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-12295

The action of processing delete messages will not alter the database tables

9588

Match text field lengths in your DataSync Agent with <match_field_lengths/>.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1331711753

Check the fields values if the updated time is the same from the previous share in your DataSync Agent with <skip_duplicates check_all_fields=”true”/> Agent re-queues delete records up to 3 times when no record in database to delete.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1316411615

Using <column_sort>alpha</column_sort> in your DataSync Agent will now sort new fields. Agents installed using the installer will create a conf/agent.xml with instances valued to 1 instead of 4 to minimize data loss.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1495811688

When a table already exists upon an integration, the new reference fields will now have length of 32.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

11738

<enable_error_log/> will now keep track of the number of invalid records and save the error count in the generated audit file.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

Bug Fixes

12003

<close_file_interval> is added to set the amount of time the Agent will wait for tmp files to be modified.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

11861

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

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

12058

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

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-

14709

The <region> directive in the AWS S3 Subscriber Agent is now optional and no longer requiredAfter deleting a field from a ServiceNow table, the old value of that field will no longer be inserted into the database.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-12018

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

14709

AWS S3 Subscriber Agent logging extended for different levels.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1224414709

Using <update_on_bulk/> will now skip duplicates in the DataSync Agent based on the message action.Table stats data will now show the correct timezone offset.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-1543913562

The agent will now log a warning message that a queue will be created when messages are shared if the agent gets a 404 (queue not found) statusUsing skip_duplicate with check_all_fields will now compare values properly.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-13534

Removed Features

9580

DataSync Agent now supports Java 14.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-9593

DataSync Agent now supports Java 15.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-11071

The DataSync Agent Installer will now allow you to enter FedRAMP URLs for your ServiceNow instance information.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-12295

The action of processing delete messages will not alter the database tables.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-13317

Agent re-queues delete records up to 3 times when no record in database to delete.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-13164

Agents installed using the installer will create a conf/agent.xml with instances valued to 1 instead of 4 to minimize data loss.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-14958

Sharing records from a database to the Integration Mesh will now be consumed without errors.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-16147

Set your MySQL database with utf8mb4 character set and collation to accept multibyte characters in the agent.xml with <database_table_character_set> and <database_table_collation>.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-13006

Bug Fixes

Error when inserting/updated a record into a SAP HANA table that has 2 billion+ rows because of metadata query.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-9192

The attribute, use_basic_consume, in the agent.xml will reflect on the protocol given upon the configuration in DataSync Agent installer.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-11395

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

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-11990

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

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-12018

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

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-12244

Table stats data will now show the correct timezone offset.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-15439

Using skip_duplicate with check_all_fields will now compare values properly.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-13534

Removed Features

Removed the following DataSync Type options in the DataSync Agent Installer that are no longer being used: Rabbit MQ and Other.

Show If

special	@authenticated

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	e15725ca-3b2b-32f6-914c-89477a90901d
key	DEV-10787

HTML

<script>
	var tabs = document.getElementsByClassName("rwui_tab_content");
	for (var i = 0; i < tabs.length; i++) {
		if (tabs[i].getAttribute("data-name") == "6.0.15") {
			tabs[i].style.display = "";
		}
		else {
			tabs[i].style.display = "none";
		}
	}
</script>

Content

Space Tools

Page History

Versions Compared

Old Version 102

New Version Current

Key

Release Date: July 6, 2021

New Features

Enhancements

Release Date: July 6, 2021

Release Date: March 11, 2021

New Features

Enhancements

Bug Fixes

Removed Features

Bug Fixes

Removed Features