Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Thomas Arnbjerg on October 26, 2022, 01:36:39 am

Title: PostgreSQL DBMS
Post by: Thomas Arnbjerg on October 26, 2022, 01:36:39 am

I'm trying to configure a PostgreSQL repository.

1) 32 bit ODBC driver is installed (version 13.x)
2) ODBC datasource configured according to https://sparxsystems.com/enterprise_architect_user_guide/15.2/model_repositories/setupapostgresqlodbcdriver.html
Test connection succeeds.
3) The PostgreSQL database has been created on a remote Debian 11 and EASchema*.sql has been run. The tables are present in the database as seen in pgAdmin running on the same machine as EA. A user has been created for EA and permissions on all EA tables look correct in pgAdmin.

When I try to transfer an eapx file to the new repository i get the error 'All Enterprise architect tables in the target repository are missing...'

Any suggestions on how to troubleshoot this?
Thx
Thomas

Title: Re: PostgreSQL DBMS
Post by: qwerty on October 26, 2022, 08:25:09 am

Maybe some authorization issue (just guessing). Try accessing the DB as admin.

q.

Title: Re: PostgreSQL DBMS
Post by: Thomas Arnbjerg on October 26, 2022, 05:15:35 pm

Found the root cause 40 cm in front of the screen. I used the wrong version of the schema file.

Title: Re: PostgreSQL DBMS
Post by: Geert Bellekens on October 26, 2022, 05:45:38 pm

Quote from: Thomas Arnbjerg on October 26, 2022, 05:15:35 pm

Found the root cause 40 cm in front of the screen. I used the wrong version of the schema file.

Ah, the famous PEBCAC problem  ;D

Geert