Past Private Agent Releases¶

Introduction¶

This page provides a compilation of end-of-life releases for the Private Agent. For the latest Private Agent releases, see Private Agent Releases.

See Known Issues for detailed information on issues and workarounds.

End-of-Life Private Agent Release Notes¶

10.69 / 11.7¶

The 10.69 / 11.7 release date for Private Agents is by region:

• APAC: April 17, 2023 (8 PM AEST)
• EMEA: April 18, 2023 (12 PM CEST)
• NA: April 19, 2023 (3 AM PDT)

Enhancements¶

• NetSuite WSDL version 2022.2 support
  Jitterbit has verified support for NetSuite WSDL version 2022.2 using agents version 10.33 and later with the Cloud Studio NetSuite Connector and the Design Studio NetSuite Connector.

• Salesforce API version 57 support
  Salesforce API version 57 is now supported for these connectors:

  • The Cloud Studio Salesforce, Salesforce Service Cloud, and ServiceMax connectors use API version 57 automatically with the use of a 10.69 or 11.7 agent.

  • The Design Studio Salesforce connector provides the option to use API version 57 with the use of both a 10.69 or 11.7 agent and 10.69 version of Design Studio. When opening an existing Design Studio project that uses this connector and meets both of these version requirements, you will be prompted to upgrade to Salesforce API version 57.

Notices¶

• Jitterbit’s intention to stop distributing Private Agent 10.x
  Jitterbit intends to stop distributing a 10.x Private Agent version within the next several Harmony releases. Since Harmony release 10.63 / 11.1, both a 10.x and 11.x Private Agent version have been distributed with these differences:

  • 11.x versions: In 11.1 and later versions, the PostgreSQL database bundled with the Private Agent is now version 14.5-1.
  • 10.x versions: Current 10.x versions are packaged with the existing 9.6.24-1 PostgreSQL. The distributed 10.x versions will continue to be supported in accordance with Jitterbit’s end-of-life policy.

  Note

  Upgrading to an 11.x Windows Private Agent from 10.x requires a complete uninstall. Follow the documented instructions to complete the upgrade. Linux Private Agents can be upgraded as usual from any 10.x version.

10.68 / 11.6¶

The 10.68 / 11.6 release date for Private Agents is by region:

• APAC: March 28, 2023 (9 PM AEDT)
• EMEA: March 29, 2023 (12 PM CEST)
• NA: March 30, 2023 (3 AM PDT)

The release notes will be published on this page prior to the release.

Enhancements¶

• New Jitterbit variable to write the SOAP fault response
  The new Jitterbit variable jitterbit.webservice.last_fault captures the last XML-formatted fault response when referenced downstream of a Cloud Studio SOAP activity or Design Studio web service that returns a SOAP fault derived from a 5XX server error.

• Proxy support for Docker Private Agents
  The Docker Private Agent image now supports installing Private Agents with a proxy configuration. To pass the required parameters, see Jitterbit’s Docker documentation.

Fixes¶

• Non-UTF-8 characters no longer cause child operations to fail
  An intermittent issue has been fixed with Cloud Agents and Linux Private Agents where writing non-UTF-8 characters to a global variable resulted in unexpected log output and failure to execute child operations. The issue did not occur on Windows Private Agents.

Notices¶

• Jitterbit’s intention to stop distributing Private Agent 10.x
  Jitterbit intends to stop distributing a 10.x Private Agent version within the next several Harmony releases. Since Harmony release 10.63 / 11.1, both a 10.x and 11.x Private Agent version have been distributed with these differences:

  • 11.x versions: In 11.1 and later versions, the PostgreSQL database bundled with the Private Agent is now version 14.5-1.
  • 10.x versions: Current 10.x versions are packaged with the existing 9.6.24-1 PostgreSQL. The distributed 10.x versions will continue to be supported in accordance with Jitterbit’s end-of-life policy.

  Note

  Upgrading to an 11.x Windows Private Agent from 10.x requires a complete uninstall. Follow the documented instructions to complete the upgrade. Linux Private Agents can be upgraded as usual from any 10.x version.

10.67 / 11.5¶

The 10.67 / 11.5 release date for Private Agents is by region:

• APAC: March 7, 2023 (AEDT)
• EMEA: March 7, 2023 (CET)
• NA: March 8, 2023 (PST)

Enhancements¶

• Apache Tomcat upgrade
  The Apache Tomcat server included with the agent has been upgraded to version 8.5.85 to improve security and performance.

Fixes¶

• Agent performance improved
  Agent performance has been improved and fewer errors now occur when running high throughput over many hours.

• NetSuite connector custom fields for the Estimate object are now shown
  Custom fields for the Estimate object are now visible in the Cloud Studio NetSuite Search and Design Studio NetSuite Search activities.

Notices¶

• Jitterbit’s intention to stop distributing Private Agent 10.x
  Jitterbit intends to stop distributing a 10.x Private Agent version within the next several Harmony releases. Since Harmony release 10.63 / 11.1, both a 10.x and 11.x Private Agent version have been distributed with these differences:

  • 11.x versions: In 11.1 and later versions, the PostgreSQL database bundled with the Private Agent is now version 14.5-1.
  • 10.x versions: Current 10.x versions are packaged with the existing 9.6.24-1 PostgreSQL. The distributed 10.x versions will continue to be supported in accordance with Jitterbit’s end-of-life policy.

  Note

  Upgrading to an 11.x Windows Private Agent from 10.x requires a complete uninstall. Follow the documented instructions to complete the upgrade. Linux Private Agents can be upgraded as usual from any 10.x version.

10.66 / 11.4¶

The 10.66 / 11.4 release date for Private Agents is by region:

• APAC: February 14, 2023 (AEDT)
• EMEA: February 14, 2023 (CET)
• NA: February 15, 2023 (PST)

Fixes¶

• Alternative regex parser resolves FTP read issue
  In situations where a Cloud Studio FTP Read activity or Design Studio FTP Site source doesn’t return expected data, using an alternative regex parser may fix the issue. To use, set the Jitterbit variable jitterbit.source.ftp.enable_regex_parser to true in a script upstream of the FTP source in an operation.

• Base64Encode function now encodes binary data properly
  The Base64Encode function now encodes binary data properly when the Jitterbit variable jitterbit.base64.encoded.string.no.wrap is set to disable wrapping. This was not an issue when the result was wrapped (default behavior) or when the input was string data.

• HTTP custom proxy settings now support variables
  When configuring a custom proxy in a Cloud Studio HTTP connection or Design Studio HTTP source or target, variables configured in the Host, User, Password, and NTLM Domain fields are now correctly processed as variables by the agent.

Notices¶

• Jitterbit’s intention to stop distributing Private Agent 10.x
  Jitterbit intends to stop distributing a 10.x Private Agent version within the next several Harmony releases. Since Harmony release 10.63 / 11.1, both a 10.x and 11.x Private Agent version have been distributed with these differences:

  • 11.x versions: In 11.1 and later versions, the PostgreSQL database bundled with the Private Agent is now version 14.5-1.
  • 10.x versions: Current 10.x versions are packaged with the existing 9.6.24-1 PostgreSQL. The distributed 10.x versions will continue to be supported in accordance with Jitterbit’s end-of-life policy.

  Note

  Upgrading to an 11.x Windows Private Agent from 10.x requires a complete uninstall. Follow the documented instructions to complete the upgrade. Linux Private Agents can be upgraded as usual from any 10.x version.

10.65 / 11.3¶

The 10.65 / 11.3 release date for Private Agents is by region:

• APAC: January 24, 2023 (AEDT)
• EMEA: January 24, 2023 (CET)
• NA: January 25, 2023 (PST)

Fixes¶

• Salesforce Events (Beta) connector now supports project variables
  Using project variables in a Salesforce Events (Beta) connection now works as expected. Previously, an error with starting the listener activity was returned.

Notices¶

• Jitterbit’s intention to stop distributing Private Agent 10.x
  Jitterbit intends to stop distributing a 10.x Private Agent version within the next several Harmony releases. Since Harmony release 10.63 / 11.1, both a 10.x and 11.x Private Agent version have been distributed with these differences:

  • 11.x versions: In 11.1 and later versions, the PostgreSQL database bundled with the Private Agent is now version 14.5-1.
  • 10.x versions: Current 10.x versions are packaged with the existing 9.6.24-1 PostgreSQL. The distributed 10.x versions will continue to be supported in accordance with Jitterbit’s end-of-life policy.

  Note

  Upgrading to an 11.x Windows Private Agent from 10.x requires a complete uninstall. Follow the documented instructions to complete the upgrade. Linux Private Agents can be upgraded as usual from any 10.x version.

10.64 / 11.2¶

The 10.64 / 11.2 release date for Private Agents is by region:

• APAC: January 11, 2023 (AEDT)
• EMEA: January 11, 2023 (CET)
• NA: January 12, 2023 (PST)

Changes¶

• MD5 and SHA256 function behavior changed for binary files
  Jitterbit’s MD5 and SHA256 functions now generate the correct values for binary files such as ZIP and PDF. Output of text files is unchanged.

  We recommend updating existing Cloud Studio and Design Studio projects that have a saved hash for binary files to use the new output.

  As an alternative, to maintain the behavior prior to this change, you can set $jitterbit.md5.hash.use.file.mode.string.only=true in a script upstream of the function call to generate the same values as prior to this change.

Fixes¶

