Share via

I’m experiencing issues loading Netsuite transaction table data into ADLS Gen2 via an ODBC connection in Azure Synapse. What are the recommended troubleshooting steps or configuration changes to fix this?

Suraj Surendran 60 Reputation points
2025-11-27T15:23:44.1333333+00:00

{ "errorCode": "2200", "message": "Failure happened on 'Source' side. 'Type=System.InvalidOperationException,Message=The connection has been disabled.,Source=System.Data,''Type=System.Data.Odbc.OdbcException,Message=ERROR [08S01] [NetSuite][ODBC 64bit driver][64bit Client]TCP/IP, connection reset by peer,Source=NQoa27.dll,'", "failureType": "UserError", "target": "Copy data1", "details": [] }

I’m using Azure Synapse to extract Netsuite transaction table data into ADLS Gen2 via an ODBC connection. The pipeline keeps failing due to timeout errors, and the ODBC connection intermittently gets disabled during runtime, causing the entire load process to stop. Has anyone encountered similar connection-disabled or timeout issues with ODBC in Synapse, and what are the recommended fixes or configurations to stabilize the data load?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2025-11-27T15:23:56.9666667+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To troubleshoot the issues you're experiencing with loading Netsuite transaction table data into ADLS Gen2 via an ODBC connection in Azure Synapse, consider the following steps:

    1. Check Connection String: Ensure that your ODBC connection string is correctly configured. Verify that all parameters such as server address, database name, user ID, and password are accurate. Sample ODBC connection string: 
         Driver={SQL Server Native Client 11.0};Server=tcp:{your_server}.database.windows.net,1433;Database={your_database};Uid={your_user_name};Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;
    2. Connection Timeout: Increase the connection timeout setting in your connection string to allow for longer connection attempts. Consider setting it to 300 seconds to accommodate any temporary network issues.
    3. ODBC Driver Version: Ensure that you are using the latest version of the ODBC driver for Netsuite. An outdated driver may lead to compatibility issues.
    4. Network Stability: Check your network stability and ensure that there are no intermittent connectivity issues between Azure Synapse and the Netsuite ODBC driver. You can use tools to monitor network performance.
    5. Integration Runtime Configuration: Use the Diagnostics tab in the Integration Runtime Configuration Manager to test the connection. This can help identify if the connection is being reset or disabled during runtime.
      • Launch Integration Runtime Configuration Manager.
      • Switch to the Diagnostics tab.
      • Test the connection with the correct parameters.
    6. Load Balancing: If you're experiencing heavy load on the server, consider scaling up your dedicated SQL pool to handle more requests and reduce the chance of timeouts.
    7. Error Handling: Implement error handling in your pipeline to gracefully manage connection failures. This can include retries or logging errors for further analysis.

    If these steps do not resolve your issue, you may want to create a support ticket for further assistance from the Azure engineering team.

    References:

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.