Question

Displaying the records in UI - Communication Failure

Sri Saranya
11:37 Nov 20, 2020

Hi Team,

 

We have a scenario where the api returns a response with 33101 records, in server side it does not throw any error , but when we try to load the same in the virtual detail in ui, it throws some communication failure error. We have also distributed the license so that we should be able to add ore than 1000 records

 

this is the error we get

 

  1. aborted: undefined
  2. request:
    1. async: true
    2. binary: false
    3. headers: {Content-Type: "application/json", X-Requested-With: "XMLHttpRequest"}
    4. id: 45
    5. options: {url: "http://ilrnasbsa01:7155/0/rest/StandardPriceService/GetRateTableReport", method: "GET", headers: {…}, params: {…}, success: ƒ, …}
    6. timedout: true
    7. __proto__: Object
  3. requestId: 45
  4. status: 0
  5. statusText: "communication failure"
  6. timedout: true

 

Kindly guide us on how to resolve the same

Like 0

Like

3 comments
Oleg Drobina
12:40 Nov 20, 2020

Hi Saranya,

 

Please start with the value for the "DataServiceQueryTimeout" system setting (Redis should be flushed after the value is modified). It is  120000 by default, try specifying 1200000 milliseconds there.

 

Also try modifying the ConnectionStrings.config file and specify the Connection Timeout parameter there in the <db> block as:

 

  <add name="db" connectionString="Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.14.32)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = BPMBUILD) (SERVER = DEDICATED)));User Id=SE_M_SE7164ENU;Password=SE_M_SE7164ENU;Connection Timeout=10500" />

 

After that try to call for a webservice once again.

 

Best regards,

Oscar

Sri Saranya
12:09 Nov 25, 2020

Hi Oscar,

 

We have made changes as mentioned above. But still we are facing the same issue. Kindly help us resolving the same asap as the client is waiting on it

Oleg Drobina
08:24 Nov 27, 2020

Sri Saranya,

 

Theoretically, there are lot of places that specify different timeouts: user session timeout, database connection timeout, IIS connection timeout and a lot more. Depends on the service functionality, you'll need to increase some of them. 

 

Please find more information in the article by the link below.

https://www.techcartnow.com/increase-timeout-asp-net-application/

 

and

 

https://academy.bpmonline.com/documents/technic-sdk/7-13/setting-user-session-timeout

 

Again, it's only theoretically. In practice, changing the timeout will 100% lead to destroying either the application or the server. It is better to get less data per request rather than increasing the timeout.

 

Also try modifying the MaxEntityRowCount parameter value in the \Terrasoft.WebApp\Web.config file to 50000 and restart the application in IIS.

 

These are all recommendations that can help. Otherwise less data should be loaded to the virtual detail in the UI.

 

Best regards,

Oscar

Show all comments