Back

Troubleshooting NetSuite Real-Time Data Sources

Published: Jan 16, 2024
Post Author Written by Ethan Sorenson

Troubleshooting a NetSuite Real-time data source integration can be difficult because we can’t manually run the integration. This article will serve as a guide of steps that can be followed to troubleshoot a NetSuite Real-Time data source integration that doesn’t run as expected.

The SuiteScript needs to first be deployed in NetSuite before a real-time data source integration can be ran.

1. Setup SmartConnect Error Logs

  1. Check that Errors are being saved by the integration
    1. Open Processes > Integration Processes
    2. Click Modify on the Realtime integration
    3. Navigate to the Options tab
    4. Make sure both Save Processing Errors and Save errors to System Events are checked
    5. Click Save
  1. Check the Log Action is set on the Realtime data source
    1. Navigate to Data Sources > Realtime Triggers
    2. Edit the Realtime data source
    3. Click Validate
    4. Set the Log Action to Save Failures
    5. Click Save

2. Run a Test

Now that we have verified all the logging settings are configured, we’ll run a test change and check the logs.

  1. Log into NetSuite and update the record you are tracking, in my case this is Customer.
  2. Click Save on the record.
  3. Log into SmartConnect.
  4. Check your SmartConnect Dashboard for recent runs. If your integration is in the list, then the trigger fired successfully.

If the run doesn’t show on the Dashboard, proceed to step 3. Check Deployment and Logs

  1. If the integration completes successfully, but no data is sent to the integration target, check the following.
    1. Open Processes > Integration Processes
    2. Click Modify on the Realtime integration
    3. Navigate to the Target tab
    4. Make sure the target tenant selected is the correct value
    5. Make sure the Run to file option is unchecked
    6. Navigate to the Integration > Restriction tab
    7. Check for a restriction that is preventing this record from being sent to the target
  1. If the integration fails check the following.
    1. Open Processes > Error Processing
    2. Locate the Realtime integration in the list and expand the run errors
    3. Click Edit on the top error
  1. In the Process Errors window, click on the Red (!) button to view the error message
  2. If possible, resolve this error and run another test
  1. Another place to check is Process History > System Events
  2. Search for the Integration Process Id
    1. This will show all errors related to the process, including scripting errors
  1. Finally, we can check Process History > Realtime Request Logs
  2. Click on the Magnifying glass icon for the record that failed
    1. This will show the formatted data set received from NetSuite
  3. Click the Download icon for the record that failed
    1. This will download the raw data received from NetSuite

3. Check Deployment Logs

If the real-time request isn’t making it to SmartConnect, we will want to check the logs in NetSuite to see why the data isn’t making it to SmartConnect.

  1. Log into NetSuite > Customization > Scripting > Script Deployments
  2. Filter the list for your deployment
    • TYPE = User Event
    • RECORD TYPE = Table you are trigger the source based on
  3. Click View
  1. Make sure the STATUS of the Script Deployment is Released
  2. Click on the Execution Log sub tab
  3. Review the execution logs for any errors you can resolve

If you are unsure of the resolution, you can try updating the script with a new value from SmartConnect.

  1. Click on the SCRIPT link
  1. Click Edit on the SCRIPT FILE
  1. Paste in a new version of the Real-Time data source script

Download a new version of the Real-Time data source by opening the data source and clicking Register again.

  1. Click Save on the Script File window
  2. Run another test as outlined in 2. Run a Test

4. Check SOAP Web Services Usage Log

You can also check the SOAP Web Services Usage Log for a list of all web calls SmartConnect has made to NetSuite.

  1. Open NetSuite > Setup > Integration > SOAP Web Services Usage Log
  2. Filter for the date range you attempted to run the integration
  3. Locate your expected call, and check the RESPONSE value to see if the data sent to SmartConnect is what you expected

If your data source request isn’t in this list, it likely failed on the User Event trigger.

SoapUsageLog

Conclusion

If none of these steps revealed/solved the issue with your real-time data source, please reach out to our support team at support@eonesolutions.com.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.