Sparx Systems Forum

Discussion => General Board => Topic started by: bknoth2 on December 15, 2017, 09:38:55 am

Title: Postgres-related crashing. ODBC Keep Alive?
Post by: bknoth2 on December 15, 2017, 09:38:55 am
I just started using Postgres (9.03 32 bit ODBC driver) with EA (13.5.1351) on Win 10. EA seems to crash if I stop working with a model for a while. (EA crashes - I'm guessing that it has to do with lack of activity). I did not have this problem when working with the same model in an EAP file.

It's as if there's a timeout somewhere, maybe in the ODBC connection? Any thoughts or insights?

Thanks
Title: Re: Postgres-related crashing. ODBC Keep Alive?
Post by: qwerty on December 15, 2017, 10:37:25 am
https://www.postgresql.org/message-id/4C07D083.8010605@tpf.co.jp (https://www.postgresql.org/message-id/4C07D083.8010605@tpf.co.jp) is one of many Postgres related Google results.

q.
Title: Re: Postgres-related crashing. ODBC Keep Alive?
Post by: VKN on December 15, 2017, 10:44:04 am
The ODBC need to be upgraded, 9.03 is known to be having issues with EA.

Also, you have to make sure that the configuration is as mentioned in this link.

http://sparxsystems.com/enterprise_architect_user_guide/13.5/model_repository/setupapostgresqlodbcdriver.html (http://sparxsystems.com/enterprise_architect_user_guide/13.5/model_repository/setupapostgresqlodbcdriver.html)
Title: Re: Postgres-related crashing. ODBC Keep Alive?
Post by: bknoth2 on December 16, 2017, 03:26:17 am
Thanks. I do have that configuration. I'll upgrade the driver.

- Bruce