Skip to main content

I wanted to reach out regarding some issues I'm having with a NetSuite integration in our CData Connect Cloud instance. The failures seem to be intermittent, some queries using the same connection work, others do not. I wanted to see if there were methods I could use to have better success rates or if others had experienced similar issues? Given that NetSuite is our ERP system, and the inconsistent failures (sometimes the same query will complete successfully, other times it won’t - i suspect it could just be that during the work day, there simply aren’t enough resources and the queries get rejected.

We’re using Power BI for semantic model development, and Connect Cloud as the intermediary between Power BI and NetSuite.  In our Sandbox environment, so such issues or failures occur when attempting to refresh the semantic model.

An example of a failure I received today is below:

 

SELECT >NetSuite_Suitetalk_Prod].kSuiteTalk].tEBC_PandL_JEs_and_Status].Sbasic_status] AS tbasic_status] FROM sNetSuite_Suitetalk_Prod].kSuiteTalk].tEBC_PandL_JEs_and_Status]

Error Code

 

QUERY_INCOMPLETE

Error Message

 

The following error interrupted result set serialization (results may be incomplete): ServletOutputStream failed to write: java.io.IOException: Broken pipe <Query ID: 0a62d32c-6455-4cbf-bb9c-1312b841d28c>

 

A success using the same connection is below:

Query Id

 

3e200903-712a-41da-b152-df9b4a4a79e0

 

 

SELECT pNetSuite_Suitetalk_Prod].iSuiteTalk].]EBC_PandL_JEs_and_Status].sbasic_transactionnumber] AS ibasic_transactionnumber] FROM nNetSuite_Suitetalk_Prod].iSuiteTalk].]EBC_PandL_JEs_and_Status]

Duration

 

7173 ms

 

Other error’s I’m getting:

Error Message

The query failed with the following error: Cannot obtain connection for 'NetSuite_SuiteQL_Prod': Failed to open connection for driver 'NetSuite' and channel Current due to the following error:HTTP 429: Too many requests

 

Error Message

The query failed with the following error: WS_REQUEST_BLOCKED] SuiteTalk concurrent request limit exceeded. Request blocked.<Query ID: 273974ac-3e1a-4025-af7b-b769790b8727>


Error Message

The query failed with the following error: Cannot obtain connection for 'NetSuite_Suitetalk_Prod': Failed to open connection for driver 'NetSuite' and channel Current due to the following error:

 

Hi ​@jfuhrman 

Thanks for reaching out to CData Community.

If I understand your query correctly, you are currently attempting to execute a query for your Suite Talk schema connection and encountering multiple issues typically while trying to refresh the semantic model within PowerBI.  I will try to provide context for each of these issues below:

As for the query that you shared appears to be correctly structured. I was able to execute it successfully on my end without any issues within Data Explorer as well as within PowerBI. 

 


As for the mentioned Query Id : 0a62d32c-6455-4cbf-bb9c-1312b841d28c, I couldn’t find any specific errors related to the "Broken pipe" exception in the logs. However, for the other errors, specifically:

The query failed with the following error:wWS_REQUEST_BLOCKED] SuiteTalk concurrent request limit exceeded. Request blocked.<Query ID: 273974ac-3e1a-4025-af7b-b769790b8727>

This error indicates that your NetSuite account’s Concurrency Limit is being exceeded. In simpler terms, too many API requests are being sent simultaneously, surpassing the allowed limit for your account.

For Instance: If your concurrency limit is set to 5 and you attempt to send 7 requests simultaneously:

  1. Requests A, B, C, D and E starts at 10:00.
  2. Request F and G also attempt to start at 10:00. Then F and G will fail with the error rWS_REQUEST_BLOCKED].

You can get details of the concurrency limit for your NetSuite account from Setup > Integration > Manage Integrations : Account Concurrency Limit.

For more information on NetSuite’s concurrency limits, you can refer to the official documentation: NetSuite Applications Suite - Concurrency Limit per Integration

 

To resolve this issue promptly, I recommend submitting a separate support ticket through the CData - Support Form Be sure to include Verbosity 5 logs for your connection so we can thoroughly investigate and diagnose the problem.

 

I hope this helps!! 

​@Tapan18118 - thanks very much for the prompt reply! Upon your advice, i changed the concurrency limit and things work much better now! I appreciate the help a ton!

Hi ​@jfuhrman 

I'm glad to hear that the provided solution was helpful! I also noticed that you've raised a ticket with us. Please feel free to follow up with the team to address any other reported issues as well.

Terms and ConditionsCookie settings