• Private Agents now run after installation without an environment
  When installing a Private Agent in an Agent Group that does not have an associated environment, it will again start up in Running status. Previously, since Private Agent version 10.61, the agent status after installation was Stopped and prevented from running until an environment was associated.

10.63 / 11.1¶

The 10.63 / 11.1 release date for Private Agents is by region:

• APAC: December 13, 2022 (AEDT); patched December 27, 2022 (AEDT)
• EMEA: December 13, 2022 (CET); patched December 26, 2022 (CET)
• NA: December 14, 2022 (PST); patched December 26, 2022 (PST)

Enhancements¶

• PostgreSQL upgrade
  In the 11.1 agent version, the PostgreSQL database bundled with the Private Agent is now version 14.5-1. A 10.63 agent (packaged with the existing 9.6.24-1 PostgreSQL) and an 11.1 agent (packaged with the 14.5-1 PostgreSQL) are both available for download. There are no functional differences other than the upgrade of the underlying database.

  Note

  Upgrading to an 11.x Windows Private Agent from 10.x requires a complete uninstall. Follow the documented instructions to complete the upgrade. Linux Private Agents can be upgraded as usual from any 10.x version.

• Design Studio support for OAuth 2.0 Microsoft 365 email messages
  Design Studio email messages now support OAuth 2.0 for Microsoft 365 email messages as described in OAuth 2 Support for Microsoft 365 Email.

  Note

  This was released as a patch (agent versions 10.63.1 and 11.1.1) after the initial release.

Fixes¶

• URLEncode function now gives the expected output
  Jitterbit’s URLEncode function now returns the expected output for control characters with ASCII values less than 16, notably horizontal tab (9), line feed (10), vertical tab (11), and carriage return (13).

10.62¶

The 10.62 release date for Private Agents is by region:

• APAC: November 22, 2022 (AEDT)
• EMEA: November 22, 2022 (CET)
• NA: November 28, 2022 (PST)

The 10.62 Private Agent version includes general updates. An 11.0 Private Agent version was not released.

10.61¶

The 10.61 release date is by region:

• APAC: November 2, 2022 (AEDT)

• EMEA: November 2, 2022 (CET)

• NA: November 3, 2022 (PDT)

Enhancements¶

• PgBouncer upgrade
  PgBouncer, a connection pooling application for PostgreSQL that is included in an agent install, has been upgraded to version 1.17.0. As part of the upgrade, the PgBouncer default port of 6432 is now used instead of 6543.

Fixes¶

• Design Studio no longer erroneously reports changes to a project
  On opening the Design Studio application, a dialog indicating the local project is outdated and asking you to download a newer version of the project is no longer displayed when the deployed project has not actually been modified.

10.60¶

The 10.60 release date is by region:

• APAC: October 12, 2022 (AEST)

• EMEA: October 12, 2022 (CEST)

• NA: October 13, 2022 (PDT)

This version includes general updates and support for the Google Pub Sub connector.

10.59¶

The 10.59 release date is by region:

• APAC: September 20, 2022 (AEST)

• EMEA: September 20, 2022 (CEST)

• NA: September 21, 2022 (PDT)

Enhancements¶

• New Jitterbit variable for allowing a blank API response
  The new Jitterbit variable jitterbit.api.response.blank_error_response can be set to true to allow a blank API response to be returned for non-200-type status codes such as 404. When set to false (default), an HTML status page is rendered for the returned status code. This feature requires agent and API Gateway versions 10.59 or later.

10.58¶

The 10.58 release date is by region:

• APAC: August 30, 2022 (AEST)

• EMEA: August 30, 2022 (CEST)

• NA: September 1, 2022 (PDT)

This version includes library upgrades and general updates.

10.57¶

The 10.57 release date is by region:

• APAC: August 9, 2022 (AEST), August 8, 2022 (PDT)

• EMEA: August 9, 2022

• NA: August 10, 2022

Enhancements¶

• Apache Tomcat upgrade
  The Apache Tomcat server included in the agent has been upgraded to version 8.5.81 to improve security and performance.

10.56¶

The 10.56 release date is by region:

• APAC: July 19, 2022 (AEST), July 18, 2022 (PDT)

• EMEA: July 19, 2022

• NA: July 20, 2022

Fixes¶

• DbExecute with an ODBC driver no longer causes Windows Private Agent crashes
  Using the DbExecute function against a database that uses an ODBC driver on a Windows Private Agent no longer causes memory issues resulting in an agent crash.

10.55¶

The 10.55 release date is by region:

• APAC: June 28, 2022 (AEST), June 27, 2022 (PDT)

• EMEA: June 28, 2022

• NA: June 29, 2022

Enhancements¶

• Support for Salesforce API version 54
  Salesforce API version 54 is now supported for these connectors:

  • The Cloud Studio Salesforce, Salesforce Service Cloud, and ServiceMax connectors use API version 54 automatically with the use of a 10.55 agent.

  • The Design Studio Salesforce connector provides the option to use API version 54 with the use of both a 10.55 agent and 10.55 version of Design Studio. When opening an existing Design Studio project that uses this connector and meets both of these version requirements, you will be prompted to upgrade to Salesforce API version 54.

10.54¶

The 10.54 release date is by region:

• APAC: June 8, 2022 (AEST), June 7, 2022 (PDT)

• EMEA: June 8, 2022

• NA: June 9, 2022

Changes¶

• Changes required for SAP connector projects
  As of Private Agent version 10.54, Jitterbit's SAP connectors will no longer work until you obtain and install the SAP library files as described in SAP Connector Installation. If the SAP library files have not been installed, your SAP operations will fail with an error indicating that the class for SAP JCo cannot be found.

Fixes¶

• Archiving successful files from an FTP endpoint now works
  The Use Success Folder option of a Cloud Studio or Design Studio FTP endpoint now works as expected. Since agent version 10.40, processed files were not being copied to the specified success folder on the Private Agent machine.

10.53¶

The 10.53 release date is by region:

• APAC: May 17, 2022 (AEST), May 16, 2022 (PDT)

• EMEA: May 17, 2022

• NA: May 18, 2022

Enhancements¶

• NetSuite connector now supports the Bill Payment object
  The NetSuite Bill Payment object is now available for selection when using the Cloud Studio and Design Studio NetSuite connectors. Custom fields associated with the object will appear in generated schemas.

• SAP RFC activities now support CHANGING parameters
  SAP Remote Function Calls (RFCs) that declare tables using CHANGING parameters are now supported using the Cloud Studio and Design Studio SAP connectors.

10.52¶

The 10.52 release date is by region:

• APAC: April 26, 2022 (AEST), April 25, 2022 (PDT)

• EMEA: April 26, 2022

• NA: April 27, 2022

Fixes¶

• Better support for multi-byte characters
  Agents now have better support for multi-byte characters.

10.51¶

The 10.51 release date is be region:

• APAC: April 5, 2022 (AEST), April 4, 2022 (PDT)

• EMEA: April 5, 2022

• NA: April 6, 2022

Fixes¶

• Windows Private Agents can again be installed with a configured proxy
  Configuring a proxy during Windows Private Agent installation no longer results in a login error and the installation is now successful.

10.50¶

The 10.50 release date is by region:

• APAC: March 18, 2022 (AEDT), March 17, 2022 (PDT)

• EMEA: March 15, 2022

• NA: March 16, 2022

Enhancements¶

• New Jitterbit variable for returning multiple database results as a record set
  The new Jitterbit variable jitterbit.scripting.db.search.rowset can be set to true upstream of the DBExecute function with a database and a JDBC driver. This will result in any calls to a stored procedure that returns multiple results to return the first non-empty record set instead of returning an empty set.

10.49¶

The 10.49 release date is by region:

• APAC: 23 February 2022 (AEDT), 22 February 2022 (PST)

• EMEA: 23 February 2022

• NA: 24 February 2022

Enhancements¶

• New Jitterbit variable for decoding HTML characters in nodes
  The new Jitterbit variable jitterbit.decode.html.chars can be set to true upstream of the SelectSingleNode or SelectNodes functions for these functions to support HTML characters.

• New Jitterbit variable for wrapping of Base64-encoded strings
  The new Jitterbit variable jitterbit.base64.encoded.string.no.wrap can be set to true upstream of the Base64Encode or Base64EncodeFile functions to disable wrapping after the 64th character of the encoded result string.

10.48¶

The 10.48 release date is by region:

• APAC: 2 February 2022 (AEDT), 1 February 2022 (PST)

• EMEA: 2 February 2022

• NA: 3 February 2022

Enhancements¶

• Windows Quiet Agent Installer now has a configurable installation directory and PostgreSQL username
  As part of the Windows Quiet Agent Installer config64.ps1 script, instead of using defaults you can now specify the installation location of the Private Agent and associated components, and specify an alternative PostgreSQL username the agent uses to log in to the PostgreSQL database engine.

• Operation debug logging now logs input and output data
  When you enable operation debug logging at the Cloud Studio operation level using the Enable Debug Mode Until operation option, input and output data for each operation is now accessible in the Cloud Studio operation log screen. You must be using a Private Agent version 10.48 or later to generate the additional log data.

• Support for Windows 11 and Windows Server 2022
  Jitterbit has validated that Private Agents are supported on Windows 11 and Windows Server 2022.

Fixes¶

