NOTE: To view release notes for Perspectium versions Fluorine and beyond, see our new docs site Perspectium Docs.
Date Released | Release | Change | Product(s) Affected |
---|---|---|---|
April 24, 2019 | Europium Patch 3 | new feature: For MS SQL Server integrations, you can now configure dynamic database ports | Replicator Agent |
November 29, 2018 | Europium | new feature: Replicator Agent can now be run in test mode for testing purposes | Replicator Agent |
new feature: Replicator Agent can now be run within the Linux Terminal without superuser (sudo) access | Replicator Agent | ||
new feature: Command File Sharer configuration option added for records from .csv files being shared to ServiceNow from the Replicator Agent via ServiceNow command queries | Replicator Agent | ||
new feature: Data Guarantee can now be enabled for better tracking of shared Replicator Agent data messages via receipts | Replicator Agent | ||
new feature: Replicator Agent can now be configured to send out receipts at regular intervals and upon shutdown | Replicator Agent | ||
enhancement: MySQL 8 is now supported as a database for the Replicator Agent | Replicator Agent | ||
enhancement: File Replicator for Replicator Agent will now create headings in the topmost row of .csv files | Replicator Agent | ||
enhancement: Support added for the sharing of CLOB data types | Replicator Agent | ||
enhancement: Support added for data sharing with AES-256 encryption | Replicator Agent | ||
fixed: The validateConfiguration tool now only validates queues with a valid AMQPS connection | Replicator Agent | ||
fixed: Foreign character (4-byte UTF character) support can now be enabled for replication with MySQL 8 | Replicator Agent | ||
November 12, 2018 | Dubnium patch2 | fixed: Replication of foreign languages from Database to ServiceNow | Replicator Agent |
August 23, 2018 | Dubnium | fixed: The validateConfiguration tool can now be run as an admin on Windows devices | Replicator Agent |
fixed: batching of records when multiple tasks running | Replicator Agent | ||
fixed: password encryption works with the following special characters: ! @ # % ( ) - + < > & [ ] | Replicator Agent | ||
fixed: Agent can now reconnect automatically to a queue after connection to the queue is dropped | Replicator Agent | ||
fixed: 302 redirect error when using a proxy for <message_connection> or <instance_connection> | Replicator Agent | ||
fixed: an issue where the Validate Configuration Tool was consuming all messages when ran | Replicator Agent | ||
fixed: database port numbers were cached when navigating in between panels | Replicator Installer | ||
fixed: the formatting of the agent.xml after running the agent installer | Replicator Installer | ||
August 2, 2018 | Carbon | feature: agent now supports highly availability mode to enhance recovery of the agent | Replicator Agent |
enhancement: on agent startup, remove files that start with “psp” in the bin directory to prevent corrupted files from stopping agent system requirements | Replicator Agent | ||
enhancement: agent now supports Java 9 and 10 as illustrated in the system requirements | Replicator Agent | ||
enhancement: provide more helpful error message handling when connecting using http protocol | Replicator Agent | ||
fixed: agent stops on start up if system does not meet minimum system requirements | Replicator Agent | ||
fixed: issue where the agent is not consuming if the queue does not exist | Replicator Agent | ||
enhancement: support setting queue that ServiceNow Direct agent will read messages from outbound table in instance | Replicator Agent | ||
fixed: a connection issue when agent is configured with ServiceNow Direct | Replicator Agent | ||
feature: added the support of the Perspectium File Subscriber Replicator Agent to replicate to Amazon S3 | Replicator Agent | ||
enhancement: added a queue name field in Replicator Agent installer | Replicator Installer | ||
enhancement: reduced the package size of the Agent installer | Replicator Installer | ||
fixed: validation tool not correctly validating http(s) connection with specified queue | Replicator Agent | ||
fixed: agent not properly truncating the column data for the first record after increasing the column length | Replicator Agent | ||
November 1, 2018 | Bismuth patch3 | fixed: Replication of foreign languages from Database to ServiceNow | Replicator Agent |
February 8, 2018 | Bismuth | fixed: wrapper logs not being rotated properly | Replicator Agent |
fixed: improve URL validation on agent startup | Replicator Agent | ||
feature: Ready to Run agent installation | Replicator Installer | ||
October 5, 2017 | Argon | enhancement: log database and table names when warning about truncating a column | Replicator Agent |
enhancement: default message_connection to have basic consume attribute set to true | Replicator Installer | ||
September 1, 2017 | 3.26.0 | enhancement: Validate Configuration Tool will no longer report duplicates when multiple tasks are configured | Replicator Agent |
enhancement: made data cache directory configurable | Repeater and Service Manager Agent | ||
fixed: when perspectium.log reaches at least 20 MB, it will now save older logs and roll over to the new logs correctly | Replicator Agent | ||
enhancement: create large fields as nvarchar(max) in MSSQL to support distinct queries | SQL Subscriber | ||
enhancement: handle numeric fields with NaN value by setting it to null and not throwing an exception | SQL Subscriber | ||
feature: support of PostgreSQL Database | Replicator Agent | ||
August 11, 2017 | 3.25.0 | fixed: an issue where the Validate Configuration Tool was consuming messages. | Replicator Agent |
fixed: message set count incorrect for HTTPS connections | Replicator Agent | ||
enhancement: message set processing every 1000 messages instead of every message | Replicator Agent | ||
feature: agent now supports with Solaris OS Platform | Replicator Agent | ||
July 19, 2017 | 3.24.0 | fixed: display proper queue not found error message for when queue does not exist | Replicator Agent |
enhancement: no longer write alerts to the error directory when unable to connect to MBS | Directory Sharer | ||
feature: replicator agent now supports 64 bit wrapper and available for upgrade | Replicator Agent | ||
July 19, 2017 | 3.23.1 | fixed: performance degradation when agent is consuming a large amount of records Replicator Agent | Replicator Agent |
June 27, 2017 | 3.23.0 | enhancement: users can now dynamically change logging level to debug using the set logging script | Replicator Agent |
fixed: when using edge encryption, the agent cannot find the keystore.jceks file | Replicator Agent | ||
June 5, 2017 | 3.22.0 | enhancement: improved Redshift data throughput by utilizing S3 buckets as a staging area where replicated data are stored then populated to Redshift tables. | Replicator Agent |
May 11, 2017 | 3.21.0 | feature: agent now uses Basic Consume by default | Replicator Agent |
April 18, 2017 | 3.20.0 | enhancement: added the ability to use a TNS string for connections to Oracle | Replicator Agent |
enhancement: modified Agent reporting mechanism to improve stability and volume | Replicator Agent | ||
enhancement: modified Agent retry capabilities to prevent primary key errors when running multiple tasks | Replicator Agent | ||
March 27, 2017 | 3.19.0 | fix: log an error when attempting to replicate a table that's unknown by ServiceNow | Replicator Agent |
enhancement: updated packaged sqlserver JDBC driver to 6.1 as Microsoft is ending support lifecycle for JDBC 4.0 | Replicator Agent | ||
enhancement: replicator agent logging now includes the thread name in each message | Replicator Agent | ||
feature: save each record as its own file | File Subscriber | ||
March 14, 2017 | 3.18.2 | enhancement: improved handling of connection failures to the database | Replicator Agent |
enhancement: improved retry ability for committing records to the database within unstable environments | Replicator Agent | ||
March 2, 2017 | 3.18.1 | enhancement: optimized prefetch size to reduce memory usage | Replicator Agent |
enhancement: queueing consumer is now only allocated once per task | Replicator Agent | ||
enhancement: optimized the handling of channels per a connection | Replicator Agent | ||
February 16, 2017 | 3.18.0 | fix: improved handling of failed connections to prevent individual threads from terminating | Replicator Agent |
fix: an incorrect path for wrapper configuration which caused a StatusLogger error on start up for agent running in Windows environment | Replicator Agent | ||
enhancement: create Report supports double clicking to launch in Windows | Replicator Agent | ||
January 20, 2017 | 3.17.0 | enhancement: added support for type attribute in <instance_connection> | Replicator Agent |
enhancement: validateConfiguration.bat supports double clicking to launch in Windows | Replicator Installer | ||
enhancement: updated default values for task instances=4, max_reads_per_connect=4000, and polling_interval=1 to optimize subscribing configuration | Replicator Installer | ||
enhancement: replicator installer now supports user entering a database type | Replicator Installer | ||
enhancement: enhanced validate configuration to be user friendly and provide more suggestions | Replicator Agent | ||
enhancement: default to using <message_connection> at task level in agent configuration | Replicator Agent | ||
enhancement: log more useful information when starting up the agent | Replicator Agent | ||
feature: report table counts every 30 minutes | Replicator Agent | ||
fixed: handling of trailing “Z” in ISO 8601 time format | Replicator Agent | ||
December 14, 2016 | 3.16.0 | enhancement: added optional Database SID field for Oracle | Replicator Installer |
enhancement: added message and reporting connection to default to the same server configured during the Agent installation process | Replicator Installer | ||
enhancement: subscriber record errors will be sent back to ServiceNow instance | Replicator Agent | ||
feature: vertica database support | Replicator Agent | ||
October 28, 2016 | 3.15.0 | enhancement: add additional logging entry for errors | SQL Subscriber |
fixed: An issue where dynamic columns were not processed properly | SQL Subscriber | ||
September 30, 2016 | 3.14.0 | fixed: TableAction error after adding a new column field name that is larger than 60 characters | SQL Subscriber |
enhancement: default to the same server as message_connection for reporting connection | Replicator Agent | ||
removed: deprecated file subscriber option from installer | Replicator Agent | ||
enhancement: provide support of 64 bit fixed and floating point values | SQL Subscriber | ||
September 2, 2016 | 3.13.0 | enhancement: support a subset of columns from a table | SQL Subscriber |
fixed: Table Action error when replicating a Account Table from Salesforce to a DB | SQL Subscriber | ||
fixed: null values are displayed as a string for empty fields | SQL Subscriber | ||
enhancement: see output from stderr and stdout in the agent log files | SQL Subscriber | ||
August 15, 2016 | 3.12.0 | enhancement: component_type set for heartbeat sent in for support | Replicator Agent |
July 15, 2016 | 3.11.0 | fixed: unable to share records after connection idles | vSphere Sharer |
fixed: SQLTableStructure runtime error with format specifier | SQL Subscriber | ||
fixed: replication of ServiceNow Table views returns the SQL Errors | SQL Subscriber | ||
fixed: xml encoded field values from ServiceNow incorrectly contain XML encoding when inserted/updated into table | SQL Subscriber | ||
feature: added the ability to Create Report which packages the agent config and log files into a zip file | Replicator Agent | ||
June 24, 2016 | 3.10.1 | fixed: issue with replication of CR and LF in ServiceNow fields to Database | SQL Subscriber |
fixed: issue with replication of ServiceNow database view tables to Database | SQL Subscriber | ||
fixed: hanging of the Agent when replicating to a Database that contains an extremely large number of rows | Replicator Agent | ||
June 17, 2016 | 3.10.0 | fixed: SQLShareByLastUpdateQuery not properly working | SQL Sharer |
enhancement: simplify the handling of column name mappings | Replicator Agent |
View Previous Releases for the Perspectium Replicator Agent.
Date Detected | Releases Affected | Issue | Fixed in Release |
---|---|---|---|
06/01/2018 | Argon + | Foreign characters not correctly sharing out from database to ServiceNow | Bismuth, Dubnium |
06/01/2018 | Carbon | The formatting for the agent.xml displays incorrectly | Dubnium |
04/26/2018 | Argon | If Agent is ran with a queue that doesn't exist, it will display “the [queue] you are subscribing to does not exit, it will be auto-created once data is shared to it…retrying.” even after the queue gets created. | Dubnium |
07/06/2017 | 3.16.0+ | Running the Agent Validation Configuration will consume messages if message connection is set to HTTPS and specified queue | 3.25.0 |
06/27/2017 | 3.23.0+ | Agent message set activity count not displaying correctly in ServiceNow with AMQP(S) connections | Not Fixed |
06/20/2017 | 3.23.0+ | Empty MBS logs are generated in the Agent log folder | Carbon |
05/07/2017 | 3.20.0 | Agent might hang at times on performance reporting threads | 3.21.0 |
02/15/2017 | 3.18.0 | Agent returns a WARN message TableStatsReporter - Error: java.lang.NullPointerException for MySQL Agent. | 3.25.0 |
01/12/2017 | 3.17.0 | Agent returns a StatusLogger error on start up when ran on a Windows environment. | 3.18.0 |
12/23/2016 | 3.14.0+ | Oracle Agent will return the Error ORA-00955: name is already used by an existing object when replicating inserts to an Oracle DB running multiple subscribe tasks | 3.17.0 |
10/26/2016 | 3.14.0+ | Agent will receive a WARNING - Unable to load the Wrapper''s native library 'wrapper.dll' when ran using a 64-Bit JVM instead of 32-Bit | Not Fixed |
09/29/2016 | 3.13.0 | Replication of database view tables returns a Table Action error | 3.14.0 |
07/20/2016 | 3.11.0+ | The message set activity reported by the Agent is incorrect for HTTPS connections | 3.25.0 |
07/08/2016 | 3.11.0 | The Agent will return an error if the name of the Agent created contains non-alphanumeric characters | 3.12.0 |
06/17/2016 | 3.10.0+ | Sharing of Uppercase columns from Database to ServiceNow is not compatible. | Not Fixed |
06/07/2016 | 3.10.0+ | The message set count might be incorrect if the Replicator Agent is interrupted and resumed during data replication. | Not Fixed |
06/07/2016 | 3.10.0+ | The missing of 1 record is possible if the Agent process is suspended or interrupted then resumed during data replication. (AMQP/S) | Not Fixed |
06/20/2016 | 3.9.0 | ServiceNow database view tables do not replicate to the Database correctly | 3.10.1 |
05/25/2016 | 3.9.0 | When replicating a long table with a similar name that gets truncated by default to Oracle DB, only one column will replicate since when truncated, the names will be the same. | Not Fixed |
06/06/2016 | 3.8.0 | issue which would cause a DB timeout when retrieving metadata for very large tables. | 3.10.1 |
06/13/2016 | 3.8.0 | Issue with Replicator Agent DB sharing which resulted in no shared records when a criteria of last updated date field was used | 3.10.0 |
05/25/2016 | 3.8.0+ | Dynamic columns feature in the Agent configuration is not functioning properly. | 3.15.0 |
06/03/2016 | 3.2.5+ | When replicating ServiceNow fields that contains CR and LF, the values “
” are replicated to the Database | 3.10.1 |
04/28/2016 | 3.2.5+ | Replicator will return a SQLException - identifier is too long error when a Table name with over 30 characters is replicated. | 3.9.0 |
04/15/2016 | 3.7.0 | Upon replicating a field that contains decimals from SN to a DB, the value listed in the DB after replication would contain extra decimals (5 places). | 3.14.0 |
04/01/2016 | 3.7.0 | Agent might display a Dpapi -decrypted value Error although user credentials are correct and protected although data successfully replicates to MSSQL DB | 3.8.0 |
03/30/2016 | 3.7.0 | Agent might encounter various SQLTableStructure errors during replication due to new Data Types for Geneva | 3.8.0 |
03/29/2016 | 3.7.0 | Agent returns a ERROR SQLTableStructure when the data type “Glide_date” is replicated. | 3.9.0 |
03/16/2016 | 3.6.1 | Agent returns a TableAction error String or binary data would be truncated when replicating a larger dictionary value of a ServiceNow field. (MSSQL only) | 3.8.0 |
03/16/2016 | 3.6.1 | Agent displays a WARN SQLTableStructure - Column: [custom_price_field] type error but can't modify the type! when replicating a custom price field (Oracle and MSSQL) | 3.7.0 |
03/11/2016 | 3.6.0 | Agent returns a SQLTableStructure error when replicating a larger dictionary from two different ServiceNow instances. | 3.7.0 |
03/11/2016 | 3.6.0, 3.6.1 | Agent returns a SQLSubscriber error when replicating a larger dictionary value of a ServiceNow field. | 3.7.0 |
03/07/2016 | 3.6.0, 3.6.1 | Agent receives a WARN SQLROW message when a non json array data is excluded as json array | 3.7.0 |
02/18/2016 | 3.5.0 | Replication of a custom price field that uses the currencies (Euro, Pound, Yen, and CHF) defaults to system currency of ServiceNow | Not an Agent Issue |
02/18/2016 | 3.5.0 | Korean Characters do not replicate correctly to Oracle DB. | Not Fixed |
02/16/2016 | 3.5.0 | Database mapping for MySQL is not mapping all types properly. | 3.9.0 |
02/16/2016 | 3.5.0 | Database_connection_timeout use error. | Not Fixed |
02/16/2016 | 3.4.4+ | Replicator agent does not start if one of the target databases is not accessible. | 3.9.0 |
02/12/2016 | 3.4.2+ | Agent returned a Table Action error after adding a new column field name that is larger than 60 characters. | 3.8.0 |
12/11/2015 | 3.3.0 - 3.4.4 | When replicating a table that contains the fx_price field, the agent will return an error if the fx_price column is not excluded using the <exclude_columns> directive. | 3.5.0 |
01/27/2016 | 3.4.1, 3.4.2, 3.4.3 | Sharing feature of Replicator agent does not function correctly, this is due to the set fetch size change. | 3.4.4 |
02/08/2016 | 3.4.0 | Replicated data that is too large to fit into the target column is not truncated. | Not Fixed |
02/08/2016 | 3.4.0 | When subscribing to MySQL, a failure might occur when the database is inactive for a long period of time | Not Fixed |
01/25/2016 | 3.4.0, 3.4.1 | Replicator agent would hang when replicating to a DB that has a large amount of rows for tables sys_journal_field and sys_audit. | 3.4.2 |
01/12/2016 | 3.4.0 | The connection closes when a queue that doesn't exist is queried. | 3.5.0 |
12/15/2016 | 3.3.0-3.4.4 | Replicator's default string size is not 250. | 3.5.0 |
01/17/2016 | 3.3.0 | Unknown column error when schema directory is not present and a new field is created on ServiceNow and replicated to Oracle DB. | 3.3.1 |
01/19/2016 | 3.3.0 | Replicator Agent throws error when connecting to a MySQL database with any username other than “root”. | 3.3.1 |
12/28/2015 | 3.3.0 | A dynamic share that has update as its action will not be applied to a non-existent primary key, SQL will state no update and it's not reported as an error. | Not Fixed |
01/17/2016 | 3.3.0 | Upon running a bulk share of a table with new custom created fields to an Oracle DB, the newly created field would display in Uppercase. | 3.3.1 |
01/19/2016 | 3.3.0-3.4.4 | Replication of a ServiceNow view is failing when there's more than 1 pseduo sys_id field and one of them has no value. | 3.5.0 |
01/11/2016 | 3.3.0 | Data is lost when schema service is interrupted. | 3.4.0 |
12/28/2015 | 3.3.0 | Customer using SQLSubscriberIODateTimePlugin report inconsistencies up updating target table | 3.4.0 |
11/13/2015 | 3.2.5 | Name is displayed as “Will be overwritten” on ServiceNow after running a share task on agent from DB to ServicenNow | 3.3.0 |
12/14/2016 | 3.2.5 | Upon sharing a table from an Agent to ServiceNow, an Error is returned with an invalid record state. The name field in ServiceNow is displayed as ticket.null. | 3.3.0 |
12/09/2015 | 3.2.5 | Customers are not able to share views since they don't have a sys_id which is required as the primary key. | 3.3.0 |
12/03/2015 | 3.2.4, 3.2.5 | Upper case columns replication for Oracle DB not functioning correctly. | 3.3.0 |
10/20/2015 | 3.2.5 | “File not found” error after selecting the option Exchange and did not get an option to enter in our exchange name. | 3.2.9 |
08/07/2015 | 3.2.4 | Agent not catching floating poin values for integers which caused a Numberformat exception. | 3.2.5 |
08/03/2015 | 3.2.3 | When PSP_SCHEMA is downloaded, both upper case and lower case files are created. | 3.2.4 |
07/28/2015 | 3.2.3 | Encrypted string values in config fields not working properly. | 3.2.4 |
07/06/2015 | 3.1.15 | When a queue is missing, replicator agent goes into loop repeatedly. | 3.2.3 |
08/28/2015 | 3.1.14 | Chinese and Japanese Characters does not properly replicate to DB | 3.1.15 |
For more information about current and previous Perspectium Replicator Agent releases or to request an upgrade, e-mail support@perspectium.com or call 888.620.8880.