Release Date: March 11, 2021New Features |
---|
Show If |
---|
| Optimize throughput and ensure message ordering with Key Set Processing for DataSync Agent. Enhancements |
---|
Improved SQL server performance. | Added PostgresSQL as a DataSync Type option in the 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-12079 |
---|
|
|
| The DataSync Agent Installer will now use HTTPS as a protocol by default in <message_connection>. |
Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key |
---|
|
|
| CE168Use <batch_flush_interval> for the number of seconds that will trigger a batch SQL statement execution with batch processing. | Snowflake DataSync Agent 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- |
---|
|
|
| 9720Use <skip_performance_tag> to | Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step | 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 | 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. 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- |
---|
|
|
| 9448<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. 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- |
---|
|
|
| 14515Customize your temporal database table's archive date and time stamp in the psp_valid_to column with <archive_datetime/>. | 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- |
---|
|
|
| 13182Enhancements | The Installer use HTTPS as a protocol by default in <message_connection>sort new fields. 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- |
---|
|
|
| 10785Snowflake DataSync Agent will automatically have parameter values to default to uppercase characters after installation. | 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 |
---|
|
|
| -89477a90901dkey | DEV-10932 | Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step-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 |
---|
|
Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV- |
---|
|
|
| 10966If 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. | <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- |
---|
|
|
| 9588Match text field lengths in your DataSync Agent with | Enhanced error recovery when using temporal and the table does not exist in the database | <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-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”/> . | 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- |
---|
|
|
| 11753Using <column_sort>alpha</column_sort> | The <region> directive in the AWS S3 Subscriber Agent is now optional and no longer required | in your DataSync Agent will now sort new fields. 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- |
---|
|
|
| 11688When a table already exists upon an integration, the new reference fields will now have length of 32. | 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- |
---|
|
|
| 11738<enableerrorlog keep track of the number of invalid records and save the error count in the generated audit file. 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- |
---|
|
|
| 12003<close_file_interval> is added to set the amount of time the Agent will wait for tmp files to be modified. | 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) status. 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- |
---|
|
|
| 11861Enhanced error recovery when using temporal and the table does not exist in the database | DataSync Agent now supports Java 14. 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- |
---|
|
|
| 12058AWS S3 Subscriber | DataSync Agent now supports | sending receipts back to ServiceNow. 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- |
---|
|
|
| 14709<region> directive in the AWS S3 Subscriber Agent is now optional and no longer requiredDataSync 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- |
---|
|
|
| 14709AWS S3 Subscriber Agent logging extended for different levels. | 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- |
---|
|
|
| 14709Using <update_on_bulk/> will now skip duplicates in the DataSync Agent based on the message action | 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- |
---|
|
|
| 13562The 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) status | 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- |
---|
|
|
| 9580 | Sharing records from a database to the Integration Mesh will now be consumed without errors. | DataSync Agent now supports Java 14. 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 | 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>. | 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
Bug Fixes |
---|
Error when inserting/updated a record into a SAP HANA table that has 2 billion+ rows because of metadata query. | 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 attribute, use_basic_consume, in the agent.xml will reflect on the protocol given upon the configuration in DataSync Agent installer |
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 | 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). | 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- |
---|
|
|
| 11395Emojis | After deleting a field from a ServiceNow table, the old value of that field 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)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- |
---|
|
|
| 11990 deleting from with default value in a ServiceNow table, | the old value of that field executing a bulk share will no longer | be inserted into the databasegenerate 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- |
---|
|
|
| 12018 | Table stats data will now show the correct timezone offset | 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 | Using skip_duplicate with check_all_fields will now compare values properly. | 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
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 |
---|
|
|
|
|