• Agent-Install permission now works with Linux Private Agent installs
  Agent-Install permission now works as expected when installing Linux Private Agents. Previously, when attempting an install, an error indicated that the user was "not the administrator of any organization".

• Pending operations now error out as appropriate
  In certain circumstances due to a PostgreSQL database crash, operations that were stuck in Pending status now error out as appropriate.

• Cloud Studio application activities with a request can now succeed without transformation input
  When used in an operation, application activities that have a request schema no longer require a preceding transformation to succeed at runtime. This fix requires a 10.48 or later agent.

10.47¶

The 10.47 release date is by region:

• APAC: 12 January 2022 (AEDT), 11 January 2022 (PST)

• EMEA: 12 January 2022

• NA: 13 January 2022

Changes¶

• TLS 1.0 and 1.1 are no longer supported by default for JDBC driver connections
  Private Agents 10.47 and later no longer support TLS 1.0 or 1.1 for JDBC driver connections to database endpoints by default.

  If a database endpoint no longer works after an upgrade to a 10.47 or later agent, add enabledTLSProtocols=TLSv1.2 to the database connection string in Cloud Studio or Design Studio to force TLS 1.2 to be used (provided the protocol version is supported by the database endpoint).

  On Private Agents, if TLS 1.2 is not supported by the database endpoint, TLS 1.0 or 1.1 can be re-enabled (though not recommended) on Private Agents by removing TLSv1 or TLSv1.1 from the jdk.tls.disabledAlgorithms security property in the Private Agent java.security configuration file, which is located in these default directories:

  • Windows: C:\Program Files\Jitterbit Agent\jre\lib\security

  • Linux: /opt/jitterbit/jre/lib/security

Fixes¶

• Windows Quiet Agent Installer script version is now correct
  The Windows Quiet Agent Installer script config64.ps1 now has the appropriate executable version in the Agent_install_file field. Previously, you needed to edit the script to correct the version.

10.46¶

There was no 10.46 Private Agent release.

10.45¶

The 10.45 release date is by region:

• APAC: 8 December 2021 (AEDT), 7 December 2021 (PST)

• EMEA: 8 December 2021

• NA: 9 December 2021

Fixes¶

• Windows Quiet Agent Installer no longer produces a database error
  The Windows Quiet Agent Installer now succeeds instead of producing a database connection error under certain circumstances.

10.44¶

The 10.44 release date is by region:

• APAC: 04 November 2021 (AEDT), November 3, 2021 (PDT)

• EMEA: 04 November 2021

• NA: November 8, 2021

Enhancements¶

• Support for Salesforce API version 52
  Salesforce API version 52 is now supported for these connectors:

  • The Cloud Studio Salesforce, Salesforce Service Cloud, and ServiceMax connectors use API version 52 automatically with the use of a 10.44 agent.

  • The Design Studio Salesforce connector provides the option to use API version 52 with the use of both a 10.44 agent and 10.44 version of Design Studio. When opening an existing Design Studio project that uses this connector and meets both of these version requirements, you will be prompted to upgrade to Salesforce API version 52.

Fixes¶

• Agent stability improved
  When an agent's maximum number of PostgreSQL connections is reached, it is now more likely to recover rather than require a restart of Jitterbit Services.

10.43¶

The 10.43 release date is by region:

• APAC: 14 October 2021 (AEDT), October 13, 2021 (PDT)

• EMEA: 14 October 2021

• NA: October 18, 2021

Fixes¶

• Source files are now deleted as appropriate
  When archiving data using the After Processing option Delete File on a file-based source in combination with the Compression option Compress Target Files on a file-based target, all matching source files are now deleted instead of only one of the source files.

• PgBouncer configuration is now used
  During installation of a 64-bit Windows Private Agent, in some cases Jitterbit Services would connect to PostgreSQL directly instead of using the PgBouncer configuration. This issue has been fixed.

• Drivers are now reported correctly in the configuration file
  After doing an advanced install of a 64-bit Windows Private Agent where PostgreSQL is already installed, the correct PostgreSQL driver information is now reported in the Private Agent configuration file.

10.42¶

The 10.42 release date is by region:

• APAC: 23 September 2021 (AEST), September 22, 2021 (PDT)

• EMEA: 23 September 2021

• NA: September 27, 2021

New Features¶

• New Private Agent settings
  New settings are available in the Private Agent configuration file (jitterbit.conf) for enabling timeout of operations triggered by APIs and for logging of API calls:

  • EnableApiTimeout: Set to true for operations triggered by API Manager APIs to use the operation timeout settings set in Cloud Studio or Design Studio. The default is false.

  • APIOperationLogging: Set to true for logs that record the start of an API call and the time elapsed to be included in the agent's jitterbit.log file. The default is false. Be aware that turning on this setting will generate at least four additional lines for each API call, which can result in a very large number of logs.

• Windows Quiet Agent Installer (x64)
  A quiet installer for Windows 64-bit Private Agents is now available to download. The installer uses a script for an unassisted install.

Enhancements¶

• Support for Salesforce API version 51
  Salesforce API version 51 is now supported for these connectors:

  • The Cloud Studio Salesforce, Salesforce Service Cloud, and ServiceMax connectors use API version 51 automatically with the use of a 10.42 agent.

  • The Design Studio Salesforce connector provides the option to use API version 51 with the use of both a 10.42 agent and 10.42 version of Design Studio. When opening an existing Design Studio project that uses this connector and meets both of these version requirements, you will be prompted to upgrade to Salesforce API version 51.

Changes¶

• Change to the DbExecute function reverted
  The change made to the DbExecute function in the 10.40 release has been reverted. The DbExecute function again works the same way as it did prior to 10.40.

  Note

  Current projects with this scenario will be affected with a Private Agent upgrade from 10.40 or 10.41 to 10.42. Projects using an agent 10.39 or lower will be unaffected.

10.41¶

The 10.41 release date is by region:

• APAC: 02 September 2021 (AEST), September 1, 2021 (PDT)

• EMEA: 02 September 2021

• NA: September 7, 2021

Fixes¶

• Private Agent logs can again be downloaded
  All types of Private Agent logs are again able to be downloaded from the Management Console Agents > Agents page. Previously, only the debug logs were successfully downloaded.

10.40¶

The 10.40 release date is by region:

• APAC: 12 August 2021 (AEST), August 11, 2021 (PDT)

• EMEA: 12 August 2021

• NA: August 16, 2021

Enhancements¶

• Option to set the time zone for schedules
  You can now specify the time zone in which all schedules across an organization will run. This option is set in the Management Console from an organization's policies and requires agent version 10.40 or later.

Changes¶

• DbExecute() now returns a record set
  Using the DbExecute() function via JDBC to call a stored procedure that returns multiple results now returns a record set. Previously, only the first result set was returned. That behavior is unchanged when connecting via ODBC.

  Warning

  Current projects with this scenario will be affected with an agent upgrade to 10.40. For example, a current script expecting an empty result in this scenario will now return a record set.

Fixes¶

• Proxy exclusions now work with a Private API Gateway
  The proxy exclusion list set by the command --set-http-proxy-exceptions in the Private Agent configuration utility now applies to a Private API Gateway.

10.39¶

The 10.39 release date is by region:

• APAC: 22 July 2021 (AEST), July 21, 2021 (PDT)

• EMEA: 22 July 2021

• NA: July 26, 2021

Fixes¶

• PostgreSQL database is no longer reinitialized on Linux Private Agents
  The PostgreSQL database is no longer reinitialized when upgrading from a 10.37 Linux Private Agent. Note that the PostgreSQL database will still be reinitialized when upgrading from a pre-10.37 version to a version that is 10.39 or later. For additional details, see the release note Important PostgreSQL database upgrade notice in the 10.37 release notes.

10.38¶

The 10.38 release date is by region:

• APAC: 1 July 2021 (AEST), July 2, 2021 (PDT)

• EMEA: 6 July 2021

• NA: July 7, 2021

Fixes¶

• Double() function now works correctly
  The Double() function now correctly converts a value to a double (instead of to an integer) on 64-bit Linux Private Agents. Windows agents and 32-bit agents were unaffected by this error.

10.36.1.5 Patch Release¶

This patch was release to the APAC, EMEA, and NA regions on June 2, 2021.

Fixes¶

• Improvements and fixes to agents
  Environments and agent groups now sync more efficiently, sending messages to logs quicker, and improving Private Agent performance and resilience. This feature requires a 10.36.1.5 or later Agent.

10.36¶

The 10.36 release date is by region:

• APAC: Released 20 May 2021 (AEST), May 19, 2021 (PDT)

• EMEA: Released 20 May 2021

• NA: Released May 24, 2021

Changes¶

• Default settings change for a 64-bit Linux agent install
  Changes to the 64-bit Linux agent install default settings now make the agent run more efficiently.

• Agents can be stopped from receiving new requests
  Added functionality to stop an agent from receiving new requests while still continuing to run. This is useful when an agent needs to catch up to current requests before receiving additional requests. This feature requires a 10.36 Private Agent.

Enhancements¶

• NetSuite: Retry option for timeout
  The Retry on Concurrent Exception setting available in a Cloud Studio NetSuite connection now also applies to timeout exceptions when using Private Agents 10.36 or later. In addition, a new Enable Retry Option setting in a Design Studio NetSuite endpoint is available in Design Studio 10.36 or later. The Design Studio retry setting applies to concurrent exceptions with Private Agents 10.24 or later, and also to timeout exceptions with Private Agents 10.36 or later.

