Past Sandbox Cloud Agent Group releases
Introduction
This page provides a compilation of end-of-life releases for the Sandbox Cloud Agent Group. For the latest Sandbox Cloud Agent Group releases, see Sandbox Cloud Agent Group releases.
See Known issues for detailed information on issues and workarounds.
End-of-life Sandbox Cloud Agent Group release notes
11.17
The 11.17 release date for the Sandbox Cloud Agent Group is by region:
- APAC: November 7, 2023 (6 AM AEDT)
- EMEA: November 7-8, 2023 (1 AM CET)
- NA: November 8, 2023 (4 PM PST)
Enhancements
- Apache Tomcat upgrade
The Apache Tomcat server used by agents has been upgraded to version 8.5.94 to improve security and performance.
11.16
The 11.16 release date for the Sandbox Cloud Agent Group is by region:
- APAC: October 17, 2023 (12 - 4 AM AEDT)
- EMEA: October 17-18, 2023 (9 PM - 1 AM CEST)
- NA: October 18, 2023 (12 - 4 PM PDT)
This version includes general updates.
11.15
The 11.15 release date for the Sandbox Cloud Agent Group is by region:
- APAC: September 26, 2023 (12 - 4 AM AEST)
- EMEA: September 26-27, 2023 (9 PM - 1 AM CEST)
- NA: September 27, 2023 (12 - 4 PM PDT)
This version includes general updates.
11.14
The 11.14 release date for the Sandbox Cloud Agent Group is by region:
- APAC: September 6, 2023 (12 - 4 AM AEST)
- EMEA: September 6-7, 2023 (9 PM - 1 AM CEST)
- NA: September 7, 2023 (12 - 4 PM PDT)
This version includes general updates.
11.13
The 11.13 release date for the Sandbox Cloud Agent Group is by region:
- APAC: August 15, 2023 (12 - 4 AM AEST)
- EMEA: August 15-16, 2023 (9 PM - 1 AM CEST)
- NA: August 16, 2023 (12 - 4 PM PDT)
Enhancements
-
Design Studio Autodesk Fusion Lifecycle OAuth v2 API support
When configuring a Design Studio Autodesk Fusion Lifecycle endpoint with agent version 10.75 / 11.13 or later, its existing OAuth2 settings now support configuration with Autodesk’s OAuth v2 API and remain backwards compatible with Autodesk’s OAuth v1 authentication (being deprecated by Autodesk). -
Cloud Studio SDK connector support for variables in tables
Support for global, project, and Jitterbit variables has been added to text fields used in the Connector SDK table component when using a 10.75 / 11.13 or later agent. Whether a specific connector was built using the SDK is indicated in the documentation for an individual connector. This enhancement affected 92 existing SDK-based connectors. Each field that supports variables is displayed with aV
icon when in edit mode.Note
Although the
V
icon is displayed regardless of the agent version, variable values will not be interpreted correctly unless using a 10.75 / 11.13 or later agent.
11.12
The 11.12 release date for the Sandbox Cloud Agent Group is by region:
- APAC: July 25, 2023 (12 - 4 AM AEST)
- EMEA: July 25-26, 2023 (9 PM - 1 AM CEST)
- NA: July 26, 2023 (12 - 4 PM PDT)
Enhancements
-
NetSuite WSDL version 2023.1 support
Jitterbit has verified support for NetSuite WSDL version 2023.1 with the Cloud Studio NetSuite connector and the Design Studio NetSuite connector. -
Salesforce API version 58 support
Salesforce API version 58 is now supported for these connectors:-
The Cloud Studio Salesforce, Salesforce Service Cloud, and ServiceMax connectors use API version 58 automatically with the use of a 10.74 or 11.12 agent.
-
The Design Studio Salesforce connector provides the option to use API version 58 with the use of both a 10.74 or 11.12 agent and 10.74 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 58.
-
11.11
The 11.11 release date for the Sandbox Cloud Agent Group is by region:
- APAC: July 4, 2023 (12 - 4 AM AEST)
- EMEA: July 5-6, 2023 (10 PM - 2 AM CEST)
- NA: July 6, 2023 (1 - 5 PM PDT)
Fixes
- WSDL structures now show missing child nodes
After uploading a WSDL in a Cloud Studio SOAP connection or a Design Studio web service method, the resulting request and response structures now show all nodes as expected. Previously, child nodes from some WSDLs were not appearing.
11.10
The 11.10 release date for the Sandbox Cloud Agent Group is by region:
- APAC: June 13, 2023 (12 - 4 AM AEST)
- EMEA: June 13-14, 2023 (10 PM - 2 AM CEST)
- NA: June 14, 2023 (1 - 5 PM PDT)
Enhancements
- New Jitterbit variable to exclude empty data from target XML
The new Jitterbit variablejitterbit.target.xml.exclude_empty_data
can be set totrue
upstream of a transformation mapping that returns an empty data value to exclude the value from being written to the target XML for that field mapping. This variable is recommended overjitterbit.target.xml.include_empty_xml
for use with boolean values. For atrue
value ofjitterbit.target.xml.exclude_empty_data
to take effect,jitterbit.target.xml.include_null_XML
must be set tofalse
andjitterbit.target.xml.include_empty_xml
must also befalse
(its default).
Fixes
-
Operations with chunking enabled now output the expected content type
When an operation has chunking enabled, transformations configured with JSON output are no longer unexpectedly converted to XML output. -
Error writing Salesforce bulk query results to a file no longer occurs
When the type of encoding differs between a Cloud Studio Salesforce Bulk Query activity or a Design Studio Salesforce Bulk Process Query action source and its target, a fatal error writing the result to a file no longer occurs. The former error had indicated:Reason: The process cannot access the file because it is being used by another process
.
11.9
The 11.9 release date for the Sandbox Cloud Agent Group is by region:
- APAC: May 23, 2023 (12 - 4 AM AEST)
- EMEA: May 23-24, 2023 (10 PM - 2 AM CEST)
- NA: May 24, 2023 (1 - 5 PM PDT)
Enhancements
- New Jitterbit variable to enable Unicode support
The new Jitterbit variablejitterbit.scripting.hex.enable_unicode_support
can be set totrue
upstream of theHexToString
orStringToHex
functions for their conversions to use UTF-8.
Fixes
- API Manager OData pagination URL no longer erroneously skips records
An API Manager OData service with server-side pagination now correctly sets the$skiptoken
parameter in its response. Previously, the pagination URL provided in the response was set one digit too high, causing a record to be inadvertently skipped on each run.
11.8
The 11.8 release date for the Sandbox Cloud Agent Group is by region:
- APAC: May 2, 2023 (12 - 4 AM AEST)
- EMEA: May 2-3, 2023 (10 PM - 2 AM CEST)
- NA: May 3, 2023 (1 - 5 PM PDT)
Enhancements
-
Default maximum memory increased
The Apache Tomcat process started by an agent now has a default maximum heap size of 2 GB, increased from 1 GB. -
Apache HTTP server upgrade
The Apache HTTP server included with the agent has been upgraded to version 2.4.57. This addresses critical vulnerabilities CVE-2006-20001, CVE-2022-36760, and CVE-2022-37436.
11.7
The 11.7 release date for the Sandbox Cloud Agent Group is by region:
- APAC: April 11, 2023 (12 - 4 AM AEST)
- EMEA: April 11-12, 2023 (10 PM - 2 AM CEST)
- NA: April 12, 2023 (1 - 5 PM PDT)
Enhancements
-
NetSuite WSDL version 2022.2 support
Jitterbit has verified support for NetSuite WSDL version 2022.2 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 11.7 agent.
-
The Design Studio Salesforce connector provides the option to use API version 57 with the use of both a 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.
-
11.6
The 11.6 release date for the Sandbox Cloud Agent Group is by region:
- APAC: March 21, 2023 (12 - 4 AM AEDT)
- EMEA: March 21-22, 2023 (10 PM - 2 AM CET)
- NA: March 22, 2023 (1 - 5 PM PDT)
Enhancements
- New Jitterbit variable to write the SOAP fault response
The new Jitterbit variablejitterbit.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 a5XX
server error.
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.
11.5
The 11.5 release date for the Sandbox Cloud Agent Group is by region:
- APAC: February 28, 2023 (AEDT)
- EMEA: March 1, 2023 (CET)
- NA: March 2, 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 theEstimate
object are now visible in the Cloud Studio NetSuite Search and Design Studio NetSuite Search activities.
11.4
The 11.4 release date for the Sandbox Cloud Agent Group is by region:
- APAC: February 7, 2023 (AEDT)
- EMEA: February 7, 2023 (CET)
- NA: February 8, 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 variableJitterbit.source.ftp.enable_regex_parser
totrue
in a script upstream of the FTP source in an operation. -
Base64Encode
function now encodes binary data properly
TheBase64Encode
function now encodes binary data properly when the Jitterbit variablejitterbit.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.
11.3
The 11.3 release date for the Sandbox Cloud Agent Group is by region:
- APAC: January 18, 2023 (AEDT)
- EMEA: January 18, 2023 (CET)
- NA: January 19, 2023 (PST)
Enhancements
- 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 when using cloud agents 11.3 or later.
11.2
The 11.2 release date for the Sandbox Cloud Agent Group is by region:
- APAC: January 5, 2023 (AEDT)
- EMEA: January 5, 2023 (CET)
- NA: January 9, 2023 (PST)
Changes
-
MD5
andSHA256
function behavior changed for binary files
Jitterbit’sMD5
andSHA256
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.
11.1
The 11.1 release date for the Sandbox Cloud Agent Group is by region:
- APAC: December 6, 2022 (AEDT)
- EMEA: December 6, 2022 (CET)
- NA: December 7, 2022 (PST)
Fixes
URLEncode
function now gives the expected output
Jitterbit’sURLEncode
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).
11.0
The 11.0 release date for the Sandbox Cloud Agent Group is by region:
- APAC: November 16, 2022 (AEDT)
- EMEA: November 16, 2022 (CET)
- NA: November 17, 2022 (PST)
Enhancements
- PostgreSQL upgrade
In the 11.0 agent version, the PostgreSQL database bundled with the agent is now version 14.5-1. The Jitterbit Cloud Agent Groups are being upgraded to 11.0 agents in this release.
10.61
The 10.61 release date is by region:
-
APAC: October 25, 2022 (AEDT)
-
EMEA: October 25, 2022 (CEST)
-
NA: October 26, 2022 (PDT)
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 5, 2022 (AEST)
-
EMEA: October 5, 2022 (CEST)
-
NA: October 6, 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 13, 2022 (AEST)
-
EMEA: September 13, 2022 (CEST)
-
NA: September 14, 2022 (PDT)
Enhancements
- New Jitterbit variable for allowing a blank API response
The new Jitterbit variablejitterbit.api.response.blank_error_response
can be set totrue
to allow to allow a blank API response to be returned for non-200
-type status codes such as404
. When set tofalse
(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 23, 2022 (AEST)
-
EMEA: August 23, 2022 (CEST)
-
NA: August 24, 2022 (PDT)
This version includes general updates.
10.57
The 10.57 release date is by region:
-
APAC: August 2, 2022 (AEST), August 1, 2022 (PDT)
-
EMEA: August 2, 2022
-
NA: August 3, 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 12, 2022 (AEST), July 11, 2022 (PDT)
-
EMEA: July 12, 2022
-
NA: July 13, 2022
This version includes general updates.
10.55
The 10.55 release date is by region:
-
APAC: June 22, 2022 (AEST), June 21, 2022 (PDT)
-
EMEA: June 22, 2022
-
NA: June 23, 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 2, 2022 (AEST), June 1, 2022 (PDT)
-
EMEA: June 2, 2022
-
NA: June 6, 2022
This version includes general updates.
10.53
The 10.53 release date is by region:
-
APAC: May 10, 2022 (AEST), May 9, 2022 (PDT)
-
EMEA: May 10, 2022
-
NA: May 11, 2022
Enhancements
-
NetSuite connector now supports the
Bill Payment
object
The NetSuiteBill 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 usingCHANGING
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 19, 2022 (AEST), April 18, 2022 (PDT)
-
EMEA: April 19, 2022
-
NA: April 20, 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 by region:
-
APAC: March 29, 2022 (AEDT), March 28, 2022 (PDT)
-
EMEA: March 29, 2022
-
NA: March 30, 2022
This version includes general updates.
10.50
The 10.50 release date is by region:
-
APAC: March 8, 2022 (AEDT), March 7, 2022 (PST)
-
EMEA: March 8, 2022
-
NA: March 9, 2022
Enhancements
- New Jitterbit variable for returning multiple database results as a record set
The new Jitterbit variablejitterbit.scripting.db.search.rowset
can be set totrue
upstream of theDBExecute
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: 15 February 2022 (AEDT), 14 February 2022 (PST)
-
EMEA: 15 February 2022
-
NA: 16 February 2022
Enhancements
-
New Jitterbit variable for decoding HTML characters in nodes
The new Jitterbit variablejitterbit.decode.html.chars
can be set totrue
upstream of theSelectSingleNode
orSelectNodes
functions for these functions to support HTML characters. -
New Jitterbit variable for wrapping of Base64-encoded strings
The new Jitterbit variablejitterbit.base64.encoded.string.no.wrap
can be set totrue
upstream of theBase64Encode
orBase64EncodeFile
functions to disable wrapping after the 64th character of the encoded result string.
10.48
The 10.48 release date is by region:
-
APAC: 25 January 2022 (AEDT), 24 January 2022 (PST)
-
EMEA: 25 January 2022
-
NA: 26 January 2022
Fixes
-
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: 6 January 2022 (AEDT), 5 January 2022 (PST)
-
EMEA: 6 January 2022
-
NA: 10 January 2022
Changes
-
TLS 1.0 and 1.1 are no longer supported by default for JDBC driver connections
Cloud agents 10.47 and later no longer support TLS 1.0 or 1.1 for JDBC driver connections to database endpoints.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).
10.46
There was no 10.46 Sandbox Cloud Agent Group release.
10.45
The 10.45 release date is by region:
-
APAC: 2 December 2021 (AEDT), 1 December 2021 (PST)
-
EMEA: 2 December 2021
-
NA: 6 December 2021
This version includes general updates.
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.
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
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 theDBExecute
function in the 10.40 release has been reverted. TheDBExecute
function again works the same way as it did prior to 10.40.Note
Current projects with this scenario will be affected with a Sandbox Cloud Agent Group upgrade from 10.40 or 10.41 to 10.42.
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
This version includes general updates.
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 theDBExecute()
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.
Note
This change has been reverted on 10.42 Sandbox Cloud Agent Groups.
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
- General updates
Library upgrades and internal fixes.
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
This version includes general updates.
10.37
The 10.37 release date is by region:
-
APAC: 10 June 2021 AEST, June 9, 2021 PDT
-
EMEA: 10 June 2021
-
NA: June 14, 2021
Enhancements
- NetSuite: Support for WSDL version 2021.1
We have verified Cloud Studio and Design Studio 10.37 with NetSuite WSDL version 2021.1 using agents 10.37 and later.
Fixes
-
HMAC-SHA1 Generator plugin now handles special characters
The HMAC-SHA1 generator plugin can now use special characters such as carriage returns. Use the parameters$Jitterbit.HMACSHA256.Base64EncodedMessage
and$Jitterbit.HMACSHA1.Base64EncodedMessage
and set both totrue
. -
Null values in a JSON parsed successfully with
JSON.parse()
When parsing a JSON in a Jitterbit JavaScript using JSON.parse(), null values no longer cause an error, and the JSON processes successfully.
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 agent performance and resilience.
10.36
The 10.36 release date is by region:
-
APAC: 20 May 2021 (AEST), May 19, 2021 (PDT)
-
EMEA: 20 May 2021
-
NA: May 24, 2021
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 totrue
.
10.35
The 10.35 release date is by region:
-
APAC: 6 May 2021 (AEST), May 5, 2021 (PDT)
-
EMEA: 6 May 2021
-
NA: May 10, 2021
Changes
- Empty strings can be set to
NULL
instead of""
Blank characters in the source will now be inserted asNULL
when using the variablejitterbit.target.db.include_null_in_sql_statement
set toTRUE
. Blank character strings will be set to empty when thejitterbit.target.db.include_null_in_sql_statement
, is set toFALSE
.
10.34
The 10.34 release date is by region:
-
APAC: 8 April 2021 (AEST), April 7, 2021 (PDT)
-
EMEA: 8 April 2021
-
NA: April 12, 2021
This version includes general updates.
10.33
The 10.33 release date is by region:
-
APAC: 18 March 2021 (AEDT), 17 March 2021 (PDT)
-
EMEA: 18 March 2021
-
NA: March 22, 2021
Enhancement
- NetSuite JDBC driver added to cloud agents
The NetSuite JDBC driver has been added to the cloud agents.
10.32
The 10.32 release date is by region:
-
APAC: 4 March 2021 (AEDT), 3 March 2021 (PST)
-
EMEA: 4 March 2021
-
NA: 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: 3 February 2021
-
EMEA: 4 February 2021
-
NA: February 8, 2021
This version includes general updates and fixes to improve the agent.
10.30
The 10.30 release date is by region:
-
APAC: 20 January 2021
-
EMEA: 21 January 2021
-
NA: 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: 06 January 2021
-
EMEA: 07 January 2021
-
NA: January 11, 2021
This version includes general updates and fixes to improve the agent.
10.28
The 10.28 release date is by region:
-
APAC: 02 December 2020
-
EMEA: 03 December 2020
-
NA: 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.
-
10.27
The 10.27 release date is by region:
-
APAC: 11 November 2020
-
EMEA: 12 November 2020
-
NA: 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
The 10.26 release date is by region:
-
APAC: 21 October 2020
-
EMEA: 22 October 2020
-
NA: October 26, 2020
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
The 10.25 release date is by region:
-
APAC: Released 14 October 2020
-
EMEA: Released 14 October 2020
-
NA: Released October 14, 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
The 10.24 release date is by region:
-
APAC: 7 October 2020
-
EMEA: 8 October 2020
-
NA: October 12, 2020
This version includes general updates.
10.23.1
The 10.23.1 release date is by region:
-
APAC: 26 August 2020
-
EMEA: 27 August 2020
-
NA: 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
The 10.23 release date is by region:
-
APAC: Released 19 August 2020
-
EMEA: Released 20 August 2020
-
NA: Released August 24, 2020
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
The 10.22 release date is by region:
-
APAC: Released 29 July 2020
-
EMEA: Released 3 August 2020
-
NA: Released August 4, 2020
Changes
- Oracle JDBC driver upgraded to version 8
The Oracle JDBC driver version 6 was upgraded to version 8 for improved performance.
10.21
The 10.21 release date is by region:
-
APAC: Released 8 July 2020
-
EMEA: Released 9 July 2020
-
NA: Released 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
The 10.20 release date is by region:
-
APAC: Released 17 June 2020
-
EMEA: Released 18 June 2020
-
NA: Released June 22, 2020
This version includes general updates and fixes to improve the agent.
10.19
The 10.19 release date is by region:
-
APAC: Released 27 May 2020
-
EMEA: Released 28 May 2020
-
NA: Released June 1, 2020
Note
We fixed an issue with Sandbox Cloud Agents where operations using URL encoding in FTP URL filenames were failing and generating errors. The fix version number is 10.19.0.25. Please check your installed version and install the latest version.
Fixes
-
Fixed an issue where operations using URL encoding of FTP filenames failed
Operations using URL encoding in FTP URL filenames were failing and generating 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
The 10.18 release date is by region:
-
APAC: 06 May 2020
-
EMEA: 07 May 2020 20:00 UTC
-
NA: May 11, 2020
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
totrue
will ignore an XML to JSON file transformation error where the XML file has an empty chunk.
Fixes
- Fixed an issue where operations using URL encoding of FTP filenames failed
Operations using URL encoding in FTP URL filenames were failing and generating errors. - 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
The 10.17 release date is by region:
-
APAC: 15 April 2020
-
EMEA: 16 April 2020
-
NA: April 20, 2020
This update is an upgrade of the Sandbox Cloud Agent Group from agent version 10.16 to agent version 10.17.
-
Salesforce API version 48 is now supported
The Cloud Studio Salesforce and ServiceMax connectors and the Design Studio Salesforce connector now support Salesforce API version 48.-
Cloud Studio uses the new API version automatically with the use of a 10.17 agent.
-
Design Studio provides the option to use the new API version with the use of both a 10.17 agent and 10.17 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 48.
-
-
New variables added to append the date to success folder filenames
Two new Jitterbit variables,jitterbit.target.append_date_to_success_file
andjitterbit.source.append_date_to_success_file
, are available to append the current date in 24-hour format to success folder filenames. If a variable is not set or set totrue
, the current date is appended to the respective success file. If set tofalse
, no date is appended.
10.16
The 10.16 release date is by region:
-
APAC: 25 March 2020
-
EMEA: 26 March 2020
-
NA: April 1, 2020
Fixes
- A compressed file is now named correctly
When using a global variable in file-based Cloud Studio or Design Studio endpoints in the Filename(s) in archive field in order to write data to a file, the global variable value is now used instead of the literal variable name. - Project variables longer than 8,000 characters no longer cause an error
Project variables with an encrypted length longer than 8,000 characters are decrypted successfully. New projects function as expected but existing projects must be redeployed. - The PrependData plugin
AddLineBreak
option now works properly
SettingAddLineBreak=true
in the PrependData plugin now enables line breaks in the output file.
10.15
The 10.15 release date is by region:
-
APAC: 04 March 2020
-
EMEA: 05 March 2020
-
NA: March 9, 2020
Enhancements and fixes
- General improvements to Jitterbit agents
10.14
The 10.14 release date is by region:
-
APAC: 12 February 2020
-
EMEA: 13 February 2020
-
NA: February 18, 2020
Enhancements and fixes
- General improvements to Jitterbit agents
Changes
- PostgreSQL configuration defaults updated
The PostgreSQL configuration filepostgresql.conf
for 64-bit agents now sets the defaultmax_connections
to 400 (instead of the previous limit of 100). In addition, the defaultcheckpoint_timeout
for 32-bit and 64-bit agents is now 1 hour instead of 5 minutes.
10.13
The 10.13 release date is by region:
-
APAC: 22 January 2020
-
EMEA: 23 January 2020
-
NA: January 27, 2020
Enhancements and fixes
- General improvements to Jitterbit agents
10.12
The 10.12 release date is by region:
-
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 variablegoogle.oauth.token.auth
and the expiration number of seconds in the variablegoogle.oauth.token.expireSeconds
. The new plugin is available on cloud agents or 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 the Jitterbit cloud agent groups has been upgraded from PostgreSQL JDBC Driver 9.1 to 9.4.
Fixes
-
Cloud agents processing web services with a SOAP fault now report the correct status
When using a Jitterbit cloud agent group 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
The 10.11 release date is by region:
-
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 10.11 agent and 10.11 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 alibcurl
function. The issue was caused by library upgrades in Jitterbit agent version 8.29 and has been resolved with 10.11 and higher agents.
10.10
The 10.10 release date is by region:
-
APAC: 25 November 2019
-
EMEA: 2 December 2019
-
NA: December 3, 2019
Changes
- Cloud agent temp storage file size limit is now 50 GB
When using 10.10 or higher cloud agents with a temporary storage target in Cloud Studio or Design Studio, there is now a limit of 50 GB per file. Those who need to create temporary files larger than 50 GB are encouraged to use private agents.
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 elementswsa:To
andwsa:Action
by defining these parameters using global variables. -
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 the Jitterbit Cloud Agent Groups.
10.9
The 10.9 release date is by region:
-
APAC: 4 November 2019
-
EMEA: 5 November 2019
-
NA: November 7, 2019
Fixes
FormatDate()
can now handle milliseconds and a time zone
When using the Jitterbit functionFormatDate()
, 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
The 10.8 release date is by region:
-
APAC: 9 October 2019
-
EMEA: 10 October 2019
-
NA: October 14, 2019
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 asJitterbit.ReadFile
andJitterbit.WriteFile
ignored global variables used in an endpoint configuration.
10.7
The 10.7 release date is by region:
-
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.
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
The 10.6 release date is by region:
-
APAC: 3 September 2019
-
EMEA: 4 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).
Changes
- Updated libraries resolve issues with large file transfers
The librarieslibcurl
andlibssh2
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
TheBase64Decode()
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).
10.5
The 10.5 release date is by region:
-
APAC: 7 August 2019
-
EMEA: 8 August 2019
-
NA: August 12, 2019
This version includes general updates and fixes to improve the agent.
10.4
The 10.4 release date is by region:
-
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.
10.3
The 10.3 release date is by region:
-
APAC: 26 June 2019
-
EMEA: 8 July 2019
-
NA: July 10, 2019
This update is an upgrade of the Sandbox Cloud Agent Group from agent version 10.1 to agent version 10.3. This includes all updates up to and including the 10.3 release.
Fixes
- 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.
10.1
The 10.1 release date is by region:
-
APAC: 1 May 2019
-
EMEA: 2 May 2019
-
NA: May 6, 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 agents.
Fixes
- The
SendEmail()
function now supports multi-byte characters
The Jitterbit Script functionSendEmail()
in Cloud Studio or Design Studio can now be used to send emails containing multi-byte characters.
10.0
The 10.0 release date is by region:
-
EMEA: 4 April 2019
-
NA: April 8, 2019
Changes
- The Sandbox Cloud Agent Group no longer supports creating new projects using ODBC drivers. Use a JDBC driver or a private agent instead. For assistance, contact Jitterbit support. (Effective March 26, 2019)
Fixes
- Fixed an issue with the SAP Connector driver when it is installed for the first time on a Linux agent. (Added in 10.0)
9.9
The 9.9 release date is by region:
-
EMEA: 14 March 2019
-
NA: March 18, 2019
This update was an upgrade of the Sandbox Cloud Agent Group from agent version 9.4.2 to agent version 9.9. This included all updates up to and including the 9.9 release.
Enhancements
-
LDAP passwords can be set and updated in Jitterbit Script using the LDAP functions. (Added in 9.9)
-
The Java distribution included in the Windows agent has been changed from the Oracle JRE to the AdoptOpenJDK JRE. (Added in 9.8)
-
Boolean types are now supported for OData when using SQL Server, MySQL, or PostgreSQL. (Added in 9.7)
-
SAP fields defined as doubles now work correctly when used in OData APIs. (Added in 9.7)
Fixes
-
Fixed an issue with the architecture of the third-party SAP JCo (Java Connector) library included in the Linux agent. (Added in 9.9)
-
Fixed an issue with the installation of the AdoptOpenJDK JRE by the Windows agent installer that prevented certain plugins from functioning. (Added in 9.9)
-
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. Settingjitterbit.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. (Added in 9.8) -
Fixed an issue with retrieval of the NetSuite custom segments to avoid timeout errors while generating or refreshing the schemas. (Added in 9.7)
-
Fixed an issue in the JMS Connector with messages that are missing a JMS destination header. (Added in 9.7)
-
Fixed an issue with the parsing of IDoc types. It is now enabled. (Added in 9.6)
-
Resolved timeout issues when using JDBC to retrieve a large number of tables. (Added in 9.5)
-
Fixed an Issue with the input parameter of the
CVTDate()
script function being set to an empty value. TheCVTDate()
function now successfully converts each input data value to the appropriate date and does not set any input to an empty value. (Added in 9.5)