Connector For NetSuite Issue

Connector For NetSuite Issue

book

Article ID: KB0079032

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) -

Description

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]   

Issue/Introduction

Changing the display name for a field in NetSuite can affect filters using that field in TIBCO Scribe Online.

Resolution

After changing any field display name in NetSuite that is used as a filter in a Map, do the following:
 
  1. In TIBCO Scribe Online, refresh the metadata of the NetSuite Connection that uses the problem filter field either from the Connections page or from inside the Map containing the filter.
  2. If metadata is refreshed outside of the Map, open each Map containing the filter to load the new metadata.
After new metadata is loaded in the Map, TIBCO Scribe Online generates a Map validation error indicating that there is a problem with the filter. The Map is set to Incomplete and cannot be run.
  1. Update the filter to use the new field name and save the Map