Author Topic: TimeOut with Queries and Import large Packages, Change Package Name takes 2 seco  (Read 4740 times)

Helmut Ortmann

  • EA User
  • **
  • Posts: 967
  • Karma: +42/-1
    • View Profile
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
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

qwerty

  • EA Guru
  • *****
  • Posts: 13525
  • Karma: +395/-300
  • I'm no guru at all
    • View Profile
You should probably state your EA version and the used DB.

q.

Modesto Vega

  • EA Practitioner
  • ***
  • Posts: 1055
  • Karma: +28/-8
    • View Profile
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?

Helmut Ortmann

  • EA User
  • **
  • Posts: 967
  • Karma: +42/-1
    • View Profile
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
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

wivel

  • EA User
  • **
  • Posts: 241
  • Karma: +12/-1
  • Driven by Models
    • View Profile
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

Modesto Vega

  • EA Practitioner
  • ***
  • Posts: 1055
  • Karma: +28/-8
    • View Profile
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.