Fixes¶

• HMAC-SHA256 Generator plugin now handles special characters
  The HMAC-SHA256 Generator plugin can now use special characters such as carriage returns. Use the parameter $Jitterbit.HMACSHA256.Base64EncodedMessage set to true.
• The POP3 File Reader plugin accepts special characters
  Special characters in an attachment name no longer cause errors with the POP3 File Reader plugin. Those using Private Agents can associate the latest version of the plugin from the Management Console > Plugins page.

10.34¶

The 10.34 release date is by region:

• APAC: Released 8 April 2021 (AEST), April 7, 2021 (PDT)

• EMEA: Released 8 April 2021

• NA: Released April 12, 2021

Fixes¶

HTTP: Retry option now recovers from 500, 502, 503, and 504 errors
When configuring an HTTP connection, if the Retry option is selected and you use a 10.34 or later Private Agent, the activity now recovers from 500, 502, 503, and 504 errors and retries the activity.

10.33¶

The 10.33 release date is by region:

• APAC: Released 18 March 2021 (AEDT), 17 March 2021 (PDT)

• EMEA: Released 18 March 2021

• NA: Released March 22, 2021

This version includes general updates and fixes to improve the agent.

10.32¶

The 10.32 release date is by region:

• APAC: Released 4 March 2021 (AEDT), 3 March 2021 (PST)

• EMEA: Released 4 March 2021

• NA: Released March 8, 2021

This version includes general updates and fixes to improve the agent.

10.31¶

The 10.31 release date is by region:

• APAC: Released 3 February 2021

• EMEA: Released 4 February 2021

• NA: Released February 8, 2021

Fixes¶

• Windows Agent: 64-bit upgrade error
  We have resolved an error related to PostgreSQL entries in the Windows Registry found when upgrading a Windows Private Agent from 32-bit to 64-bit.

10.30¶

The 10.30 release date is by region:

• APAC: Released 20 January 2021

• EMEA: Released 21 January 2021

• NA: Released January 25, 2021

This version includes general updates and fixes to improve the agent.

10.29¶

The 10.29 release date is by region:

• APAC: Released 06 January 2021

• EMEA: Released 07 January 2021

• NA: Released January 11, 2021

Enhancements¶

• SOAP: Ability to retry a request added
  New retry functionality is available for the SOAP connection configuration. Selecting Retry allows you to set the retry interval in seconds and the maximum number of retries. This functionality requires a Private Agent 10.29 or later.

10.28¶

The 10.28 release date is by region:

• APAC: Released 02 December 2020

• EMEA: Released 03 December 2020

• NA: Released December 07, 2020

Enhancements¶

• Salesforce API version 50 is now supported
  The Cloud Studio Salesforce and ServiceMax connectors and the Design Studio Salesforce connector now support Salesforce API version 50.

  • Cloud Studio uses the new API version automatically with the use of a 10.28 agent.

  • Design Studio provides the option to use the new API version with the use of both a 10.28 agent and 10.28 version of Design Studio. When opening an existing Design Studio project that uses this connector and meets both of these version requirements, you will be prompted to upgrade to Salesforce API version 50.

• Private Agent: Linux installation has been upgraded to support Ubuntu 18.04 LTS
  Linux Private Agent now supports Ubuntu 14.04 LTS, Ubuntu 16.04 LTS, and Ubuntu 18.04 LTS.

10.27¶

The 10.27 release date is by region:

• APAC: Released 11 November 2020

• EMEA: Released 12 November 2020

• NA: Released November 16, 2020

Enhancements¶

• NetSuite: Support for WSDL version 2020.2
  We have verified Cloud Studio and Design Studio 10.26 with NetSuite WSDL version 2020.2 using agents 10.26 and higher.

10.26¶

• APAC: 21 October 2020

• EMEA: 22 October 2020

• NA: October 26, 2020

Enhancements¶

• Added an agent configuration option to remove extra linefeeds
  When using a transformation to post, the content length may be read incorrectly, causing the post to be rejected. Instead of using the Jitterbit variable $jitterbit.target.http.remove_trailing_linebreaks=true in a script, you can make a configuration change to the Private Agent. In the jitterbit.conf file, set TargetHttpRemoveTrailingLinebreaks to true. This configuration change requires an agent version 10.26 or later.

Fixes¶

• TLS 1.0 support for agents 10.5 and later
  We fixed an issue with an HTTP target in Design Studio, where selecting TLS 1.0 under Advanced SSL Version in the Advanced HTTP Properties dialog box was ignored with agent versions 10.5 or later.

10.25¶

• APAC: 30 September 2020

• EMEA: 1 October 2020

• NA: October 5, 2020

Fixes¶

• NetSuite: Custom fields no longer disappear from transformation after refreshing schema
  Due to activity optimization for NetSuite in a prior release, custom fields would disappear after refreshing the schema. This has been fixed.

10.24¶

• APAC: 9 September 2020

• EMEA: 10 September 2020

• NA: September 14, 2020

Fixes¶

• NetSuite: Custom segments now work with operations (only for Private Agents)
  Fixed an issue with NetSuite custom segments where NetSuite returned segment names with a suffix attached, causing an error. A Private Agent version 10.24 or higher is required for this fix.

10.23.1¶

• APAC: 26 August 2020

• EMEA: 27 August 2020

• NA: Released August 28, 2020

Changes¶

• HTTP client updated
  The HTTP client used by agents has been updated from version 4.5.2 to 4.5.3, which provides access to Kerberos authentication. Connector SDK developers can take advantage of this feature when creating connectors.

10.23¶

• APAC: 19 August 2020

• EMEA: 20 August 2020

• NA: August 24, 2020

Changes¶

• HTTP client updated for Private Agents
  The HTTP client used by agents has been updated from version 4.5.2 to 4.5.3, which provides access to Kerberos authentication. Connector SDK developers can take advantage of this feature when creating connectors.

Enhancements¶

• Salesforce API version 49 is now supported
  The Cloud Studio Salesforce and ServiceMax connectors and the Design Studio Salesforce connector now support Salesforce API version 49.

  • Cloud Studio uses the new API version automatically with the use of a 10.23 agent.

  • Design Studio provides the option to use the new API version with the use of both a 10.23 agent and 10.23 version of Design Studio. When opening an existing Design Studio project that uses this connector and meets both of these version requirements, you will be prompted to upgrade to Salesforce API version 49.

10.22¶

• APAC: 29 July 2020

• EMEA: 3 August 2020

• NA: August 4, 2020

Fixes¶

• Fixed an issue with the Agent scheduler service
  In some cases, the PostgreSQL connection closed. The Private Agent then failed and scheduled operations did not run. Errors resulting from this were reported in the log. Now, the agent will attempt to open a new connection to run the scheduled operations.

10.21¶

• APAC: 8 July 2020

• EMEA: 9 July 2020

• NA: July 13, 2020

Enhancements¶

• FTP sources and targets support special character encoding
  To support encoded URLs sent to and received from FTP servers, two new script variables have been introduced: $jitterbit.source.ftp.encode_url and $jitterbit.target.ftp.encode_url.

10.20¶

• APAC: 17 June 2020

• EMEA: 18 June 2020

• NA: June 22, 2020

10.19¶

• APAC: 27 May 2020

• EMEA: 28 May 2020

• NA: June 1, 2020

Fixes¶

• Intermittent errors with Linux 64-bit private agents resolved
  With earlier 64-bit Linux private agents, intermittent errors and segmentation faults occurred. Upgrade to a 10.19 private agent to avoid these errors.

• Files claimed to be missing during a deploy or agent sync can be recovered
  In some cases you may receive an error asserting that files are missing. You may be able to recover these files by redeploying the project.

10.18¶

• APAC: 06 May 2020

• EMEA: 07 May 2020

• NA: May 11, 2020

New Features¶

• Linux Red Hat non-root agent installation available
  Non-root Linux Red Hat 32-bit and 64-bit agents are now available from the Management Console Downloads page.

• New rule to delete result files older than 14 days
  A new rule was added to CleanupRules.xml to delete result files after 14 days in order to conserve disk space.

Enhancements¶

• Percent-encoded special characters now allowed in filenames with FTP/SFTP
  You can now use percent-encoding in filenames to represent control and special characters with FTP and SFTP transfers (Cloud Studio) and FTP Site Sources and FTP Site Targets (Design Studio).

• XML to JSON transformations can be set to ignore errors
  Setting the Jitterbit variable $jitterbit.operation.chunking.warn_on_error to true will ignore an XML to JSON file transformation error where the XML file has an empty chunk.

Fixes¶

• Success operations can be set to run without matching source files
  Operations now honor the checkbox Run Success Operation even if there are no matching source files in the Operation Options dialog box.

10.17¶

• APAC: 15 April 2020

• EMEA: 16 April 2020

• NA: April 20, 2020

This version included general updates and fixes to improve the agent.

10.16¶

• APAC: 25 March 2020

• EMEA: 26 March 2020

• NA: April 1, 2020

Changes¶

• PostgreSQL configuration defaults updated
  To resolve stability issues, the PostgreSQL configuration file postgresql.conf for 32-bit Linux agents now sets the default max_connections to 400 instead of 100 when installed for the first time.

10.15¶

• APAC: 4 March 2020

• EMEA: 5 March 2020

• NA: March 9, 2020

Changes¶

