NetSuite Changelog
IntegrationSuiteScriptIntegrationCustomizationHow-To

Troubleshooting Sync Script Errors in NetSuite Connector

Resolve Sync Script errors like 'Invalid String' in NetSuite Connector by adjusting data sync settings and ensuring correct parameters.

·2 min read·1 views·View Oracle Docs

TL;DR Opening

If your NetSuite setup uses numerous custom fields, you may encounter the error SyntaxError: Invalid String [at JSON.parse (native), at Object.getInputData during Map/Reduce scripting for the NetSuite Connector. This typically happens when the JSON file exceeds one million characters, leading to failures in syncing orders effectively.

To prevent this issue, it is crucial to reduce the volume of data synced concurrently.

How to Reduce Data Sync Volume

Lower the data load in your synchronization script configurations by following these steps:

  1. Navigate to Customization > Scripting > Scripts in your NetSuite dashboard.
  2. Locate the FA | MR Sync - Update FA script and click on Deployments.
  3. In the customdeploy_fa_mr_sync_update_fa row, select Edit.
  4. Open the Parameters tab.
  5. Adjust the Amount of Records to Sync Per MR Run field to 10.
    • Note: The default value is 20. If issues persist after reducing it to 10, continue to decrease it to 5. Should the problem still not resolve, contacting NetSuite Customer Support is advised.
  6. Click Save.

Key Error Message

  • The specific error encountered is: SyntaxError: Invalid String [at JSON.parse (native), at Object.getInputData. This indicates that the script is handling an excessively large JSON document.

Additional Support

For more persistent errors or issues, reference the [Troubleshooting Common NetSuite Issues in NetSuite Connector] and the [Troubleshooting Common NetSuite Configuration Issues].

Key Takeaways

  • Sync errors can arise when managing large JSON files in NetSuite Connector syncing scripts.
  • Reducing the number of records to sync simultaneously can resolve these errors.
  • If problems persist after adjusting parameters, contact NetSuite Support for further assistance.

Frequently Asked Questions (4)

What should I do if I encounter a 'SyntaxError: Invalid String' during Map/Reduce scripting?
This error often occurs when the JSON file exceeds one million characters. To resolve it, reduce the volume of data synced concurrently by adjusting the 'Amount of Records to Sync Per MR Run' field in your script configurations to a smaller number, such as 10 or 5.
How do I adjust the number of records to sync per Map/Reduce run in NetSuite?
Navigate to Customization > Scripting > Scripts, locate the FA | MR Sync - Update FA script, and click on Deployments. Edit the Parameters tab and adjust the 'Amount of Records to Sync Per MR Run' field to the desired number, then save your changes.
What steps should I take if reducing records to sync doesn't resolve script errors in NetSuite Connector?
If issues persist after reducing the number of records to sync, it's recommended to contact NetSuite Customer Support for further assistance to identify and resolve the underlying issue.
Can reducing the sync data volume help with JSON parsing errors in NetSuite?
Yes, reducing the number of records synced per Map/Reduce run can help prevent errors due to handling excessively large JSON documents.
Source: Troubleshooting Sync Script Errors — Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in Integration

View all Integration articles →