Skip to end of metadata
Go to start of metadata

Introduction

This page documents known issues that have been identified with Jitterbit Harmony Cloud Studio. For known issues that have been identified with other Jitterbit Harmony applications, see Jitterbit Harmony Known Issues.

General

  • New trial users may not be able to access Cloud Studio immediately after registering

    • Summary: When a new trial user logs in to the Harmony Portal for the first time immediately after registering with Jitterbit Harmony, they may see Design Studio displayed as an application card. When clicked, nothing happens.

    • Additional Info: This issue is limited to new trial users; new users registering to join an existing Jitterbit Harmony organization are unaffected.

    • Workaround: To avoid this issue, wait a few minutes after registering to log in. If you have already encountered this issue, log out of the Harmony Portal and log back in. The Cloud Studio application card should be displayed. Click the card to access Cloud Studio.

Connectors

  • Magento: Filtering a search on the email field isn’t working

    • Summary: When specifying filter parameters in the request of a Magento Search activity, the email field isn’t working due to a limitation imposed by the Magento API.

    • Additional Info: The operation appears to be successful, but there is no output generated.

  • Magento: Filtering a search using incorrect field names isn’t working

    • Summary: When specifying filter parameters in the request of a Magento Search activity, supplying field names that don’t exactly match the capitalization of the Magento API names aren’t working.

    • Additional Info: The operation fails and the response message indicates an invalid attribute name.

    • Workaround: Use lowercase field names, matching those used in the Magento API documentation.

  • Magento: Filtering a search on some fields isn’t working

    • Summary: When specifying filter parameters in the request of a Magento Search activity, some fields aren't working even when they exactly match the field names specified in the Magento API documentation.

    • Additional Info: The operation fails and the response message indicates an invalid attribute name.

    • Workaround: Use the browser logs to determine what field name is expected by the connector. For example, while the Magento API specifies an id field, the Magento connector expects the field name provided in the request to be entity_id. The browser logs can be accessed within Google Chrome Developer tools in the Network tab.

  • Microsoft Dynamics AX: Optional mappings with invalid values cause a create function to fail

    • Summary: After configuring a Microsoft Dynamics AX Functions activity with its create function, if the request transformation contains any mappings to optional fields that provide an invalid value, the operation will fail at runtime. An example of an invalid value is providing U.S. dollars instead of a valid currency ISO code for the Currency field.

    • Additional Info: The operation fails with an error related to a failed login and no exceptions are logged in the Microsoft Dynamics AX system.

  • SAP: Deployment of invalid SAP operations is allowed

    • Summary: Operations that contain more than one SAP activity, or that contain an SAP activity and a NetSuite, Salesforce, or SOAP activity, appear to be valid and are able to be deployed without error.

    • Additional Info: The operation will fail at runtime.

    • Workaround: Follow a valid operation pattern and don't use more than one SAP, NetSuite, Salesforce, or SOAP activity in the same operation. If using an SAP activity as a source, use only the Transformation Pattern. If using an SAP activity as a target, use the Transformation Pattern, the Two-Target Archive Pattern (as the first target only), or the Two-Transformation Pattern, as applicable. See Operation Validity for more information.

  • ServiceNow: Searching on the Items object with conditions doesn’t work

    • Summary: When using a ServiceNow Query activity to search on the Items object with a condition such as a WHERE or LIMIT clause, the response is empty with no data.

    • Additional Info: The operation appears to be successful with warnings related to extra subelements.

  • ServiceNow: DateTime fields use the wrong data type in the response schema generated by a ServiceNow query activity

    • Summary: During the configuration of a ServiceNow Query activity, in the schema generated in step 3, a DateTime field that is returning a value (either a DateTime or a null) uses a string 'dateTime' instead of the value.

    • Workaround: In the transformation, mirror the schema, then edit it and change the data type of any 'dateTime' fields to a string.

  • ServiceNow: Operations with ServiceNow create or update activities using incorrectly formatted DateTime data fail to write the record

    • Summary: Operations that use a ServiceNow Create or Update activity to attempt to write incorrectly formatted DateTime data will report success with an error but fail to create or update the record.

    • Additional Info: The error message returned does not report the wrong date format as a cause.

Transformations

  • Manually clearing a mapping results in an unconfigured script error

    • Summary: After editing a script on a target field in a transformation and then clearing the contents of that script, both the script and the mapping are reported to be invalid with an error indicating that the script is unconfigured.

    • Workaround: To restore the original unmapped status of the target field, use the actions menu on the node that contains the target field to select Clear invalid mappings only. Note that any other invalid mappings contained within the node will also be cleared.

  • A variable used in a transformation mapping cannot contain a period in its name

    • Summary: A variable used in a transformation mapping that has one or more periods in its variable name isn't resolved correctly, resulting in an incorrect target field mapping in the transformation.

    • Additional Info: Because of this issue, Jitterbit variables at this time cannot be referenced within a transformation.

    • Workaround: Rename project or global variables by replacing any periods with underscores or another character.

  • The Jitterbit Script FindValue() function does not work correctly with data element paths

    • Summary: The Jitterbit Script FindValue() function does not work correctly with data element paths, positioning the hash symbol (#)—used to indicate an instance—in an incorrect location in the data element path.

    • Workaround: You can adjust the position of the hash manually to the correct location, but upon reopening a script using this function, the symbol will need to be manually repositioned again.

  • A transformation preview will result in a generic error when using an invalid sample file

    • Summary: When loading a sample file to use for a transformation preview, if the file is in an invalid format, the error message indicates a "sampleDataLoadFailure."

    • Additional Info: Potential causes of an invalid format include a CSV file missing the header, a JSON file missing a closing quote, an XML file missing a closing tag, etc.

On This Page

Last updated:  Feb 12, 2020

  • No labels