9.1 Harmony release notes

Log in to the Harmony portal to access the latest version of the API Manager, Management Console, and Citizen Integrator or to download the latest version of Design Studio and private agents. As always, please contact support if you need help.

9.1.0.8 Harmony release notes - Private agents - July 13, 2018

Fixes

• Private agents: Rolled back a fix that was released in version 9.1.0.7 to the CVTDate() function when it is used to process null values. The fix worked when CVTDate is only called on a particular field once.
  Fixed an issue with the CVTDate() function that caused invalid results when CVTDate() is called more than once on a particular field.

  Example: In the following example the second call to CVTDate using the mydate variable (for the variable Month) would result in a null value, even if it that call were made in a different transformation script.

  year=CVTDATE(mydate,'yyyy-mm-dd','yy');
  month=CVTDate(mydate,'yyyy-mm-dd','mm');
  

9.1 Harmony release notes - July 5, 2018 in EMEA and July 9, 2018 in NA

New features

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

Fixes

• Identity App: Fixed a problem that prevented users from using the "forgot password" feature if their email address includes an uppercase letter.
  The "forgot password" feature now allows a user to create new password and complete the process successfully when using a mixed case email or a lower case email login.

• Data Loader: Fixed an issue with the Harmony portal menu in Data Loader.
  Enabled the 'Home' option in Data Loader allowing the user to go back to the landing page from the Harmony portal menu.

• Management Console: The 'Run Imported Project Operation' screen fails to display after importing projects into multiple environments.
  The 'Run Imported Project Operation' screen now displays to the user after importing projects into multiple environments in the project screen.

• Management Console: Fixed the close button on the 'Warning Message for Agent' window in the Agents and Agent Groups pages.
  The Close button now successfully closes the 'Warning Message for Agent' window, which appears while viewing the changes made to the jitterbit.conf file in the Agents and Agent Groups pages.

• Management Console: Fixed the issue where setting the 'A new agent version, 9.1, is available for download' banner to disabled was not removing the notification banner.
  Setting the 'A new agent version, 9.1, is available for download' banner to disabled within one page now removes the notification across all pages in the Management Console.

• Management Console: Removed the 'Change Password' option from Management Console, API Manager and Citizen Integrator pages.
  The 'Change Password' option is now available only from the Harmony landing page.

• Design Studio: Fixed an issue with the SFLookupAll() function not handling Unicode Decoding of international characters successfully.
  Improved robustness of encoding/decoding HTML on the Salesforce interface.

• Design Studio: Fixed login problem to Einstein Analytics (Wave) for Sandbox enabled Salesforce profiles.
  Einstein Analytics (Wave) integrations now connect and run successfully for Sandbox enabled Salesforce profiles.

• Private agent and Design Studio: Fixed an issue where certain mappings using the CVTDate() function did not work correctly. NOTE: THIS FIX HAS BEEN ROLLED BACK IN PRIVATE AGENT VERSION 9.1.0.8. PLEASE SEE 9.0.1.0.8 RELEASE NOTES ABOVE.
  Fixed a problem with the CVTDate() function when it is used to process null values.

• Management Console: Fixed inappropriate text displaying on the Agents and Agent Groups pages in the Agent tool tip when changes are made in jitterbit.conf.
  Fixed the tool tip on the Agents and Agent Groups pages to display the correct text when changes are made in jitterbit.conf and removed extraneous text.

• Management Console: Sorting is not allowed for 'Invitation Status' and 'Status' columns in the Members tab on the Organizations page.
  Enabled sorting functionality for 'Invitation Status' and 'Status' columns in the Members tab on the Organizations page.

• Management Console: Fixed the flickering effect of the horizontal divider between the Organization grid and Roles grid on the Organizations page.
  The horizontal divider between the Organization grid and the role grid on the Organizations page is now static.

• Management Console: Fixed the issue where active Organization rows became disabled after the user clicks on any header column in the Organizations page.
  Active Organization rows remain active after the user clicks on any header column in the Organizations page.

