Release Date: March 11, 2021New Features |
---|
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-89477a90901dkey | CE-168 | Use <batch_flush_interval> for the number of seconds that will trigger a batch SQL statement execution with batch processing.914c-89477a90901d | key | DEV-9446 |
---|
|
|
|
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. | 9720Use <skip_performance_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- |
---|
|
|
| 10621Enable truncating table in the database by the DataSync Agent using Truncate Before Share. | The DataSync Agent Installer will now 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- |
---|
|
|
| 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. | 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- |
---|
|
|
| 14515Customize your temporal database table's archive date and time stamp in the psp_valid_to column with <archive_datetime/> | 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- |
---|
|
|
| 13182Enhancements | The DataSync Agent Installer will now use HTTPS as a protocol by default in <message_connection>. | 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- |
---|
|
|
| 10785Snowflake DataSync Agent will automatically have parameter values to default to uppercase characters after installation. | 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- |
---|
|
|
| 10932Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step. | 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,resolutionserverId | 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.,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 |
---|
| 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 | When a table already exists upon an integration, the new reference fields will now have length of 32 | <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”/> . | <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- |
---|
|
|
| 11615 in your DataSync Agent will now sort new fieldsUsing <column_sort>alpha</column_sort><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- |
---|
|
|
| 11688When a table already exists upon an integration, the new reference fields will now have length of 32 | 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- |
---|
|
|
| 11738<enable_error_log/> will now keep track of the number of invalid records and save the error count in the generated audit file | 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- |
---|
|
|
| 12003<close_file_interval> is added to s | The <region> directive in the AWS S3 Subscriber Agent is now optional and no longer required | et 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- |
---|
|
|
| 11861Enhanced error recovery when using temporal and the table does not exist in the database. | 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- |
---|
|
|
| 12058AWS S3 Subscriber Agent now supports sending receipts back to ServiceNow. | Using <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-14709 | The <region> directive in the AWS S3 Subscriber Agent is now optional and no longer required. | 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- |
---|
|
|
| 14709AWS S3 Subscriber Agent logging extended for different levels. | 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- |
---|
|
|
| 14709Using <update_on_bulk/> will now skip duplicates in the DataSync Agent based on the message action | 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- |
---|
|
|
| 13562 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.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- |
---|
|
|
| 9580 | The action of processing delete messages will not alter the database tables | 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- |
---|
|
|
| 9593DataSync Agent now supports Java 15 | 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- |
---|
|
|
| 11071The DataSync Agent Installer will now allow you to enter FedRAMP URLs for your ServiceNow instance information. | 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- |
---|
|
|
| 12295The action of processing delete messages will not alter the database tables. | 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- |
---|
|
|
| 13317Agent re-queues delete records up to 3 times when no record in database to delete. | 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- |
---|
|
|
| 13164
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 |
---|
|
|
|
|