• MSSQL ODBC database sources can now use a parameterized GUID as a key for table joins
  When using Cloud Studio or Design Studio with a Private Agent to join tables using an MSSQL ODBC database source, parameterized GUIDs can now be used as the key between the tables. Previously, the join would cause an error and the operation would fail.

10.14¶

• APAC: 12 February 2020

• EMEA: 13 February 2020

• NA: February 18, 2020

Changes¶

• PostgreSQL configuration defaults updated
  The PostgreSQL configuration file postgresql.conf for 64-bit agents now sets the default max_connections to 400 (instead of the previous limit of 100). In addition, the default checkpoint_timeout for 32-bit and 64-bit agents is now 1 hour instead of 5 minutes.

Enhancements¶

• Windows Server 2019 is now supported
  Windows Server 2019 is now supported for Private Agents.

10.13¶

• APAC: 22 January 2020

• EMEA: 23 January 2020

• NA: January 27, 2020

Fixes¶

• 64-bit Windows Private Agents can now accept gzip-encoded HTTP responses
  When using a 64-bit Windows Private Agent with an HTTP endpoint that is configured to accept gzip-encoded responses, the agent now correctly decompresses the HTTP response. Previously, the operation would fail.

10.12¶

• APAC: 6 January 2020

• EMEA: 7 January 2020

• NA: January 9, 2020

New Features¶

• Jitterbit Google authentication plugin
  A new plugin, Jitterbit OAuth - Google - Service Account, is available that authenticates with Google's implementation of OAuth 2 for Google service accounts, placing the auth token in the variable google.oauth.token.auth and the expiration number of seconds in the variable google.oauth.token.expireSeconds. The new plugin can be installed on Private Agents through the Management Console Customizations > Plugins page.

Changes¶

• PostgreSQL database driver updated to 9.4
  The PostgreSQL JDBC database driver that is packaged with Private Agents has been upgraded from PostgreSQL JDBC Driver 9.1 to 9.4.

Fixes¶

• Linux Agents processing web services with a SOAP fault now report the correct status
  When using a Linux Private Agent to run a SOAP-based web service operation, the operation status is now correctly reported as a SOAP Fault as applicable. Previously, as of version 10.1 Linux Agents, the operation status for a SOAP fault was incorrectly being reported as an Error status. This issue affected operations using SOAP endpoints in Cloud Studio, and Web Service Method and Workday endpoints in Design Studio.

• Data syncing errors related to API calls no longer occur
  When running operations that call an API, intermittent 400 errors related to data syncing no longer occur.

10.11¶

• APAC: 11 December 2019

• EMEA: 12 December 2019

• NA: December 16, 2019

Enhancements¶

• Salesforce API version 47 is now supported
  The Design Studio Salesforce connector now supports Salesforce API version 47 with the use of a version 10.11 or higher agent and 10.11 or higher version of Design Studio. When opening an existing Design Studio project that uses this connector and meets both of these version requirements, you will be prompted to upgrade to Salesforce API version 47. This upgrade from version 45 includes new objects supported in both versions 46 and 47.

Fixes¶

• FTP/HTTP transfer for large files now works
  When using Cloud Studio or Design Studio to upload a file greater than 2 GB to an FTP or HTTP endpoint, the transfer is now successful. Previously, you may have received an error regarding a libcurl function. The issue was caused by library upgrades in Harmony agent version 8.29 and has been resolved with 10.11 and higher agents.

10.10¶

• APAC: 25 November 2019

• EMEA: 2 December 2019

• NA: December 3, 2019

Changes¶

• Windows Private Agents now include the 2019 Microsoft Visual C++ Redistributable
  The version of Visual C++ Redistributable for Visual Studio that comes packaged with 32-bit and 64-bit Windows Private Agents has been upgraded from 2015 to 2019.

Enhancements¶

• OASIS WSS plugin now supports WS-Addressing SOAP headers
  A new version of the OASIS Web Service Security plugin (1.3.0.0) allows you to specify the Web Services Addressing SOAP header elements wsa:To and wsa:Action by defining these parameters using global variables. The updated plugin can be installed on Private Agents through the Management Console Customizations > Plugins page.

• PrependData plugin can now be used with Linux Agents
  The current versions of the PrependData plugin (1.1.1.0 and 1.3.0.0) can now be used with Linux Private Agents. The plugin can be installed on Linux Private Agents through the Management Console Customizations > Plugins page.

10.9¶

• APAC: 04 November 2019

• EMEA: 05 November 2019

• NA: November 7, 2019

Changes¶

• Linux RPM-based Private Agents now require python2
  The Linux Private Agent RPM package dependency for Python has been changed from python to python2.

Fixes¶

• 64-bit Windows agent installation no longer fails
  When installing a 64-bit Windows Private Agent, installation on a machine that already has a version of Visual C++ Redistributable for Visual Studio higher than 2015 is now successful.
• FormatDate() can now handle milliseconds and a time zone
  When using the Jitterbit function FormatDate(), you can now format source dates provided in the form of YYYYMMDDHHMMSS._SSSZ_, where _SSS_ indicates the milliseconds and _Z_ indicates the time zone, which are seen with certain LDAP implementations.

10.8¶

• APAC: 09 October 2019

• EMEA: 10 October 2019

• NA: October 14, 2019

New Features¶

• 64-bit Windows and Linux Private Agents
  Windows and Linux Private Agents are now available in a 64-bit version. Note:
  • Existing 32-bit agent versions must be uninstalled prior to upgrading (see instructions for Windows or Linux).
  • Existing PostgreSQL and PostgreSQL driver (psqlODBC or pODBC) installations must be uninstalled.
  • Existing 32-bit ODBC drivers are not supported.
  • Private Agents remain available in a 32-bit version.

Fixes¶

• Global variables used in endpoints are now recognized in JavaScript
  Global variables that are used within endpoint configuration fields in Design Studio or Cloud Studio are now recognized when accessed within a Jitterbit function called from JavaScript. Previously, use of JavaScript Jitterbit functions such as Jitterbit.ReadFile and Jitterbit.WriteFile ignored global variables used in an endpoint configuration.

10.7¶

• APAC: 18 September 2019

• EMEA: 19 September 2019

• NA: September 23, 2019

Enhancements¶

• Drain stop now waits for APIs to finish running
  When an agent drain stop is initiated, the agent will now wait 180 seconds for any APIs to finish running before the drain stop is completed. For Private Agents, the wait time can be configured within the jitterbit-agent-config.properties file by setting agent.drainstop.api.wait equal to the desired number of seconds.

Fixes¶

• Design Studio JMS Listener now reconnects after interruption
  When using a Design Studio JMS Listen operation, if the connection to the JMS server is interrupted, the agent will try to reconnect to the JMS server every 1 minute, for a maximum of 120 retries. Previously, the listener wouldn't recover after JMS server downtime.

10.6¶

• APAC: 03 September 2019

• EMEA: 04 September 2019

• NA: September 5, 2019

New Features¶

• Jitterbit Multipart Pipeline Plugin
  A new plugin is available that allows multiple files to be submitted in a Jitterbit Custom API call, providing support for message bodies with multiple parts (MIME). The new plugin can be installed on Private Agents through the Management Console Customizations > Plugins page.

Changes¶

• PgBouncer is now included with Linux Private Agents
  PgBouncer, a connection pooling application for PostgreSQL, is now part of the Linux Private Agent installation package and will be configured automatically upon agent installation or upgrade.
• Updated libraries resolve issues with large file transfers
  The libraries libcurl and libssh2 have been upgraded to the latest versions, resolving issues customers may have experienced with transferring large files, particularly when using AWS SFTP servers.

Enhancements¶

• Base64Decode() function is now faster
  The Base64Decode()function now processes large files (multiple MB) more quickly.

Fixes¶

• Scheduled operations now run as expected
  Operations configured to run on a schedule now run reliably. Previously, the scheduler service on the agent would crash intermittently without recovering, leading to scheduled operations being skipped until the service was restarted.
• AWS S3 Create plugin now supports KMS encryption
  An updated version of Jitterbit's AWS S3 Create plugin (1.0.1.0) can now be used with S3 buckets using Server-Side Encryption with AWS KMS-Managed Keys (SSE-KMS). Version 1.0.1.0 of the plugin can be installed on Private Agents through the Management Console Customizations > Plugins page.

10.5¶

• APAC: 07 August 2019

• EMEA: 08 August 2019

• NA: Released August 12, 2019

This version includes general updates and fixes to improve the agent.

10.4¶

• APAC: 17 July 2019

• EMEA: 18 July 2019

• NA: July 22, 2019

Enhancements¶

• NetSuite 2019.1 WSDL is now supported
  Support for NetSuite's 2019.1 WSDL is now available for use with Jitterbit's NetSuite connectors. To use the new WSDL, specify its URL during configuration of a Cloud Studio NetSuite connection or Design Studio NetSuite endpoint. Jitterbit continues to be Built for NetSuite_ (BFN) certified.

Fixes¶

• Excel worksheets named with single quotes are now supported
  Those using a Private Agent with either Cloud Studio or Design Studio can now connect (using an ODBC Excel database driver) to Excel worksheets that contain an apostrophe (a single quote) in the worksheet name. Previously, worksheets named in this manner were not appearing within the table selection screen.

10.3¶

• APAC: 26 June 2019

• EMEA: 8 July 2019

• NA: July 10, 2019

Enhancements¶

