Sparx Systems Forum
Enterprise Architect => Bugs and Issues => Topic started by: mcamack on January 24, 2017, 04:58:25 am
-
We are working with EA from Windows 7 machines, but trying to transfer the EA project onto a Linux server PostgreSQL database. After installing postgres and running the script to setup the tables we try to transfer the project, but get lots of errors in the log similar to what I've copied below. It makes me think the schema was not setup correctly, but our Linux and Windows machines have updated ODBC drivers, is there a step I'm missing trying to do this between Windows and Linux machines?
Why does it start with removing data??
+--------------------------------------------
| Data Transfer model log file
| Generated by Enterprise Architect
| Source DBMS: JET
| Target DBMS: POSTGRES
| Created On : Thursday, 19 January, 2017
+--------------------------------------------
2017-01-19 11:56:26 Removing data in: t_rtf
2017-01-19 11:56:26 Removing data in: t_secuserpermission
2017-01-19 11:56:26 Removing data in: t_secusergroup
2017-01-19 11:56:26 Removing data in: t_document
2017-01-19 11:56:26 Removing data in: t_seclocks
...
...
...
ERROR: relation "usys_system" does not exist;
Error while executing the query
ERROR: An error has occurred:
Microsoft OLE DB Provider for ODBC Drivers [-2147467259]
ERROR: relation "t_secpolicies" does not exist;
Error while executing the query
ERROR: An error has occurred:
Microsoft OLE DB Provider for ODBC Drivers [-2147467259]
ERROR: relation "usystables" does not exist;
Error while executing the query
-
Just recover usys_system and usystables from an existing EAP manually. For some reason they vanish from time to time (at least you're not the first missing them). They are static tables and the same for all repositories.
q.
-
Thank you for the reply, but it turns out the schema file was not being run properly... which makes sense why it couldn't find the Tables. Problem solved.