Author Topic: Postgres-related crashing. ODBC Keep Alive?  (Read 709 times)

bknoth2

  • EA User
  • **
  • Posts: 59
  • Karma: +0/-0
    • View Profile
Postgres-related crashing. ODBC Keep Alive?
« 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

qwerty

  • EA Guru
  • *****
  • Posts: 9361
  • Karma: +144/-137
  • I'm no guru at all
    • View Profile
Re: Postgres-related crashing. ODBC Keep Alive?
« Reply #1 on: December 15, 2017, 10:37:25 am »
https://www.postgresql.org/message-id/4C07D083.8010605@tpf.co.jp is one of many Postgres related Google results.

q.

VKN

  • EA User
  • **
  • Posts: 183
  • Karma: +9/-1
    • View Profile
Re: Postgres-related crashing. ODBC Keep Alive?
« Reply #2 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

bknoth2

  • EA User
  • **
  • Posts: 59
  • Karma: +0/-0
    • View Profile
Re: Postgres-related crashing. ODBC Keep Alive?
« Reply #3 on: December 16, 2017, 03:26:17 am »
Thanks. I do have that configuration. I'll upgrade the driver.

- Bruce