• Design Studio Siebel queries now support Business Component dynamic activation
  You can now use the Design Studio Siebel Connector with a Private Agent version 10.3 or higher to fetch data from an inactive Business Component field. To do so, a new field called ActiveBCField is now included in the query request schema, which you can use to pass the Business Component field names that need to be active.

Fixes¶

• Installation on Windows no longer fails
  When installing a Windows Private Agent, installation on a machine that already has a version of Visual C++ Redistributable for Visual Studio higher than 2015 is now successful.
• Escaping characters in pipe-delimited schemas now works
  When configuring a pipe-delimited custom schema in Cloud Studio or Design Studio, the option to convert escape sequences now works as expected. Previously, using this option with such a schema would cause the operation to fail.
• An erroneous error no longer appears when testing a Cloud Studio connection
  When testing a connection's configuration in Cloud Studio using the Test button, you will no longer see an erroneous error message indicating the connector is being downloaded across agents when the connection was actually successful.
• Cloud Studio connectors now work on Ubuntu Private Agents
  You can now use certain application-specific Cloud Studio connectors with Ubuntu-based Linux Private Agents. Previously, when testing a connection's configuration using the Test button, an erroneous error message indicating the connector was being downloaded across agents would be displayed indefinitely.

10.2¶

• APAC: 05 June 2019

• EMEA: 06 June 2019

• NA: June 10, 2019

Fixes¶

• SAP RFC multi-layer structures are now supported
  You can now use RFC multi-layer structures (nested tables) with the Design Studio SAP Connector (both ECC and HANA) using an agent version 10.2 or higher. Previously, the structure was displayed in the transformation, but the operation would fail at runtime.

10.1¶

• APAC: 15 May 2019

• EMEA: 16 May 2019

• NA: May 20, 2019

New Features¶

• New Cloud Studio connectors
  New Cloud Studio connectors for Evernote, Google Drive, HubSpot, Magento, and SugarCRM are now available to use with agents version 10.1 or higher. The new connectors can be accessed on the right side of the project designer from the design component palette.

Changes¶

• The Cloud Studio Cherwell connector no longer works with 10.0 agents
  A change made to the Cherwell connector in Cloud Studio means it is no longer compatible with 10.0 agents. If using the Cherwell connector, please upgrade to 10.1 or higher agents.

Fixes¶

• The SendEmail() function now supports multi-byte characters
  The Jitterbit Script function SendEmail() in Cloud Studio or Design Studio can now be used to send emails containing multi-byte characters.

10.0¶

• EMEA: 04 April 2019

• NA: April 8, 2019

Fixes¶

• Fixed an issue with the SAP Connector driver when it is installed for the first time on a Harmony Linux Agent

9.9¶

• EMEA: 07 March 2019

• NA: March 11, 2019

Enhancements¶

• LDAP passwords can be set and updated in Jitterbit Script using the LDAP functions.
• The maximum iterations for JavaScript loops can now be set in the jitterbit.conf file. In the [Settings] section, specify JavaScriptMaxIterations=_limit_ where _limit_ is the maximum number of iterations to be permitted.
• The Java distribution included in the Harmony Linux Agent has been changed from the Oracle JRE to the AdoptOpenJDK JRE.
• The Java distribution included in the Harmony Windows Agent has been changed from the Oracle JRE to the AdoptOpenJDK JRE.
• The PostgreSQL instance bundled in the Windows Private Agent installer has been upgraded to version 9.6.11.

Fixes¶

• Fixed an issue with the architecture of the third-party SAP JCo (Java Connector) library included in the Harmony Linux Agent.
• Fixed an issue with the installation of the AdoptOpenJDK JRE by the Harmony Windows Agent installer that prevented certain plugins from functioning.
• An issue with the Jitterbit global variable jitterbit.source.preserve_char_whitespace not being honored when transforming from CSV to JSON or from an Oracle Database to XML has been fixed. Setting jitterbit.source.preserve_char_whitespace=true means white space will be preserved and won't be trimmed from the beginning and end of strings in the source. The default value for this variable is "false", and white space will be trimmed from the beginning and end of strings in the source. This default value will be used if the variable has not been explicitly set. The default behavior is unchanged from prior releases.

9.8¶

• EMEA: 07 February 2019

• NA: February 11, 2019

9.7¶

• EMEA: 10 January 2019

• NA: January 14, 2019

Enhancements¶

• Boolean types are now supported for OData when using SQL Server, MySQL, or PostgreSQL.

• SAP fields defined as doubles now work correctly when used in OData APIs.

Fixes¶

• Fixed an issue with retrieval of the NetSuite custom segments to avoid timeout errors while generating or refreshing the schemas.
• Fixed an issue in the JMS Connector with messages that are missing a JMS destination header.

9.6¶

• EMEA: 12 December 2018

• NA: December 12, 2018

Fixes¶

• Fixed an issue with the parsing of IDoc types. It is now enabled by default and can be disabled in a Private Agent by setting the jitterbit.conf [TransformationEngine] section variable DefaultEntityResolution=false.

9.5¶

• EMEA: 08 November 2018

• NA: November 12, 2018

Fixes¶

• Resolved timeout issues when using JDBC to retrieve a large number of tables. Increased the defaultjitterbit.conf agent timeout values to match the messaging limits. Note: this affects fresh installs only.
• Fixed an Issue with the input parameter of the CVTDate() script function being set to an empty value. The CVTDate() function now successfully converts each input data value to the appropriate date and does not set any input to an empty value.
• Fixed an issue with retrieval of the NetSuite custom segments to avoid timeout errors while generating or refreshing the schemas.

9.4¶

• EMEA: 04 October 2018

• NA: October 8, 2018

New Features¶

• Added support for reading and writing a NetSuite custom segment and its fields.

  Note

  Accessing NetSuite custom segments requires Design Studio version 9.4 or higher and Private Agents running version 9.4 or higher. Using the NetSuite Connector, create any operation to work with the appropriate object. The custom segment will display within the 'customFieldList' in the transformation. The value for the custom segment will be present in the target upon running the operation.

9.3¶

• EMEA: 06 September 2018

• NA: September 10, 2018

New Features¶

• Added support for NetSuite conversion to TBA
  The authentication type of existing NetSuite endpoints can now be changed from single sign-on (SSO) to token-based authentication (TBA), allowing easy switching to TBA without requiring changes to the rest of your project. To configure, first enable TBA in NetSuite, then convert your NetSuite endpoint to use TBA. Design Studio 9.3.1 or higher and Agents 9.2 or higher are required to use this feature.
• Harmony Docker Agent
  Jitterbit now supports a Jitterbit Linux OS agent that is packaged in a Docker Container. Following the Docker standard approach to container deployment, you can deploy and run the Linux agent anywhere that Docker runs. A new Docker Agent version will be at the time a new version of the Jitterbit Private agents is released. The Docker Agent is public with available tags and instructions on installing found at https://hub.docker.com/r/jitterbit/agent.

Enhancements¶

• Added the SQL Server Microsoft JDBC Driver to the Jitterbit Agent.
  The SQL Server Microsoft JDBC Driver is now included in the private agent (Windows, Linux) as an alternative way to connect to SQL Server. This fixes a known Date type bug in the jTDS Driver.

Fixes¶

• Fixed an issue that created logs referring to [axis] when shutting down a private agent.
  Added resource handling improvements to Tomcat server for axis web-app shutdown. Private agents now shut down properly without any logs referring to [axis].
• Fixed an issue where you were unable to create an SAP RFC function.
  SAP Remote Function Call now utilizes the user created functions.
• Fixed an issue where a field is missing on the actual SAP request, which causes the operation to fail.
  The Agent transformation engine now generates the required XML tag if the element in the schema has 0 occurrences and contains a fixed attribute.

9.2¶

• EMEA: 02 August 2018

• NA: August 6, 2018

Enhancements¶

• NetSuite has certified our NetSuite Connector on the NetSuite "Sandbox2.0"
  For additional information on your NetSuite account and "Sandbox2.0" please see https://system.na3.netsuite.com/app/help/helpcenter.nl?fid=section_4609939018.html&whence=.

• Improved running a scheduled operation within an agent group containing more than one agent.
  Improved efficiency for updating the started status for a scheduled operation.

• Added support in the NetSuite Connector for SerializedAssemblyItem and LotNumberedAssemblyItem while doing a search on AssemblyItem.
  The SerializedaAsemblyItem and LotNumberedAssemblyItem now display in the response transformation of NetSuite Searches activity performed on the AssemblyItem object.

Fixes¶

• Fixed an issue that caused a "Failed to get files" error when syncing files from a FileStore.
  Fixed an issue when the name of a file that is created on a Mac contains characters that are invalid on a Windows machine. This was causing an invalid file to be created on the Windows machine and the invalid file then cannot be used. This in turn caused an error that prevented the Agent from running operations

9.1¶

• EMEA: 05 July 2018

• NA: July 9, 2018

New Features¶

• Added support for OData indexof() function. This function is available specifically for SQL Server.
  Theindexof() Function is now supported for OData queries when coupled with a SQL Server database.

Fixes¶

• Fixed an issue that caused email messages to fail on Linux (RPM) agents after upgrading to versions 8.29.5 or 8.30.
  Removed a run-time dependency that caused a conflict with the third-party libraries. When running on Linux (RPM) agents, email messages are now sent and received successfully.

