Release Date: March 11, 2021New 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 |
---|
| 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 |
---|
|
|
Show If |
---|
| Optimize throughput and ensure message ordering with Key Set Processing for DataSync Agent. Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key |
---|
|
|
| DEV | 11688When a table already exists upon an integration, the new reference fields will now have length of 32Use <batch_flush_interval> for the number of seconds that will trigger a batch SQL statement execution with batch processing. Show If |
---|
| 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 fileperformance_tag> to stop the Agent from reporting performance metrics (statsx) to the Integration Mesh. Show If |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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.
|
Show If |
---|
| 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 |
---|
|
|
Enhancements |
---|
Improved SQL server performance. | Added PostgresSQL as a DataSync Type option in the Agent installer 14709Using <update_on_bulk/> will now skip duplicates in the DataSync Agent based on the message action. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-1356212079 |
---|
|
|
| | agent DataSync Agent Installer 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) status.use HTTPS as a protocol by default in <message_connection>. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV- |
---|
|
|
| 9580 | | now supports Java 14.will automatically have parameter values to default to uppercase characters after installation. Show If |
---|
| 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. | Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step. Show If |
---|
| 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 |
---|
| 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
| Match text field lengths in your DataSync Agent with <match_field_lengths/>. Show If |
---|
| 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 |
---|
| 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 |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-1495811688 |
---|
|
|
| Sharing records from a database to the Integration Mesh will now be consumed without errors. When a table already exists upon an integration, the new reference fields will now have length of 32. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV- |
---|
|
|
| 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>. | <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 |
---|
|
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 |
---|
| <close_file_interval> is added to set the amount of time the Agent will wait for tmp files to be modified. | Error when inserting/updated a record into a SAP HANA table that has 2 billion+ rows because of metadata query. Show If |
---|
|
Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV- |
---|
|
|
| 9192The attribute, use_basic_consume, in the agent.xml will reflect on the protocol given upon the configuration in DataSync Agent installer | Enhanced error recovery when using temporal and the table does not exist in the database. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV- |
---|
|
|
| 11395Emojis 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) | AWS S3 Subscriber Agent now supports sending receipts back to ServiceNow. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV- |
---|
|
|
| 11990 | 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 |
---|
| 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
| AWS S3 Subscriber Agent logging extended for different levels. Show If |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| DataSync Agent now supports Java 14. | Removed the following DataSync Type options in the DataSync Agent Installer that are no longer being used: Rabbit MQ and Other. Show If |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| 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 |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-10787 |
---|
|
|
|
|