Book a Demo

Author Topic: SQL error after PC wakes up from Sleep or Hibernate  (Read 7717 times)

steen.jensen

  • EA User
  • **
  • Posts: 181
  • Karma: +8/-1
    • View Profile
SQL error after PC wakes up from Sleep or Hibernate
« on: August 20, 2023, 08:35:12 am »
Anyone having SQL-connection problem when CLient (EA 16.1 &4 bit om Win10 & 11) wakes up after sleep or hibernation??
Problem ocurs  only in v 16.x, did not occurs in EA v 15. Have to terminate Sparx EA program execution with Windows Task kill.
Using MS SQL DB-server. (We are about 50 users with same problem with just EA v 16.x ) Other users (35.000 with 800 apps have not this sleep & hibernate problem at all)
Have reportet as a error to SParx support but no replay after 3 month, still under investigation..... :(

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: SQL error after PC wakes up from Sleep or Hibernate
« Reply #1 on: August 20, 2023, 05:32:26 pm »
Send another priority bug report. And one more - for each license you paid. Kick the butt of your Sparx sales representative...

q.

BobM

  • EA User
  • **
  • Posts: 144
  • Karma: +9/-0
    • View Profile
Re: SQL error after PC wakes up from Sleep or Hibernate
« Reply #2 on: August 21, 2023, 04:28:35 pm »
Using MS SQL and procloud setup as well and I can't recall people complaining having connection issues recently (in 16.0 there were frequent complaints)
I just tested it on my system and I had no issue with Sparx waking up from hibernation.

I think the problem is that they can't reproduce it on their systems neither.

Are both procloud server and the clients up-to-date?
Is there a specific timing where it gets difficult after hibernation? My test was hibernate -> wake up within 5 minutes (Our procloud session time out timer is set to 30mins)
Is hibernation paired with the action of moving to different rooms in the building where there might be a network change involved?

steen.jensen

  • EA User
  • **
  • Posts: 181
  • Karma: +8/-1
    • View Profile
Re: SQL error after PC wakes up from Sleep or Hibernate
« Reply #3 on: August 22, 2023, 07:22:07 am »
Just normal Server connection to MS-SQL database, no add-in, no PCS