EA hangs / crashes when the DBMS is down

[Guillaume]

Hi

We worked with a shared EA project on a SQL Server DBMS.
Since yesterday evening, the DBMS seems to be down. That makes EA crash (EA not responding) and the user experience is quite bad.
Couldn't this be fixed in EA so it displays an error message to the user and stops attempting connecting to SQL Server?
It seems EA attempts forever to connect to the DBMS.

thanks

[OpenIT Solutions]

If the database is down you should get a timeout message after say 30 - 120 seconds, depending on some standard OLE DB settings. However we have had an issue with sleeping sessions on SQL Server hanging all other sessions, in this scenario Sparx clients just hang, until the offending session is killed.

I've raised a support case with Sparx re this issue, ill keep you posted.

Regards,

Jon.