Products | Versions |
---|---|
TIBCO Cloud Integration - Connect ( Scribe ) | - |
If a user changes the display name in NetSuite for a Source field used as a filter in a TIBCO Scribe Online Map and refreshes metadata outside the Map containing the filter, TIBCO Scribe Online generates a Fatal Error with a message similar to the following:
At least one of the NetSuite query parameters is invalid. Please open your map, validate all links and filters, and try again.
Example of the issue:
Assume you are querying the Contact Entity in NetSuite in a Map used to delete obsolete Contacts. You have set the following filter in the Query Block:
"FieldA" = "true"
Later you go into NetSuite and change the display name of "FieldA" to "DeleteRecord?".
In TIBCO Scribe Online, you Refresh Metadata for your NetSuite Connection from the Connections page to retrieve the updated field name. However, this only clears the old metadata information and new metadata information is not loaded.
In this scenario, when TIBCO Scribe Online runs the Map, TIBCO Scribe Online generates a Fatal Error stating that a Query parameter is invalid. Open your Map and update the filter to use the new, updated display name for the filter field.
Other Scenarios
NetSuite As A Source
If the field with the modified display name is used as a Source that is mapped to a target field, the value of the source field is not inserted and no error is generated.
Fetch And Lookup Operations
Fetch and Lookup operations have the same issue as the Query, where a Fatal Error is generated.
Matching Criteria
If the field with the modified display name is used as Matching Criteria for an update or delete operation, TIBCO Scribe Online generates a record error similar to the following:
Operation failed. Label: Update Customer, Name: CustomerUpdate, Message: At least one Netsuite operation filter criteria is invalid.
NetSuite As A Target
When the field with the modified display name is used as a target field to which data is being written, TIBCO Scribe Online generates an error similar to the following:
Operation failed. Label: Update Customer, Name: CustomerUpdate, Message: There was a problem setting Netsuite field: [field name]