Author Topic: PCS Warning log: Failed to set Database Driver folder for PostgreSQL  (Read 5536 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1365
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Hello,

I updated the PCS with version 6.0.163 64 bits for the access from EA 16.1 clients to shared EA Postgres databases.
Whilst EA works ok, I noticed several of the following Warning messages in the PCS logs file before the connection is successfully opened.

Any idea what could be the issue ? Note that the PCS is installed under the E: drive e.g. E:\Program Files\Sparx Systems\Pro Cloud Server\

2025-04-07 09:05:06 [WARNING]: Failed to set Database Driver folder for PostgreSQL
2025-04-07 09:05:06 [SYSTEM]:  Thread 123931  SUCCESS Opened new database connection to ssdb: ...

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Elpis

  • EA User
  • **
  • Posts: 44
  • Karma: +7/-0
  • Make MDA/MBSE vital.
    • View Profile
Re: PCS Warning log: Failed to set Database Driver folder for PostgreSQL
« Reply #1 on: April 11, 2025, 09:41:16 pm »
I post very same issue to Sparx more than year ago (PCS 5.1.128 64bit). Unfortunatelly, they were not able to reproduce it.
My observation is, all of mentioned warnings are preceding establishing database connection (PCS manages pool of open connections, I presume), like below:
2024-01-15 14:21:19 [SYSTEM]:   MANAGEMENT:  Removed 1 database connections to ssdb:ea_repo@localhost@ea_repo
2024-01-15 14:23:15 [WARNING]: Failed to set Database Driver folder for PostgreSQL
2024-01-15 14:23:15 [SYSTEM]:  Thread 9883  SUCCESS Opened new database connection to ssdb:ea_repo@localhost@ea_repo

Sometimes the warning is absent for a long time (usually after PCS restart), then starts to appear very often (on every re-opening of database connection).
We use native connection to the PostgreSQL database and PCS is installed on C: drive.
« Last Edit: April 11, 2025, 10:25:43 pm by Elpis »

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1365
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Re: PCS Warning log: Failed to set Database Driver folder for PostgreSQL
« Reply #2 on: April 11, 2025, 11:08:11 pm »
Thanks for info.
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com