• Fixed an issue where$jitterbit.netsuite.async returns the wrong data when running concurrent NetSuite operations.
  The variable $jitterbit.netsuite.async returns the correct data when running concurrent NetSuite operations.

• Fixed an issue in which the 9.0 Agent was not handling API-based Archive operations properly.
  When an archive operation uses an API source and API target, it tells the Jitterbit engine that it should have a source and target file even though the source is not used. The process assumed that if the body should take the place of a source file, then the $jitterbit.api.request (plain text body) and $jitterbit.api.request.body.* (URL encoded body) variables would not be needed. This broke the archive operations that rely on the variables but ignore the source. The fix is to require the $jitterbit.api.request and $jitterbit.api.request.body.* variables are always populated, even if they are not needed.

• Stopping the Tomcat Service can intermittently leave the Agent in an unstable state.
  Improved the Tomcat shutdown process so that the next restart is working properly, and the Agent is stable.

• OData API queries would return an error indicating the URL is not valid when the queries contained the pound character (#).
  OData APIs now encode the pound character (#) correctly.

• OData DateTime parameter was not working with "T" in the DateTime timestamp.
  The OData DateTime timestamp now converts properly to a standard datetime when utilizing an OData Entity.

• Issue with SQL Server database Date type not being recognized correctly as a Date type with the default SQL Server driver.
  Date datatype is now supported when utilizing an OData Entity with a SQL Server database.

• Global variables were not being passed to JavaScript in 'On Success' and 'On Failure' operations.
  Jitterbit Global Variables are now passed successfully to JavaScript in 'On Success' and 'On Failure' operations.

• NetSuite objects TransferOrder and InventoryTransfer are not available in NetSuite Search.
  Added support for performing NetSuite Search on the TransferOrder and InventoryTansfer objects only when using Private Agents.

9.0¶

• EMEA: 17 May 2018

• NA: May 20, 2018

Enhancements¶

• Added the ability to log 504 timed out API operations.
  API requests that result in a 504 timeout error message can now be tracked to see the actual result of the underlying operation, along with log information.

• Added the ability to detect target types from the structure of the operation.
  The Agent will now automatically set the 'Content-Type' header for Custom APIs that use JSON or XML response structures.

• Added an operation monitor to log and correct the status of non-running operations.
  The Agent now has built-in operation monitoring that will correct the status of an operation in certain scenarios.

Fixes¶

• Fixed an exception error from the Agent when the proxy credentials include the '%' character.
  The Agent will not generate an error when using the '%', '&' or '=' characters in proxy credentials.

• Fixed operation chaining to continue when the DEBUG folder is not copied correctly.
  The operation chain will now continue on through the 'On Success' processing even when the DEBUG folder is not copied correctly.

8.30¶

• EMEA: 12 April 2018

• NA: April 12, 2018

New Features¶

• Implemented the ability to perform lookup within JMS Queue.
  JMS Connector now supports JNDI context lookup for JMS destinations when using Poll, Browse and Publish activities.
• Added the option to write an FTP source file to a separate archive folder after processing.
  Added 'Use Success Folder' and 'Use Error Folder' under Options for an FTP source file. Configure an FTP source file to be archived in a separate "success" folder after successful processing to the primary target destination(s) or to a separate "error" folder if not successful.
• Added the option to write a local file target to a separate archive folder after processing.
  Added 'Use Success Folder' and 'Use Error Folder' under Options for a local file target. Configure a local file target to be archived in a separate "success" folder after successful processing to the primary target destination(s) or to a separate "error" folder if not successful.
• Added the option to write a local file source to a separate archive folder after processing.
  Added 'Use Success Folder' and 'Use Error Folder' under Options for a local file source. Configure a local file source to be archived in a separate "success" folder after successful processing to the primary target destination(s) or to a separate "error" folder if not successful.
• QuickBooks: OAuth 2.0 is now supported.
  The Design Studio QuickBooks connector has been updated to support OAuth 2.0 authentication while remaining backward compatible with OAuth 1.0. QuickBooks OAuth 2.0 authentication is only supported using Private Agents.
• SAP S4 HANA Connector is now available in Design Studio.
  The SAP S4 HANA Connector is now accessible from Design Studio. You can find the SAP S4 HANA (on-premises) Connector in the Connector tree. The SAP S4 HANA connector is only supported using Private Agents.

Fixes¶

• Fixed the issue where the run time JSON is not parsing properly.
  When creating a JSON transformation that contains nested arrays, the JSON now processes properly.
• Fixed an issue on Linux where the Drain/Stop feature was not waiting for Log Sync before shutting down.
  Updated Drain/Stop features so that the status shows correctly and the Agents shutdown properly. When doing a drain stop, operations will now complete before the agent turns off. This fix will allow an agent to properly synchronize all operation instances with the Harmony Cloud.
• Fixed a critical error during temporary directory creation.
  Certain temporary directories and files will now be removed after each operation successfully completes.
• Fixed an issue causing debug statements to fill up logs.
  Removed a dependency so that the debug statements are working correctly, and excessive logging does not occur.
• Fixed an issue where an FTP archive target was not copied to the error folder path when using a Linux agent
  When the 'Use Error Folder' option has been set up in an FTP target, the archive file is now successfully created in the error folder path when an archive operation fails to run successfully on a Linux agent.
• Fixed an issue that was allowing archived files to be overwritten.
  When the 'Use Success Folder' or 'Use Error Folder' option are set up, the success or error archive files are now successfully written to a success folder when the operation is successful or to an error folder when the operation fails. The file names are written with an additional "_x" string appended to them sequentially to prevent overwriting previous files.

8.29¶

• EMEA: 22 February 2018

• NA: February 22, 2018

Enhancements¶

• Linux installation has been upgraded to support Ubuntu 16.04
  Linux Private Agent now supports Ubuntu 14.04 and Ubuntu 16.04. Ubuntu 12.04 is no longer supported.
• Security enhancements: Multiple upgrades
  Multiple updates have been made to improve stability and security of the system.
• Added a new notification email type when a new Private Agent version is available.
  A new Notification Type, Agent Available, has been added to the WMC Notifications page. The Agent Available notification may be set up to automatically send an email to a specified email address at the time a new Private Agent version is released.

Fixes¶

• Fixed an issue with theDateAdd() function where adding 12 months to any December date returned the incorrect year.
  Using the DateAdd() function to add 12 months to any December date now returns the correct date; returning a date exactly 1 year from the original date.

• Fixed an issue that causes a dictionary or array to become corrupt when the variable name contains a period and a JavaScript is run.
  When using JavaScript within Jitterbit, JavaScript will no longer process variables that contain a period when the variables are dictionaries or arrays.

• Fixed an error when running a SQL statement on a PostgreSQL database with an OID higher than int allows.
  A SQL statement will run successfully on a PostgreSQL database when an OID is higher than the integer data type allows.

8.28¶

No changes applicable to Private Agents.

8.27¶

• NA: December 14, 2017

Enhancements¶

• Additional special characters are now allowed in the username and password for the Private Agent's proxy.
  Additional special characters ("/", "%" or "&") are now allowed when configuring the username and password for the Private Agent's proxy.

Fixes¶

• Fixed an error that occurred when upgrading a Linux agent to version 8.26.
  The Linux build environment has been re-enabled to support backwards compatibility of up to minus one version from Centos release version 6.

8.26.1¶

• NA: September, 15 2017

Fixes¶

• A popup message will display during installation of the Agent if the previously installed version of PostgreSQL is lower than 9.3.
  When upgrading from an older version of Harmony, and skipping multiple versions to upgrade to the current version, the Agent upgrade installation will not complete if the installed version of PostgreSQL is lower than 9.3. A popup message will now be presented to the user advising to upgrade the PostgreSQL version to 9.3 first and then install the upgrade for Agent.

8.26.1¶

• NA: September, 15 2017

Fixes¶

• A popup message will display during installation of the Agent if the previously installed version of PostgreSQL is lower than 9.3.
  When upgrading from an older version of Harmony, and skipping multiple versions to upgrade to the current version, the Agent upgrade installation will not complete if the installed version of PostgreSQL is lower than 9.3. A popup message will now be presented to the user advising to upgrade the PostgreSQL version to 9.3 first and then install the upgrade for Agent.

8.25.1¶

No changes applicable to Private Agents.

8.25.0¶

No changes applicable to Private Agents.

8.24.2¶

• NA: June 19, 2017

New Features¶

• Support for JavaScript
  When creating a script as an operation step, you can now use either JavaScript or Jitterbit script language. The new JavaScript feature in Studio version 8.24.2 is compatible with Agent versions 8.24.0 or higher. Learn more in our JavaScript documentation.

8.24.1¶

• NA: June 12, 2017

Fixes¶

• Scripting: Issue with returned values fixed
  We have identified an issue with our latest release that impacts customers who have implemented RunScript calls where the return value is the result of a function call.

  When the return value in the script is a function call, the script returns a blank value. RunScript calls that return results from variables are not impacted.

  This incorrectly returns a blank value:

  num = 3.14;
  RoundToInt(num);
  

  This returns the expected value:

  num = 3.14;
  num = RoundToInt(num);
  num;
  

  This issue has been corrected in 8.24.1 Private Agent downloads. If you are running Private Agents and have not upgraded to version 8.24.0, you are not impacted.

  In order to resolve this issue, a different 8.24.0 fix related to the data type returned by the RunScript() function has been rolled back. For more information on the fix that was rolled back, see Fixes under 8.24.0 below.

8.24.0¶

• NA: June 9, 2017

Fixes¶

• Scripting: RunScript issues fixed related to data type, memory
  When using the RunScript() function, the value returned can now be a complex data type, such as dictionary or array. In addition, an issue has been fixed that previously resulted in an error related to memory.

  Note

  The portion of this fix related to data type returned by the RunScript() function was originally with 8.24.0, but has since been rolled back as part of 8.24.1.

8.23.2¶

No changes applicable to Private Agents.

8.23.0¶

• NA: May 26, 2017

Fixes¶

• Install experience improved for those already running PgBouncer
  When installing a Private Agent, Jitterbit will now automatically detect the port of an existing PgBouncer installation and re-register the service using another port. The PgBouncer application was integrated into the Agent install package as of version 8.22, and this fix provides a more seamless experience for users that already have the connection pooling application in use.

8.22.4¶

No changes applicable to Private Agents.

8.22.3¶

No changes applicable to Private Agents.

8.22.2¶

No changes applicable to Private Agents.

8.22.1¶

No changes applicable to Private Agents.

8.22.0¶

• NA: March 17, 2017

Enhancements¶

• Improved performance with integrated PgBouncer installation
  PgBouncer, a connection pooling application for PostgreSQL, has been integrated into the Agent install package. If you already have an existing installation of PgBouncer and experience issues upgrading, please contact support.

Fixes¶

• Private Agent: Shutdown port for Tomcat services changed to avoid conflicts
  The default shutdown port used by Jitterbit for Tomcat services has been changed so that it does not conflict with other applications that use Tomcat services configured with the same original default shutdown port.

8.21.0¶

No changes applicable to Private Agents.

8.20.0¶

• NA: January 27, 2017

Enhancement¶

• Milliseconds in DateTime fields are now retained
  Millisecond components of DateTime fields are no longer truncated when performing date and time script functions, database transformations, and database lookup functions. You can include milliseconds by adding "SSS" to your function in the standard format string, for example yyyy-mm-dd HH:MM:SS.SSS.
• Security enhancement: Library upgrades
  The FasterXML / Jackson JSON library was upgraded from version 2.6.1 to 2.8.5. The Commons Codec library was upgraded to version 1.10. These upgrades improve the security of the system.

Fixes¶

• Local JSON files can again be used for sample XSD structure
  When using JSON as the source for a new transformation, you are now able to successfully use a local copy of a JSON file as the sample file for an XSD structure.
• JDBC database without records no longer produces an error
  When using chunking (in Studio under Operation Options) with a JDBC database source, an operation error will no longer occur if no rows are returned from the database. Instead, the operation will complete successfully and the log message will indicate that no database rows are available, which is the same behavior as when not using chunking.
• Special characters now work properly with custom OData APIs
  When using your own OData API, characters in the URL are now fully decoded and are processed as intended. Previously, SQL queries were only partially decoded, causing issues when some special characters were used.
• CallStoredProcedure issue with non-alphanumeric characters resolved
  The CallStoredProcedure function available for JDBC no longer produces an error when output parameters contain certain non-alphanumeric characters.

8.19.0¶

• NA: January 6, 2017

New Feature¶

• MS Dynamics CRM: Support for 'listmember' object
  The MS Dynamics CRM Connector now provides support for the 'listmember' object during an MS CRM Create operation.

Fixes¶

• Salesforce: Functionality restored for Salesforce bulk query operations
  The previous 8.18.0 release created an issue causing Salesforce some bulk queries not to operate. This fix restores that functionality.
• NetSuite: Compatibility error resolved for imported NetSuite 2016.2 projects
  The previous 8.18.0 release created an issue resulting in a version compatibility error when importing a NetSuite 2016.2 project that had been created prior to version 8.18.0. This issue is now resolved.
• NetSuite: Support for asynchronous NetSuite search operations
  The NetSuite asynchronous function for bulk processing now works properly for NetSuite search operations. The asynchronous option for NetSuite search, as well as for other NetSuite operations, can be enabled by setting $jitterbit.netsuite.async=true.
• Clarizen: Querying multiple fields
  When performing a query using the Clarizen Connector, you can now select multiple fields. Previously, only one field at a time could be queried successfully.

Security Enhancement

• Library upgrade
  The Apache Commons BeanUtils library was upgraded to version 1.9.3, which improves security of the system.

8.18.10¶

No changes applicable to Private Agents.

8.18.0¶

• NA: November 3, 2016

New Features¶

• Option to add new configuration settings remotely
  You can now add new configuration settings in the Jitterbit config file remotely via the Web Management Console (WMC). This feature allows you to override default Private Agent settings, even if the particular setting was not previously set in the Agent configuration. To do this, first make sure you have remote Agent configuration enabled (Organizations > Actions > Organization Policies). Then go to the Jitterbit config file (Agent Groups > Actions > Jitterbit Config), where you will see a new Add button next to Edit. Here you can specify the new parameter and value, whether the parameter should be enabled, and the existing section to which the setting will be added.
• Scripting for Agent version name and ID, current project name
  You can now access the Agent version name and version ID using new script functions: GetAgentVersionName(), GetAgentVersionId(). These are consistent with the existing functions GetAgentName() and GetAgentId(). You can also now use the current project name in scripts by using $jitterbit.operation.project_name. This is a new system variable that holds the current project name when the operation is running.
• Improved support for XML \<any> element
  You can now use the XML \<any> element in an XML schema, including when defined as the middle sibling in an XML schema.

Improvements¶

• Notification of manual configuration changes
  If you have enabled remote Agent configuration and the Jitterbit config file becomes modified manually outside WMC, you will now see a warning icon and message icon displayed on the Agents and Agent Groups pages of the WMC. Clicking the message icon will open a popup with a detailed description of the warning. Note that manual changes to the config file will always override your existing configuration.
• Creating new file share directories (Linux)
  For those using a Private Agent on Linux, you can now specify target file share paths that do not yet exist. That is, the Linux Agent will no longer produce an error if the directory does not yet exist, and instead will create new file share directories as specified.
• Option to disable logging for Hosted HTTP Endpoints
  You now have the ability to disable operation logging for Hosted HTTP Endpoints, which allows for greater efficiency and throughput under load. To do this, edit the Jitterbit config file under the [HttpEndpoints] section to set EnableLogging = false.

Fixes¶

• Carriage returns and special character supported (OData API)
  For those using OData API, fields containing multiple carriage returns or certain special characters are now supported. These fields in OData results will no longer be truncated.
• GetUTCFormattedDataTime returns correct time
  The GetUTCFormattedDateTime function now returns the correct time for all standard U.S. timezones (PST, MST, CST, EST). Previously, the CST and PST timezones were returning results an hour off during Daylight Saving Time.

Security Enhancement¶

• OpenSSL and Apache Tomcat upgrades
  The Apache Tomcat version was upgraded to Version 8.0.36, which improves performance and security. The OpenSSL library was upgraded from 1.0.2h to 1.0.2j. This addresses all known OpenSSL vulnerabilities and improves the security of SSL connections made by the Agent.

8.17.0¶

• NA: September 23, 2016

New Feature¶

• Control over whitespace
  Whitespace for values within an XML source can now be preserved during the transformation to a target by setting "$jitterbit.source.xml.trim = false".

Improvements¶

• Support for null characters
  Support for null characters has been added to UTF-16 and UTF-32 character encoding sets for text sources and targets.
• Standardized character encoding (Salesforce)
  The character encoding behavior for Salesforce bulk operations now works the same way as for Salesforce operations, with operation responses being UTF-8 encoded regardless of the character encoding type of the source.

Fix¶

• Option to ignore lines
  The option to ignore a set number of first or last lines now works properly for UTF-16 (LE and BE) encoded text files. This option is specified during the setup of a source or target.

Security Enhancement¶

• Library upgrade
  The async-http-client library has been upgraded to version 1.9.38. This improves the security of asynchronous HTTP connections made by the Agent.

8.16.0¶

• NA: September 10, 2016

New Features¶

• You can now use Jitterbit global variables as sources and targets. The new type of source and target allow users to read and write directly from/to global variables in their operations, bypassing any extra workarounds, such as temporary or local storage.

• Added support for the Salesforce Summer '16 release (aka SFDC API v37).

Improvements¶

• The agent can now preserve white-space characters in a JSON transformation. Set $jitterbit.source.json.trim = false to enable this behavior.

• Enhanced user experience when using the SortArray method through improving documentation and error handling.

• Improved Agent reconnect logic to help Agent recover quicker when experiencing network problems.

• Added a Knowledge Base link to the Error Message that pops up when NetSuite requires the use of Application ID.

• NetSuite Connector now shows the custom field for CustomerDeposit object.

• Vendor Return Authorization has been configured in NetSuite search.

• In the NetSuite search object, one can now filter by "Vendor Return Authorization".

• NetSuite is now capable of retries to Cloud API calls.

Fix¶

• Salesforce timestamp function now reflects the accurate timestamp results between UTC 12:00 and UTC 13:00.

Security Enhancements¶

• Bouncy Castle upgraded to version 1.54. Improves security by forcing Key Fingerprint usage in its cryptography algorithms.

• XercesImpl library upgraded to version 2.11.0.SP4. This improves the security of the overall system.

• PDFbox upgraded to version 2.0.2. This increases the security when processing PDF documents.