Sparx Systems Forum

Pro Cloud Server / Prolaborate / WebEA => PCS Bugs and Issues => Topic started by: Helmut Ortmann on July 05, 2022, 10:14:51 pm

Title: TimeOut with Queries and Import large Packages, Change Package Name takes 2 seco
Post by: Helmut Ortmann on July 05, 2022, 10:14:51 pm

Hello,

we have a lot of issues with TimeOut and unaccountable long GUI response times.

1. Timeout
- Some queries are sometimes leading to TimeOut (around 60 seconds)
- Import large packages lead to Iimeout (around 60 seconds)
2. Rename Package: Slow GUI, fast Script
- If I rename a package with the EA GUI it takes about 2 seconds
- If I rename a package with JScript from within EA it changes it immidiately

I've seen in this forum threads about TimeOut.

Any idea or experiences?

Thanks and best regards,

Helmut

Title: Re: TimeOut with Queries and Import large Packages, Change Package Name takes 2 seco
Post by: qwerty on July 05, 2022, 11:13:03 pm

You should probably state your EA version and the used DB.

q.

Title: Re: TimeOut with Queries and Import large Packages, Change Package Name takes 2 seco
Post by: Modesto Vega on July 06, 2022, 11:17:01 pm

In addition to the info Thomas was asking for, can you please confirm if Sparx EA is connecting to database repository directly or via PCS? If it is connecting to repository is there a VPN involved?

Title: Re: TimeOut with Queries and Import large Packages, Change Package Name takes 2 seco
Post by: Helmut Ortmann on July 07, 2022, 09:41:50 pm

Hello,

Thanks for your valuable questions. My revised question:

Environment:
- EA 15.2 Build 1555
- PCS Version 4.2.66
- DB MySQL, connected via PCS to EA (no direct access to MySQL from EA, only via PCS)
1. Timeout
- Some queries are sometimes leading to TimeOut (around 60 seconds)
- Import large packages lead to a timeout (around 60 seconds)
2. Rename Package: Slow GUI, fast Script
- If I rename a package with the EA GUI it takes about 2 seconds
- If I rename a package with JScript from within EA it changes it immediately

EA works fine except for the above-described issues with large Repositories and some big queries. In smaller Repositories, there are no issues. It looks as if the issue only appears in situations with a great load. In the evening it often runs smoothly.


Thanks and best regards,

Helmut

Title: Re: TimeOut with Queries and Import large Packages, Change Package Name takes 2 seco
Post by: wivel on July 07, 2022, 11:12:17 pm

Hi

In EA 15.2 build 1560 there is an option to set the maximum query time for PCS connections. It is located under Configure -> Options -> Cloud. Think it was introduced in build 1559, so perhaps you need to upgrade.

Henrik

Title: Re: TimeOut with Queries and Import large Packages, Change Package Name takes 2 seco
Post by: Modesto Vega on July 11, 2022, 07:19:33 pm

We have noticed a similar behaviour with build 1560. The most obvious symptom is the UI temporarily freezing, with freezes lasting from a few seconds to several minutes. The 2 key differences are:

• Both UI and scripted operations (we use VB script) have a similar delay over PCS.
• The UI also freezes when working offline.

Security policies could be playing a role but we have not managed to diagnose the cause of the problem.