# Intermittent Query failures to NetSuite - also, new to Cdata Connect Cloud **URL:** \ **Category:** CData Connect Cloud\ **Tags:** cdata-connect, question, power-bi, netsuite\ **Created:** [December 19, 2024, 2:01am UTC](https://community.cdata.com/t/intermittent-query-failures-to-netsuite-also-new-to-cdata-connect-cloud/976 "2024-12-19T02:01:44Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![jfuhrman](https://avatars.discourse-cdn.com/v4/letter/j/ba9def/32.png) [@jfuhrman](https://community.cdata.com/u/jfuhrman)\ **Post date:** [December 19, 2024, 2:02am UTC](https://community.cdata.com/t/intermittent-query-failures-to-netsuite-also-new-to-cdata-connect-cloud/976/1 "2024-12-19T02:02:15Z")
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: ```auto   ``` SELECT [NetSuite\_Suitetalk\_Prod].[SuiteTalk].[EBC\_PandL\_JEs\_and\_Status].[basic\_status] AS [basic\_status] FROM [NetSuite\_Suitetalk\_Prod].[SuiteTalk].[EBC\_PandL\_JEs\_and\_Status] Error Code ```auto   ``` QUERY\_INCOMPLETE Error Message ```auto   ``` The following error interrupted result set serialization (results may be incomplete): ServletOutputStream failed to write: java.io.IOException: Broken pipe \ A success using the same connection is below: Query Id ```auto   ``` 3e200903-712a-41da-b152-df9b4a4a79e0 ```auto   ``` SELECT [NetSuite\_Suitetalk\_Prod].[SuiteTalk].[EBC\_PandL\_JEs\_and\_Status].[basic\_transactionnumber] AS [basic\_transactionnumber] FROM [NetSuite\_Suitetalk\_Prod].[SuiteTalk].[EBC\_PandL\_JEs\_and\_Status] Duration ```auto   ``` 7173 ms * * * Other error’s I’m getting: **Error Message** ```auto 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** ```auto The query failed with the following error:[WS_REQUEST_BLOCKED] SuiteTalk concurrent request limit exceeded. Request blocked. ``` **Error Message** ```auto 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: ``` ---
**Author:** ![Tapan18118](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Tapan18118](https://community.cdata.com/u/Tapan18118)\ **Post date:** [December 19, 2024, 11:59am UTC](https://community.cdata.com/t/intermittent-query-failures-to-netsuite-also-new-to-cdata-connect-cloud/976/2 "2024-12-19T11:59:45Z")
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. ![3a523471-62c8-439d-8047-3638a7028369.png](https://us1.discourse-cdn.com/cdata/original/2X/3/3e38e55af688c902a8617ed7835e77171483aeed.png) 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: ```auto The query failed with the following error:[WS_REQUEST_BLOCKED] SuiteTalk concurrent request limit exceeded. Request blocked. ``` 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 _**[WS\_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](https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/bridgehead_156224824287.html) To resolve this issue promptly, I recommend submitting a separate support ticket through the [CData - Support Form](https://www.cdata.com/support/submit.aspx) Be sure to include **Verbosity 5** logs for your connection so we can thoroughly investigate and diagnose the problem. I hope this helps!! ---
**Author:** ![jfuhrman](https://avatars.discourse-cdn.com/v4/letter/j/ba9def/32.png) [@jfuhrman](https://community.cdata.com/u/jfuhrman)\ **Post date:** [December 19, 2024, 6:10pm UTC](https://community.cdata.com/t/intermittent-query-failures-to-netsuite-also-new-to-cdata-connect-cloud/976/3 "2024-12-19T18:10:22Z")
​ @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! ---
**Author:** ![Tapan18118](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Tapan18118](https://community.cdata.com/u/Tapan18118)\ **Post date:** [December 20, 2024, 6:35am UTC](https://community.cdata.com/t/intermittent-query-failures-to-netsuite-also-new-to-cdata-connect-cloud/976/4 "2024-12-20T06:35:15Z")
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.