• Management Console: Lower panel on the Organizations page does not resize properly after resizing the 'Action' column.
  Fixed the UI issue where resizing of the 'Action' column within the Roles and Members tabs introduced a new column on the right side of the Organizations page.

• Management Console: Disable sorting functionality from Action column on Organizations page.
  Disabled sorting functionality from the Action column on the Organizations page. After refresh, the Organization column displays the ascending order icon and the Organization column is sorted in ascending order. The user may sort the Organization column in descending order by selecting the ascending order icon.

• Management Console: Fixed multiple UI issues on the Organizations page.
  The 'Permission' popup window now displays in the appropriate place and various scroll bar issues have been fixed on the Organizations page.

• Management Console: Fixed multiple UI issues on the Notifications page.
  Removed extra space from the 'Notification' pop-up window while adding and editing the notification on the Notifications page.

• Management Console: On the Organizations > Edit Organization Policies popup, the "Enter Correct IP Address" error displays immediately after entering the start range IP, even before clicking the Save button. The error message should only display if an invalid IP has been entered.
  Fixed the error message displaying while the user is entering the allowlist IP range in the 'Edit Organization Policies' popup on the Organizations page.

• API Analytics (Classic): API debug log content and time-stamp rows don't display together for the same hit on the View Debug Logs page
  Fixed the issue to display debug log content and time-stamp for a particular hit together in the same row on the View Debug Logs page.

• Management Console: If one valid IP range has been entered, a second Invalid IP range can be saved in 'Enable IP Whitelist Range' within the 'Edit Organization Policies' popup on the Organizations page.
  Fixed the issue where the validation of a second IP range was incorrect and allowed an invalid IP range to be saved within the organization policies of the Organizations page.

• Management Console: Whitelist IP range is not deleted as expected.
  Fixed the UI issue on the Organizations page where an IP range is deleted from 'Enable IP Whitelist Range' within the 'Edit Organization Policies' popup, but the IP range is not actually deleted from Harmony.

• Management Console: The 'Role' column on the 'Roles' tab should be sorted in order by name on the Organizations page.
  Fixed the issue to display the 'Role' column sorted in ascending order by name in the 'Roles' tab on the Organizations page.

• Identity APP: SSO OAuth refresh login causes unknown exception for cross zone users (i.e. US users logging in from EMEA).
  Fixed the issue with the SSO users trying to log in to Harmony from cross zone clouds (i.e. US users logging in from EMEA).

• Design Studio: Unexpected behavior when logging in to Design Studio using SSO.
  Fixed a problem with the Design Studio SSO cookies.

• Management Console: On the Customizations > Client Certificates page, the certificate remains open in edit mode even after updating the certificate.
  Fixed the issue where the 'Edit Certificate' window is not closing post update on the Client Certificates page.

• Management Console: On the Customizations > Plugins page, when a custom plugin is deleted, it is not deleted from FileStore.
  Fixed the issue where a customer was not able to upload the same custom plugin again immediately after it was deleted.

• Linux (RPM) agent: 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.

• Private agents: 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 the issue that would not allow users to reset an expired password and partially fixes the cross-zone login issue.
  Users are now able to reset their expired passwords successfully.

• Fixed the 500 Internal Server error that occurred when trying to log in with user credentials of the other zone (Cross Zone Login - US user trying to log in from Europe, or an EMEA user trying to log in from the US.)
  The temporary fix will redirect the user to the correct zone (NA or EMEA), but the user is still required to re-enter the username after being redirected. (A final fix that does not require the user to re-enter the username will be included in a later release.)

• API gateway: Fixed an issue in which the API gateway was intermittently not reading the Content-Type header when it detected a 9.0 agent.
  The API gateway 9.0 code has been fixed to read the Content-Type header properly and extract the URL encoded elements into Jitterbit variables.

• API gateway: Fixed an issue in which the 9.0 API gateway was not handling an overly long URL correctly and causing a 502 error.
  The 9.0 API gateway will now revert to processing URL data that is too long in the same manner as the previous versions of API gateway.

• 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.

• Private agent: 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.

• Private agent: 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.

• Private agent: 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.

• Private agent: 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.

• Private agent: 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.

• Private agent: 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.